Home » RDBMS Server » Server Administration » what's the maximum size of the control file ? (Oracle,10.2.0.1.0, Windows XP)
what's the maximum size of the control file ? [message #538419] Thu, 05 January 2012 20:44 Go to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
Hi,all.

What's the maximum size of the control file in one database ?

i calculated it according to the following steps:
SQL>SELECT (BLOCK_SIZE/1024/1024)*20000 MB FROM V$CONTROLFILE WHERE ROWNUM = 1;
MB
------
312.5

The maximum number of the data block  in one control file is 20000.



Is it correct ?
Re: what's the maximum size of the control file ? [message #538420 is a reply to message #538419] Thu, 05 January 2012 20:53 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Is it correct ?
no

when all else fails Read The Fine Manual

http://docs.oracle.com/cd/E11882_01/server.112/e25513/limits002.htm#i287915

Re: what's the maximum size of the control file ? [message #538421 is a reply to message #538419] Thu, 05 January 2012 20:55 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
The main determinants of the size of a control file are the values set for the MAXDATAFILES, MAXLOGFILES, MAXLOGMEMBERS, MAXLOGHISTORY, and MAXINSTANCES parameters in the CREATE DATABASE statement that created the associated database. Increasing the values of these parameters increases the size of a control file of the associated database.


For WIndows XP it is {Maximum control file size} 20,000 blocks.

http://docs.oracle.com/cd/B19306_01/win.102/b14304/specs.htm#NTQRF550

Re: what's the maximum size of the control file ? [message #538422 is a reply to message #538420] Thu, 05 January 2012 21:03 Go to previous messageGo to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
the maximum size = 25000 * (database block size)??
Re: what's the maximum size of the control file ? [message #538423 is a reply to message #538422] Thu, 05 January 2012 21:10 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Size is always dependent On Oracle Version,OS platform.and values set for the MAXDATAFILES, MAXLOGFILES, MAXLOGMEMBERS, MAXLOGHISTORY, and MAXINSTANCES parameters in the CREATE DATABASE statement.

If you prefer reading link posted By Blackswan then read it for 10g version.
http://docs.oracle.com/cd/B19306_01/server.102/b14237/limits002.htm#i287915
Dependent on operating system and database creation options; maximum of 20,000 x (database block size).

Also Read platform guide for Max control file size.
http://docs.oracle.com/cd/B19306_01/win.102/b14304/specs.htm#NTQRF550

Sriram

[Updated on: Thu, 05 January 2012 21:11]

Report message to a moderator

Previous Topic: how to get block_number of index
Next Topic: Question about recyclebin
Goto Forum:
  


Current Time: Fri Mar 29 08:37:44 CDT 2024