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

Thread: help with db_files vrs maxdatafile

  1. #1
    Join Date
    Nov 2000
    What is the purpose of the parameter db_files in the init.ora file
    Will there be a problem if I set my db_files=400 (medium)
    and set maxdatfiles in my create database script to 500?
    Please explain

    still learning,

  2. #2
    Join Date
    Feb 2000
    Washington DC
    DB_FILES specifies the maximum number of database files that can be opened for the database.
    MAXDATAFILES specifies the maximum number of database files that can ever be created for the database.

    DB_FILES should always be less than MAXDATAFILES as definition says.

    So, you can set db_files=400 and maxdatafiles=500 and you are ok.

    [Edited by sreddy on 01-03-2001 at 03:48 PM]

  3. #3
    Join Date
    Dec 2000
    Ljubljana, Slovenia
    To be precise, the MAXDATAFILES is the maximum number of datafiles that can be recorded in the *current controlfile*. If you find out you have set this limit too low when creating the database you can allways reset it to a higher value by simply recreating the controlfile with the new value for MAXDATAFILE.

    In other words, it is not set for the lifetime of the database (like DB_BLOCK_SIZE is), it is set for the lifetime of the control file.

    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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