Displaying and Changing the Current Database Parameters 

Use

You can display and change the database parameters of the current database instance. This is possible in any operational state of the database instance.

The changes are stored in the parameter file but only become effective after the database has been restarted (Starting the Database Instance (Restart)).

Procedure

To change the parameters MAXDATAVOLUMES and MAXLOGVOLUMES, close the parameter session.
Proceed as described in Changing Volume Parameters.

For all other parameters, follow the procedure below:

1.       Choose Instance ® Configuration ® Parameters. The system displays the general database parameters (General).

2.       If you also want to display the special and support database parameters, choose Parameters ®Show Extended and Support Parameters.

3.       Select the desired tab page and the parameter that you want to change.

Name	Name of database parameter
Value	Value of the database parameter currently being used in the kernel of the database instance
New value	No entry: The database parameter has not been changed since the database instance was last started. New value entered: The database parameter has been changed since the database instance was last started. However, no changes are saved to the parameter file and none of them become active until the next time the database instance is restarted (Starting the Database Instance (Restart)).
Description	Help text on the selected parameter

4.       Choose Parameter ® Edit
The parameter appears in the bottom part of the window again. Next to the parameter you will see an explanation of what the parameter does and, in some cases, how it is calculated.

5.       Enter the new value for the parameter in the New Valuefield.
Confirm your entries.
The new value appears in the New Value column. It is stored in the internal data structures and becomes effective when the database instance is next restarted.