Oracle parameter db_file

[tolulope_okusaga]

Hello guys,

I have reached the limit of the initial number of database files (254).

oracle parameter db_file=254.

Can i just increase this value to 999?

Is there anything I should watch of for?

Any impact on the architecture of the database?

any suggestions is welcomed..its a production system:)

[debasissahoo · Accepted solution]

Hello,

Read this link first..

http://help.sap.com/saphelp_nw04/helpdata/en/14/9e061c3597754e88c08e41cf76eff8/frameset.htm

then change accordingly.

You may consider doing a tablespace reorganization to reduce the no of datafiles.

Regards,

Debasis.

[fidel_vales · Accepted solution]

It is too strong to say that it is needed to reorganize the DB because DB_FILES parameter.

This parameter can be increased if needed.

It cannot be higher than the MAXDATAFILES in the control file.

except for that, there is no problem changing it

[debasissahoo · Accepted solution]

Fidel,

True, thats clearly mentioned that db_file parameter's hard limit is MAXDATAFILES.

Thanks for clarifying though.

Regards,

Debasis.

[Former Member]

MAXDATAFILES is no hard limitation. If DB_FILES is larger than MAXDATAFILES and MAXDATAFILES has to be exceeded, the controlfile section will be automatically expanded according to SAP note 8812.

Kind regards

Martin