Maintaining Database Parameters: Oracle (SAP Library - Computing Center Management System (BC-CCM))

Maintaining Database Parameters: Oracle

Use

This function allows you to:

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 Tools ® CCMS ® DB administration ® DB parameters. Alternatively, call Transaction DB27.

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 by the system (command ALTER SYSTEM ...)
Database parameters modifiable by the session (command ALTER SESSION ...)
Parameters modified since the last database start
Invalid database parameters whose current value is different than the value specified in the database system check

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

Column	Meaning
Name	Name of the database parameters
Val. (value)	Value of the database parameter
Alarm	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 or the parameter is not checked by the database system check. For more information, see Configure Database System Checks
Description	Oracle documentation for the database parameter
Modif.	Was the parameter modified since the last database start? FALSE The parameter has not been modified since the last database start. MODIFIED The parameter was modified using the command ALTER SESSION ... since the last database start. SYS_MODIFIED The parameter was modified using the command ALTER SYSTEM ... since the last database start.
Default	Is the parameter a default Oracle database system parameter? TRUE Default parameter in Oracle database system FALSE Not a default parameter in Oracle database system
Ses.modif.	Can the database parameter be modified during 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	Is the database parameter system-modifiable? 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 SAP System. 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 In order to use the command ALTER SYSTEM ... you must have an authorization for ALTER SYSTEM for the database.
Adjust.	Was the parameter automatically modified by the database system? TRUE The parameter was automatically modified by the database system FALSE The parameter was not automatically modified by the database system

Activities

Sorting database parameters according to date

To move the last database parameters changed to the top of the table, choose Sort date in ascending order. To move the last database parameters changed to the bottom of the table, choose Sort date in descending order.

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 default Oracle database system parameters, choose Selection criteria ® Default
To display all non-default Oracle database system parameters, choose Selection criteria ® Not default
To display all parameters modified since the last database start, choose Selection criteria ® Modified since start
To display all parameters checked by SAPDBA using the function DB System Check since the last database start, choose Selection criteria ® With SAPDBA check
To display all parameters with invalid values, choose Selection criteria ® Invalid values

Updating database parameter display

To update the display of database parameters, choose Refresh

Displaying details and history for a database parameter

Select an entry

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.

Select an entry
Choose Change
Change the value of the database parameter
Choose Save

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

Displaying the init<SID>.ora Oracle initialization file

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