查 flash recovery usage
2013-07-29 21:48
SQL> set newpage 2
SQL> set pagesize 500 linesize 200
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ------------------------- ---------------
CONTROL FILE 0 0 0
REDO LOG 0 0 0
ARCHIVED LOG 22.38 0 44
BACKUP PIECE 0 0 0
IMAGE COPY 0 0 0
FLASHBACK LOG 0 0 0
FOREIGN ARCHIVED LOG 0 0 0
加大 Flash Recovery Area 空間
SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=20g;