| Control file record section [message #56280] |
Mon, 17 March 2003 02:48  |
premchand
Messages: 1
Registered: March 2003
|
Junior Member |
|
|
Hai,
I need one info reg control file record section.
whats the purpose for using v$controlfile_record_section.pls explain.
regards
premchand
|
|
|
|
| Re: Control file record section [message #56287 is a reply to message #56280] |
Mon, 17 March 2003 04:42  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
Hi,
It shows what information is stored in the control files (very interesting info).
You can also see when you need to re-create your control files to increase the number of entries (or slots). For example is you are using 40 of out 40 available FILE slots, you cannot add another datafile to the DB unless you recreate the control file.
Best regards.
Frank
|
|
|
|
| Re: Control file record section [message #56289 is a reply to message #56280] |
Mon, 17 March 2003 05:31 |
Raj
Messages: 411
Registered: November 1998
|
Senior Member |
|
|
Dear,
This view displays information about the control file record sections.
By using the following command, you can view the same description
SELECT name, value FROM v$parameter WHERE name='control_files';
The command:
DESC v$controlfile_record_section; shows
Name Null? Type
-------------------- ----- ------------
TYPE VARCHAR2(18)
RECORD_SIZE NUMBER
RECORDS_TOTAL NUMBER
RECORDS_USED NUMBER
FIRST_INDEX NUMBER
LAST_INDEX NUMBER
LAST_RECID NUMBER
More..........
SELECT type, record_size, records_total, records_used
FROM v$controlfile_record_section
WHERE type='DATAFILE';
( Eg.)
TYPE RECORD_SIZE RECORDS_TOTAL RECORDS_USED
----- ---------- ------------- ------------
DATAFILE 180 22 22
The RECORDS_TOTAL shows the number of records allocated for the section that stores information on data files.
More Desc:....
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
.......Pls. go throgh all..IF you want to ask any related queries..request you to send the mail to me.
Raj
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
