Home » RDBMS Server » Server Administration » Need Information on V$controlfile_record_section
Need Information on V$controlfile_record_section [message #222157] Fri, 02 March 2007 01:38 Go to next message
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
Re: Need Information on V$controlfile_record_section [message #222191 is a reply to message #222157] Fri, 02 March 2007 04:11 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
THis view is used in backup/recovery purposes. has nothing to do with performance.
Re: Need Information on V$controlfile_record_section [message #222214 is a reply to message #222157] Fri, 02 March 2007 05:50 Go to previous messageGo to next message
gkodakalla
Messages: 49
Registered: March 2005
Member
Thanks Mahesh for your reply.
Can you please explain details of the columns in v$controlfile_record_section.

Thanks.
Giridhar
Re: Need Information on V$controlfile_record_section [message #222215 is a reply to message #222214] Fri, 02 March 2007 05:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
well, i definetly cannot explain better than the docset.
IMHO, it is clearly defined.
I suggest you to google / search and comeup with specific question.
I googled and found this article to be useful to some extent
http://www.idevelopment.info/data/Oracle/DBA_tips/RMAN_9i/RMAN9_9.shtml#v$controlfile_record_section
Re: Need Information on V$controlfile_record_section [message #222269 is a reply to message #222157] Fri, 02 March 2007 10:31 Go to previous message
gkodakalla
Messages: 49
Registered: March 2005
Member
Thanks mahesh for pointing to the right link.
Giridhar
Previous Topic: Temporary tablespace Mgmt
Next Topic: oracle 10g server as client???
Goto Forum:
  


Current Time: Fri Dec 02 23:21:57 CST 2016

Total time taken to generate the page: 0.18702 seconds