티스토리 뷰

반응형

아카이브로그 사용량 보기 


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


반응형
댓글
반응형
공지사항
최근에 올라온 글
최근에 달린 댓글
Total
Today
Yesterday
«   2024/12   »
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31
글 보관함