-
Control file Size
!hello
Can any on tell me how can i find the size of my CONTROLFILE .
Is there any view to find out.
Or I have to check by using OS command.
-
Using OS command will help as well...
For more info... Here
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
You may use record_size and records_total columns in v$controlfile_record_section to get the size of the controlfile. But for accurate size it is always advisable to see the size in OS.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
Originally posted by SANJAY_G
You may use record_size and records_total columns in v$controlfile_record_section to get the size of the controlfile. But for accurate size it is always advisable to see the size in OS.
Well Sanjay, IMHO those column values are in number (records) and not in bytes (size). So even if you want to calculate the controlfile size from the record_size or records_total, you cannot.
Amar
"There is a difference between knowing the path and walking the path."
-
Originally posted by adewri
Well Sanjay, IMHO those column values are in number (records) and not in bytes (size).
I think you may want to look at defination.
V$CONTROLFILE_RECORD_SECTION
This view displays information about the control file record sections.
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
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
-
Yes Amar, I too tried that before but it never gives you accurate size. Looking at OS size is the best way.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
V$Controlfile_Record_Section, will give you actual size used in the allocted space by OS. So, with OS perspective this is not the size as the allocated size > the sum of the (sizes*used)
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
Originally posted by abhaysk
V$Controlfile_Record_Section, will give you actual size used in the allocted space by OS. So, with OS perspective this is not the size as the allocated size > the sum of the (sizes*used)
Abhay,
FRom your previous post
RECORDS_TOTAL NUMBER Number of records allocated for the section
I was using the no of records allocated and record size. But it always comes lesser that the actual cf size.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
Originally posted by SANJAY_G
Abhay,
I was using the no of records allocated and record size. But it always comes lesser that the actual cf size.
Yes sanjay, this is the reason why i didnt post that v$controlfile_record_section can be used as alternative to OS command.
Have to dig up some docs to see, if there are any other TYPE's which get recorded in Control File apart from listed types.
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|