Home » Other » General » Control file size (oracle 10g,solaris5)
Control file size [message #343098] Tue, 26 August 2008 05:01 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Is it possible to calculate controlfile size?? if yes,how??

Regards,



Re: Control file size [message #343117 is a reply to message #343098] Tue, 26 August 2008 05:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Approximatively:
SQL> desc v$controlfile_record_section
 Name                                   
 ---------------------------------------
 TYPE                                   
 RECORD_SIZE                            
 RECORDS_TOTAL                          
 RECORDS_USED                           
 FIRST_INDEX                            
 LAST_INDEX                             
 LAST_RECID                             

Sum all the records.

Regards
Michel
Re: Control file size [message #343170 is a reply to message #343117] Tue, 26 August 2008 09:15 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Thanks michel
Re: Control file size [message #343615 is a reply to message #343117] Wed, 27 August 2008 11:33 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

for example, if i have 2 or more control files,then how to calculate each control file size?
Re: Control file size [message #343624 is a reply to message #343615] Wed, 27 August 2008 12:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
They all have the same size and same content.

regards
Michel
Re: Control file size [message #480831 is a reply to message #343624] Wed, 27 October 2010 08:06 Go to previous messageGo to next message
edgefree
Messages: 30
Registered: July 2010
Location: Toronto
Member
What about the other info from v$controlfile in 11g?
There are two values about block_size and FILE_SIZE_BLKS, which are only available in 11g. So, I think it is easy to know controlfile size. And more, I believe it is more accurate, since it is not necessary to calculate by a little bit complex as mentioned in (http://www.ixora.com.au/q+a/0102/02112927.htm).
Re: Control file size [message #480839 is a reply to message #480831] Wed, 27 October 2010 08:36 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ The value given by this view is not correct, for instance, in case it gives 14090240 bytes when it is actually 14106624 bytes (one block left).
2/ The script in ixora is no more correct as v$controlfile_record_section does not expose all the sections.

Regards
Michel
Previous Topic: DBA Info.
Next Topic: URGENT,email notification
Goto Forum:
  


Current Time: Fri Mar 29 03:25:26 CDT 2024