skip to main content

SAP NetWeaver Newbie

ORA-00059 maximum number of DB_FILES exceeded

Fixing ORA-00059 maximum number of DB_FILES exceeded

The number of datafiles per database is limited by the parameter DB_FILES.

You can check the current limit using the following SQL command:
show parameter db_files;

You can check the curent number of datafiles the following SQL command:
select count(*), max(file#) from v$datafile;

When the curent number of datafiles equals DB_FILES, the next attempt to add a datafile will error out with ora error code ORA-00059.

The limit can be increased (for example to 300) using the following SQL command. The changed requires a restart of database.
alter system set db_files=300 scope=spfile;

No comments:

Post a Comment

Email Subscription

Get every new post into your inbox by subscribing us.

Want a reason to subscribe?
1. This sitemap might convince you to subscribe.
2. We do not misuse email IDs. We respect privacy.

© 2008 - 2017 sapnwnewbie. All rights reserved.