오라클 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,

       SPACE_RECLAIMABLE AS reclaimable,

       NUMBER_OF_FILES AS "number"

  FROM V$RECOVERY_FILE_DEST;

NAME	TOTAL_SIZE	USED	RECLAIMABLE	number
+RECOC1	1.88534E+12	184549376	0	1