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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.