| what's the maximum size of the control file ? [message #538419] |
Thu, 05 January 2012 20:44  |
 |
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 #538423 is a reply to message #538422] |
Thu, 05 January 2012 21:10  |
 |
ramoradba
Messages: 2457
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
