Maintaining Database Parameters (Oracle) 

Use

This procedure lets you:

·         Display and change the current Oracle database parameters online

·         Check the status and validity of the Oracle database parameters

·         Display the history of the Oracle database parameters

Procedure

To call DB parameter maintenance, choose Administration ® CCMS ® DB administration ® DB parameters. Alternatively, call Transaction DB26.

The frame Number of database profile parameters includes the number of:

·        All Oracle database parameters

·        Oracle database parameters currently at their default value

·        Database parameters modifiable for the system (command ALTER SYSTEM ...)

·        Database parameters modifiable for the session (command ALTER SESSION ...)

·        Parameters modified since the last database start

·        Database parameters in alert status, for which the current value is different than the value specified in the database system check (table DBCHECKORA)

The individual database parameters are displayed in a table. The table includes the following columns:

Column	Meaning
Name	Name of the database parameters
Value	Value of the database parameter
Status	Status of the database parameter Red The value of the database parameter is different than the threshold value or not within the validity range specified in the database system check. The severity of this value is set to Error. Yellow The value of the database parameter is different than the threshold value or not within the validity range specified in the database system check. The severity of this value is set to Warning. Green The value of the database parameter is identical to the threshold value or within the validity range specified in the database system check Gray The parameter is not checked by the database system check. For more information, see Configure Database System Checks.
Changed	Was the parameter changed since the last database start? FALSE The parameter has not been changed since the last database start. MODIFIED The parameter was changed using the command ALTER SESSION ... since the last database start. SYSTEM_MOD The parameter was changed using the command ALTER SYSTEM ... since the last database start.
Default	Is the parameter set to its default value or not? TRUE Parameter is set to default value. FALSE Parameter is not set to default value.
Ses.modif.	Can the database parameter be modified for the session? TRUE The parameter can be modified during the session using the command ALTER SESSION ... FALSE The parameter cannot be modified during the session. Modifying a parameter immediately affects the database user session in which the parameter was modified. In the SAP context this means that all SAP user sessions whose dialog steps are processed by this database work process will be affected by the change. Since this will not involve all SAP user sessions, changes to session-modifiable parameters are not supported.
Sys.modif.	Can the database parameter be modified for the whole system? IMMEDIATE The parameter can be changed using the command ALTER SYSTEM ...  meaning it takes affect for all current database user sessions and therefore for the entire database. DEFERRED The parameter can be changed using the command ALTER SYSTEM ...  and it takes affect for all future database user sessions (for example, for SAP application servers started after the change went into effect). FALSE The parameter is not system-modifiable. To use the command ALTER SYSTEM ... you must have an authorization for ALTER SYSTEM for the database.
Adjusted	Was the parameter automatically adjusted by the database system? TRUE The parameter was automatically adjusted by the database system FALSE The parameter was not automatically adjusted by the database system
Description	Oracle description for the database parameter

Activities

Displaying specific views of database parameters

Choose:

·        To display all database parameters, choose Selection criteria ®  All.

·        To display all system-modified database parameters, choose Selection criteria ® System modifiable.

·        To display all session-modified database parameters, choose Selection criteria ® Session modifiable.

·        To display all Oracle database system parameters with the default value, choose Selection criteria ® Default.

·        To display all Oracle database system parameters that are not set to the default value, choose Selection criteria ®  Not default.

·        To display all parameters modified since the last database start, choose Selection criteria ® Modified since startup.

·        To display all parameters checked using the function Database System Check since the last database start, choose Selection criteria ®  With check.

·        To display all parameters in alert status, choose Selection criteria ®  In alert status.

Updating database parameter display

To update the display of database parameters, choose Refresh.

Displaying details and history for a database parameter

...

       1.      Select an entry.

       2.      Choose Details and history.

In addition to the details and history for the database parameter, the system also displays the threshold value specified in the database system check.

Displaying history for all database parameters

Choose Goto ® Total history.

·        To display only the database parameters modified since the SAP System was implemented, choose With history.

·        To display only the database parameters modified since a certain date, choose Selection date.

·        To display a history for all database parameters, choose All parameters.

Changing database parameters

Only system-modifiable database parameters can be changed online. These parameters have either the value IMMEDIATE or DEFERRED in the Sys.modif column.

...

       1.      Select an entry.

       2.      Choose Change.

       3.      Change the value of the database parameter.

       4.      Choose Save.

To make the change effective even after a database restart, you must maintain the database parameter in the init<DBSID>.ora Oracle initialization file or server parameter spfile. This file is usually located in the directory $ORACLE_HOME/dbs (UNIX) or %ORACLE_HOME%\database (Windows).

We recommend you to use BRSPACE for this. For more information, see -f dbparam.

Displaying the init<DBSID>.ora Oracle initialization file

To display the Oracle initialization file init<DBSID>.ora, choose Display Oracle profile.