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?
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?