V$CONTROLFILE_RECORD_SECTION
This view displays information about the control file record sections.
Column Datatype Description
TYPE
VARCHAR2(17)
Identifies the type of record section: DATABASE, CKPT PROGRESS, REDO THREAD, REDO LOG, DATAFILE, FILENAME, TABLESPACE, LOG HISTORY, OFFLINE RANGE, ARCHIVED LOG, BACKUP SET, BACKUP PIECE, BACKUP DATAFILE, BACKUP REDOLOG, DATAFILE COPY, BACKUP CORRUPTION, COPY CORRUPTION, DELETED OBJECT, or PROXY COPY
RECORD_SIZE
NUMBER
Record size in bytes
RECORDS_TOTAL
NUMBER
Number of records allocated for the section
RECORDS_USED
NUMBER
Number of records used in the section
FIRST_INDEX
NUMBER
Index (position) of the first record
LAST_INDEX
NUMBER
Index of the last record
LAST_RECID
NUMBER
Record ID of the last record
楼主，装个oracle文档吧！ |
