The All Initialization Parameters dialog box allows you to view and edit all the configuration parameters for the database. Many initialization parameters can be fine-tuned to improve database performance. You can edit initialization parameters to:
Optimize performance by adjusting memory structures, such as the number of database buffers in memory
Set some database-wide defaults, such as the amount of space initially allocated for a context area when it is created
Set database limits, such as the maximum number of database users
Specify names of files
The following notes provide some hints for using the All Initialization Parameters dialog box of Database Configuration Assistant (DBCA):
If you are creating an Oracle database for the first time, it is suggested that you minimize the number of parameter values that you alter. As you become more familiar with your database and environment, you can dynamically tune many initialization parameters using Oracle Enterprise Manager, or the ALTER SYSTEM SQL statement. For more information about modifying initialization parameters, see the Oracle Database Administrator's Guide.
By default, only basic initialization parameters are shown in the table. These are the most common initialization parameters that are most often adjusted or modified by database administrators. Click Show Advanced Parameters to view the complete list of initialization parameters for the Oracle Database. When you show the advanced parameters, a new column appears, which identifies the basic parameters in the full list.
Click Show Description to open a panel below the table that provides a brief description of the selected initialization parameter. Complete information about all the initialization parameters is also available in the Oracle Database Reference.
To edit a the value for a parameter, select the check box in the Override Default column, and enter a new value. When you select this check box, DBCA includes this parameter in the initialization file for the database. For more information about managing your initialization parameter files, see the Oracle Database Administrator's Guide.
For Oracle RAC, this dialog box displays all global and instance-specific parameter settings for all instances in your environment.
Parameter settings that are global and that apply to all instances of your Oracle RAC database do not have instance names (SIDs) in the left-most Instance column. Instance-specific entries, however, have SIDs in the Instance column.
Copyright © 1996, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.