v$controlfile_record_section

9iR2 에서

TYPE                 RECORD_SIZE RECORDS_TOTAL RECORDS_USED FIRST_INDEX LAST_INDEX LAST_RECID
-------------------- ----------- ------------- ------------ ----------- ---------- ----------
DATABASE                     316             1            1           0          0          0
CKPT PROGRESS               4084             4            0           0          0          0
REDO THREAD                  228             1            1           0          0          0
REDO LOG                      72             5            3           0          0          3
DATAFILE                     428           150           41           0          0        162
FILENAME                     268           166           48           0          0          0
TABLESPACE                    68           150           40           0          0         52
TEMPORARY FILENAME            56           150            1           0          0          1
RMAN CONFIGURATION          1108            50            0           0          0          0
LOG HISTORY                   36           453          453         212        211       2702
OFFLINE RANGE                180           181            0           0          0          0
ARCHIVED LOG                 328            49           49          13         12       1920
BACKUP SET                    40           204            0           0          0          0
BACKUP PIECE                 480           306            0           0          0          0
BACKUP DATAFILE              116           352            0           0          0          0
BACKUP REDOLOG                76           107            0           0          0          0
DATAFILE COPY                404           303            0           0          0          0
BACKUP CORRUPTION             44           185            0           0          0          0
COPY CORRUPTION               40           204            0           0          0          0
DELETED OBJECT                20           408            0           0          0          0
PROXY COPY                   596           315            0           0          0          0
BACKUP SPFILE                 36           226            0           0          0          0
DATABASE INCARNATION          56           145            1           1          1          1