오라클 Oracle ARCHIVED LOG REDO LOG 아카이브로그 사용량 보기
아카이브로그 사용량 보기 SELECT FILE_TYPE, PERCENT_SPACE_USED AS USED, PERCENT_SPACE_RECLAIMABLE AS RECLAIMABLE, NUMBER_OF_FILES AS "number" FROM V$FLASH_RECOVERY_AREA_USAGE; FILE_TYPE USED RECLAIMABLE number CONTROL FILE 0.01 0 1 REDO LOG 0 0 0 ARCHIVED LOG 0 0 0 BACKUP PIECE 0 0 0 IMAGE COPY 0 0 0 FLASHBACK LOG 0 0 0 FOREIGN ARCHIVED LOG 0 0 0 SELECT name, space_limit AS Total_size, space_used AS Used, S..
개발자이야기/Oracle
2016. 2. 11. 09:26