Dynamic Performance (V$) Views, 31 of 179

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