Home » RDBMS Server » Server Administration » Ora 9i - Win2003- Maximum number of control files
Ora 9i - Win2003- Maximum number of control files [message #189439] Thu, 24 August 2006 10:27 Go to next message
rusty_ryan
Messages: 11
Registered: August 2006
Junior Member
hi,
Can anyone tell me what is the maximum number of datafiles I can have on my Ora 9i, running Windows 2003?
Is the number of datafiles dependent on the size of the control file? And is the maximum size of the control OS dependent? Then can someone tell me what is the maximum size of the the control file i can have on Win2003 ??

Thanks very much in advance.
Re: Ora 9i - Win2003- Maximum number of control files [message #189458 is a reply to message #189439] Thu, 24 August 2006 12:52 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Max number of datafiles is 65533. The number of datafiles affect the size of the control file. The size of the control file is dependent on operating system and database creation options; maximum of 20,000 x (database block size).
Re: Ora 9i - Win2003- Maximum number of control files [message #189479 is a reply to message #189439] Thu, 24 August 2006 15:03 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
>>The size of the control file is dependent on operating system and database creation options

And the options are:
Maxdatafiles: specifying max.no of datafiles you can have in your database.
Maxinstances:specifying how many instances can simultaneosly mount and open the database.
maxlogfiles:max. no of logfiles
maxlogmembers:max. no. of of logfile members
Maxloghistory: specifying maximum archived logs.
Re: Ora 9i - Win2003- Maximum number of control files [message #189601 is a reply to message #189479] Fri, 25 August 2006 03:54 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
[1] Size of control file is hardly of few KB.
Note:- control file and datafile are different.

[2] Control file contain the information regarding Number of Datafile that a database can have as well as location of datafile, other than this it also have information about redo log files & many things pertainig to Database.

[3] At the max you can have 8 control file, but if you will have 8 control file then that will degrade database performance.

[4] It's always good to have 3 control file and they should be at different disk, coz in case if one disk get fail you can have other copy of control file on another disk.

[5] Control file is used by database from the start of database till the database is shut down.

For under standing i can say control file control the database..Smile

Whatever Yasir Hashmi said in his earlier post is also correct.

Regards
Sunilkumar
Re: Ora 9i - Win2003- Maximum number of control files [message #189666 is a reply to message #189439] Fri, 25 August 2006 08:47 Go to previous messageGo to next message
rusty_ryan
Messages: 11
Registered: August 2006
Junior Member
Great!! Thanks everyone!

>>Max number of datafiles is 65533. The number of datafiles affect the size of the control file. The size of the control file is dependent on operating system and database creation options; maximum of 20,000 x (database block size).

"What is the maximum size of control file I can have on Win 2003??"

Re: Ora 9i - Win2003- Maximum number of control files [message #189677 is a reply to message #189666] Fri, 25 August 2006 09:39 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
20,000 x (database block size)
Re: Ora 9i - Win2003- Maximum number of control files [message #189689 is a reply to message #189439] Fri, 25 August 2006 11:07 Go to previous message
rusty_ryan
Messages: 11
Registered: August 2006
Junior Member
Cheers!

Is that 20000 x (db block size) KB??
Is it 18-20 MB (approx)??
Previous Topic: Can I resize data files on database online ?
Next Topic: OS Authentication
Goto Forum:
  


Current Time: Thu Dec 08 08:40:30 CST 2016

Total time taken to generate the page: 0.12546 seconds