DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: DB_FILES

  1. #1
    Join Date
    Apr 2001

    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.

  2. #2
    Join Date
    May 2000
    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]

  3. #3
    Join Date
    Apr 2001

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width