OraFAQ Forum: General » Control file size

Home » Other » General » Control file size (oracle 10g,solaris5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Control file size [message #343098]

Tue, 26 August 2008 05:01

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

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

Regards,

Report message to a moderator

Re: Control file size [message #343117 is a reply to message #343098]

Tue, 26 August 2008 05:57

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Control file size [message #343170 is a reply to message #343117]

Tue, 26 August 2008 09:15

balaji1482
Messages: 312
Registered: July 2007
Location: INDIA

Senior Member

Thanks michel

Report message to a moderator

Re: Control file size [message #343615 is a reply to message #343117]

Wed, 27 August 2008 11:33

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?

Report message to a moderator

Re: Control file size [message #343624 is a reply to message #343615]

Wed, 27 August 2008 12:05

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

They all have the same size and same content.

regards
Michel

Report message to a moderator

Re: Control file size [message #480831 is a reply to message #343624]

Wed, 27 October 2010 08:06

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).

Report message to a moderator

Re: Control file size [message #480839 is a reply to message #480831]

Wed, 27 October 2010 08:36

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	DBA Info.
Next Topic:	URGENT,email notification

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 26 14:10:50 CST 2024