Show TOC

Parameter HistoryLocate this document in the navigation structure


In the Administration user menu of the DBA Cockpit, you can find a list of all changes to database parameters, sorted by change date.


Open the DBA Cockpit (transaction DBACOCKPIT) and choose Start of the navigation path Administration Next navigation step Parameter History End of the navigation path.


To view the changes made to a database parameter at a particular point in time, use one of the methods below:

  • Click the symbol at the start of the line that contains the desired time point.

  • Select the time point and choose Expand Subtree.

The system displays a list of the database parameters changed up to this point in time, and their previous and new values. Parameters that are no longer used by the database as of a particular date are assigned <<parameter inactive>> as a new value.


Changes to database parameters generally do not take effect until the database is restarted.

You can also change some database parameters while the database is running (see the description of individual database parameters for more information). In addition, you can choose how long the change is to be effective for these database parameters:

  • Save: Changes to database parameters do not take effect until the next restart.

  • Activate Temporarily: Changes to database parameters take effect immediately, but only until the next restart.

  • Save and activate: Changes to database parameters take effect immediately and are permanent.

If you change a database parameter whose value is normally calculated by the system, then the set value also remains valid for all subsequent recalculations of database parameter values. The system only recalculates the value when the set value is not within the permitted value range.

More Information


Database Administration, Database Parameters