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

    1. Select an entry
    2. Choose Details and history
    3. 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<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.