OraFAQ Forum: Server Administration » max number of datafile per a database

Home » RDBMS Server » Server Administration » max number of datafile per a database

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

max number of datafile per a database [message #127729]

Wed, 13 July 2005 01:16

dnvs_praveen
Messages: 47
Registered: July 2005
Location: bangalore

Member

Plz anyone clear me the following doubt,

I created database by giving the value for maxdatafiles value as 20. But i am able to create more than 20 datafiles, how is it happening? if it exceeds then what is the use of giving maxdatafiles value in create database file?

Praveen.

Report message to a moderator

Re: max number of datafile per a database [message #127731 is a reply to message #127729]

Wed, 13 July 2005 01:22

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Hi

Are all ur datafiles online?

Regds
Girish

Report message to a moderator

Re: max number of datafile per a database [message #127753 is a reply to message #127729]

Wed, 13 July 2005 02:40

Achchan
Messages: 86
Registered: June 2005

Member

maxdatafiles is the max number of OPEN datafiles,not ALL EXISTING datafiles.However set that parameter to a higher value.
- Ragards

Report message to a moderator

Re: max number of datafile per a database [message #127775 is a reply to message #127731]

Wed, 13 July 2005 05:06

dnvs_praveen
Messages: 47
Registered: July 2005
Location: bangalore

Member

Yes, all datafiles are online, and the status of all datafiles are available status

Report message to a moderator

Re: max number of datafile per a database [message #127835 is a reply to message #127729]

Wed, 13 July 2005 11:07

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

maxdatafiles is just the initial maximum, used to determine how much space to reserve in the control file for datafiles. It can grow.

Quote:

MAXDATAFILES Clause

Specify the initial sizing of the datafiles section of the control file at CREATE DATABASE or CREATE CONTROLFILE time. An attempt to add a file whose number is greater than MAXDATAFILES, but less than or equal to DB_FILES, causes the control file to expand automatically so that the datafiles section can accommodate more files.

The number of datafiles accessible to your instance is also limited by the initialization parameter DB_FILES.

Report message to a moderator

Re: max number of datafile per a database [message #127853 is a reply to message #127835]

Wed, 13 July 2005 12:05

srinivas4u2
Messages: 66
Registered: June 2005

Member

Thanks Martin for the information.

-Sri

Report message to a moderator

Previous Topic:	Roles for Active users in a database
Next Topic:	resolve the issue rgds performance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 12:09:55 CST 2025