V$CONTROLFILE_RECORD_SECTION
This view displays information about the control file record sections.
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