ORA-00059: maximum number of DB_FILES exceeded

[nir_s]

Hi guys,

We have reached to the limit of data files in our production DB and currently we cannot add data files.
Today we have a maintenance window and I want to increase the parameter DB_FILE and boune the DB.
Following some details:
DB version : 10.2.0.4
OS version: Sun Sparc Solaris 5.10 64 bit
DB_FILE=10000

PROD> ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        8192
coredump(blocks)     unlimited
nofiles(descriptors) 65000
vmemory(kbytes)      unlimited

I wanted to consult with you how to configure now the parameter DB_FILE?
Increasing to 15,000? maybe more?

Thanks in advance

[davey23uk]

only you know how many files you will need, set it whatever you think you need

[nir_s]

Actually , you're right
Thanks!!

[LKBrwn_DBA]

Also you may want to consider increasing the size of the files instead of adding more.

[nir_s]

Yes, I've already configured DBFs size of tablespaces which contain large amount of data files.
So, I hope increasing from 10,000 to 15,000 will give me peace for long time...
Thanks

[PAVB]

So, I hope increasing from 10,000 to 15,000 will give me peace for long time...

Just out of curiosity - do you really have in excess of 10,000 datafiles on your system? How big is that database?

[nir_s]

43tb!

[gandolf989]

While 43TB is a large database by any standard, you might benefit from looking through all of your table spaces and checking if you are using good storage methods. I.e. that you don't have 5 or 10 data files attached to a table space when 1 or 2 will do. That you don't have excessively large blocks sizes in table spaces where you have a lot of smaller tables, etc. The larger the database grows the more room there is for pruning. IMHO, small bites of 5-10 table spaces at a time would make more sense than larger changes.

[nir_s]

Thanks for your recommendations!
We try to do our best to maintain such a huge DB , including storage configuration.

[PAVB]

43tb!

Nice! that's a big f*&^% thing.

I'm sure you guys are having a lot of fun - on the database world "size matters"