V$CONTROLFILE_RECORD_SECTION

Oracle 11gR1

V$CONTROLFILE_RECORD_SECTION displays information about the control file record sections.

Column	Datatype	Description
TYPE	VARCHAR2(28)	Identifies the type of record section: · DATABASE · CKPT PROGRESS · REDO THREAD · REDO LOG · DATAFILE · FILENAME · TABLESPACE · TEMPORARY FILENAME · RMAN CONFIGURATION · LOG HISTORY · OFFLINE RANGE · ARCHIVED LOG · BACKUP SET · BACKUP PIECE · BACKUP DATAFILE · BACKUP REDOLOG · DATAFILE COPY · BACKUP CORRUPTION · COPY CORRUPTION · DELETED OBJECT · PROXY COPY · BACKUP SPFILE · DATABASE INCARNATION · FLASHBACK LOG · RECOVERY DESTINATION · INSTANCE SPACE RESERVATION · REMOVABLE RECOVERY FILES · RMAN STATUS · THREAD INSTANCE NAME MAPPING · MTTR · DATAFILE HISTORY
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

Note:

1.

select * from V$CONTROLFILE_RECORD_SECTION;

TYPE	RECORD_ SIZE	RECORDS_ TOTAL	RECORDS_ USED	FIRST_ INDEX	LAST_ INDEX	LAST_ RECID
DATABASE	316	1	1	0	0	0
CKPT PROGRESS	8180	4	0	0	0	0
REDO THREAD	256	1	1	0	0	0
REDO LOG	72	20	15	0	0	128
DATAFILE	428	798	512	0	0	2166
FILENAME	524	2809	554	0	0	0
TABLESPACE	68	300	124	0	0	159
TEMPORARY FILENAME	56	300	38	0	0	95
RMAN CONFIGURATION	1108	50	2	0	0	6
LOG HISTORY	56	20450	20450	5005	5004	376730
OFFLINE RANGE	200	584	0	0	0	0
ARCHIVED LOG	584	20309	20309	17993	17992	376739
BACKUP SET	40	4090	4090	3525	3524	192073
BACKUP PIECE	736	3734	3734	627	626	192073
BACKUP DATAFILE	116	5076	5076	3352	3351	275904
BACKUP REDOLOG	76	14636	14636	11204	11203	329751
DATAFILE COPY	660	619	260	1	260	260
BACKUP CORRUPTION	44	371	0	0	0	0
COPY CORRUPTION	40	409	0	0	0	0
DELETED OBJECT	20	65535	65535	9906	9905	794594
PROXY COPY	852	652	0	0	0	0
BACKUP SPFILE	36	454	136	1	136	136
DATABASE INCARNATION	56	292	1	1	1	1
FLASHBACK LOG	84	2048	0	0	0	0
RECOVERY DESTINATION	180	1	0	0	0	0
INSTANCE SPACE RESERVATION	28	1055	1	0	0	0
REMOVABLE RECOVERY FILES	32	1000	0	0	0	0
RMAN STATUS	116	1128	1128	538	537	17880
THREAD INSTANCE NAME MAPPING	80	1	1	0	0	0
MTTR	100	1	1	0	0	0
DATAFILE HISTORY	568	57	0	0	0	0
STANDBY DATABASE MATRIX	400	10	10	0	0	0
GUARANTEED RESTORE POINT	212	2048	0	0	0	0
RESTORE POINT	212	2083	0	0	0	0

Oracle dynamic performance views