| Need Information on V$controlfile_record_section [message #222157] |
Fri, 02 March 2007 01:38  |
gkodakalla
Messages: 49
Registered: March 2005
|
Member |
|
|
Hi,
I would like to know more details about V$CONTROLFILE_RECORD_SECTION.
From oracle documentation, i see the following:
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
============================================================
Can any one explain on the details of the columns and how we can use for any performance tuning (if applicable).
Thank You
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
