Oracle Database: flash_recovery_area full?

Advertisements
SELECT 
    NAME, 
    TO_CHAR(SPACE_LIMIT, '999,999,999,999') AS SPACE_LIMIT,
    TO_CHAR(SPACE_LIMIT - SPACE_USED + SPACE_RECLAIMABLE, '999,999,999,999')
       AS SPACE_AVAILABLE,
    ROUND((SPACE_USED - SPACE_RECLAIMABLE)/SPACE_LIMIT * 100, 1)
       AS PERCENT_FULL
    FROM V$RECOVERY_FILE_DEST;

Resize flash_recovery_area:

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 180G;

[ad#ad-post]

Advertisements

Add a Comment

Your email address will not be published.