Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Index > ORACLE Server Parameters > db_files

db_files


Oracle 11.1.0:

Parameter Name:db_files
Description:max allowable # db files
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 10.2.0:

Parameter Name:db_files
Description:max allowable # db files
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 10.1.0:

Parameter Name:db_files
Description:max allowable # db files
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 9.2.0:

Parameter Name:db_files
Description:max allowable # db files
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 8.1.7:

Parameter Name:db_files
Description:max allowable # db files
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 8.0.6:

Parameter Name:db_files
Description:max allowable # db files
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Oracle 7.3.4:

Parameter Name:db_files
Description:max allowable # db files
Type:NUMBER Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Related Error Messages:

ORA-00059: maximum number of DB_FILES exceeded
    Cause: The value of the DB_FILES initialization parameter was exceeded.

    Action: Increase the value of the DB_FILES parameter and warm start.

ORA-00296: maximum number of files (%s) exceeded for RECOVER DATAFILE LIST

    Cause: The RECOVER DATAFILE LIST command specified more datafiles than are allowed by the DB_FILES initialization parameter. This error occurs when doing recovery with Recovery Manager, and the instance has been started with a DB_FILES parameter specifying fewer datafiles than recovery manager needs to recover to satisfy the user's RECOVER command.

    Action: Re-start the instance with a higher value for DB_FILES.

ORA-01174: DB_FILES is %s buts needs to be %s to be compatible

    Cause: The maximum number of database files supported by this instance is not the same as for the other instances. All instances must be able to open all the files any instance can open.

    Action: Change the value of the DB_FILES parameter to be compatible

ORA-01175: data dictionary has more than the %s files allowed by the instance

    Cause: The data dictionary is found to have more files than that which can be supported by this instance.

    Action: Shutdown the instance and restart with a larger number of db_files

ORA-01279: db_files too large

    Cause: db_files has been set too high to be supported by the system.

    Action: Decrease the number of db_files.


This parameter is documented in the Oracle Server Reference Guide. Search for more info about [ db_files ] on the Oracle FAQ.

HOME | ASK QUESTION | ADD FAQ | SEARCH | E-MAIL US