Background documentationliveCache Database Parameters Locate this document in the navigation structure

 

The following overview describes database parameters belonging to the liveCache Database Parameters group. They can only be used for SAP liveCache databases.

For information about other database parameters, see

To change the values of database parameters, use one of the following database tools: Database Studio, Database Manager CLI, or CCMS (in SAP systems only). More information:

Most changes to database parameters take effect only after the database has been restarted.

However, you can change individual database parameters while the database is running, that is in the ONLINE or ADMIN operational state (see the description of individual database parameters for more information). For these changes you can define when they are to become effective:

  • Until the next restart

  • After the next restart

  • Immediately and permanently

If you change a database parameter whose value is normally calculated by the system, then the system will consider this user-defined value for all subsequent recalculations of database parameter values. The system discards and recalculates this user-defined value only if it is not within the permitted value range (for example, after the database software has been updated).

Note Note

Starting with version 7.7.03 of the database software, the names of many database parameters have changed.

Some database parameters have also been designated obsolete. These parameters have either been removed already or will be removed in one of the next database versions.

More information: Obsolete Database Parameters

End of the note.
liveCache Database Parameters

Name

(from version 7.7.03)

Old Name

(up to and including version 7.7.02)

Description

Change Restrictions

More Information

MinRetentionTime

MaxRetentionTime

MIN_RETENTION_TIME

MAX_RETENTION_TIME

Specifies (in min) when the garbage collectors start deleting the history data (undo log entries and links to them)

The garbage collectors start deleting the history data in the following cases:

  • When the data area is more than 90% full, the garbage collectors delete all history data that is older than MinRetentionTime.

  • When the data area is less than 90% full, the garbage collectors delete all history data that is older than MaxRetentionTime.

Can be changed in ONLINE or ADMIN operational state

Concepts of the Database System, How Databases Log Data Changes

OmsHeapThreshold

OMS_HEAP_THRESHOLD

Specifies memory usage by the OMS heap (in %)

Changes only apply after a restart of the database

-

OmsMaxHeapSize

OMS_HEAP_LIMIT

Specifies the maximum size of the OMS heap (in KB)

Changes only apply after a restart of the database

-

OmsSubHeaps

OMS_HEAP_COUNT

Specifies whether the OMS heap is divided into segments

If the OMS heap is not divided into segments, the internal heap memory management locks the entire OMS heap whenever a database procedure requests or releases memory.

Changes only apply after a restart of the database

Concepts of the Database System, Working Memory Areas

OmsVersionThreshold

OMS_VERS_THRESHOLD

Specifies memory usage by the OMS heap (in KB)

Changes only apply after a restart of the database

-

More Information

SAP Notes 719652 and 833216

Glossary