DB_FILES

[kannan]

Hi,

I was going through some of the threads here on the DB_FILES setting. Somebody was saying that DB_FILES should be set less than the MAXDATAFILES. I don't think that is the case. From Oracle 8x, the DB_FILES is more useful and I think the DB_FILES should set equal or greater than MAXDATAFILES.

Can anyone confirm my assumption is correct on DB_FILES?

Thanks in Advance.

[tamilselvan]

DB_FILES parameter is a soft limit. And it should be less than MAXDATAFILES. If the value is very high, it has to reserve space in every user processes.


[Edited by tamilselvan on 06-07-2001 at 04:55 PM]

[kannan]

Hi

Thanks for your reply.

I use the default MAXDATAFILES, which are 255. I thought of setting my DB_FILES to 500. I know that DB_FILES is the soft limit. If I set that to 100, what will happen? Will Oracle allow me to have 255 datafiles? Will it error only when I add the 256th datafile? After that, If I just bump up the DB_FILES and bounce the DB I think I will be okay. Can you let me know how much space it takes in PGA if I set that to 500?
What is the recommended minimum value for DB_FILES?

Thank you very much.