SQL> select type, records_used, records_total,
2 records_used/records_total*100 "PCT_USED"
3 from sys.v_$controlfile_record_section
4 /
TYPE RECORDS_USED RECORDS_TOTAL PCT_USED
---------------------------- ------------ ------------- ----------
DATABASE 1 1 100
CKPT PROGRESS 0 11 0
REDO THREAD 1 8 12.5
REDO LOG 3 16 18.75
DATAFILE 8 100 8
FILENAME 12 149 8.05369127
TABLESPACE 8 100 8
TEMPORARY FILENAME 1 100 1
RMAN CONFIGURATION 0 50 0
LOG HISTORY 121 454 26.6519823
OFFLINE RANGE 0 292 0
ARCHIVED LOG 117 224 52.2321428
BACKUP SET 0 409 0
BACKUP PIECE 0 200 0
BACKUP DATAFILE 0 282 0
BACKUP REDOLOG 0 215 0
DATAFILE COPY 0 223 0
BACKUP CORRUPTION 0 371 0
COPY CORRUPTION 0 409 0
DELETED OBJECT 0 818 0
TYPE RECORDS_USED RECORDS_TOTAL PCT_USED
---------------------------- ------------ ------------- ----------
PROXY COPY 0 249 0
BACKUP SPFILE 0 454 0
DATABASE INCARNATION 2 292 0.68493150
FLASHBACK LOG 0 2048 0
RECOVERY DESTINATION 1 1 100
INSTANCE SPACE RESERVATION 1 63 1.58730158
REMOVABLE RECOVERY FILES 0 1000 0
RMAN STATUS 0 141 0
THREAD INSTANCE NAME MAPPING 8 8 100
MTTR 1 8 12.5
DATAFILE HISTORY 0 57 0
阅读(1198) | 评论(0) | 转发(0) |
