Friday, May 13, 2011

Maximum number of datafiles for an Oracle database

The maximum number of datafiles an Oracle database can have is controlled by the parameter , 'db_files'. You can find the maximum number of datafiles for a database as shown below.

SQL> show parameter db_files

NAME                                 TYPE        VALUE
------------------------------------------------- ----------- ------------------------------
db_files.                             integer     200

You can change or increase the value of this using ALTER SYSTEM command.
Published with Blogger-droid v1.6.9


Post a Comment


ORA-BLOG. Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com