Parameter Changes (Oracle)

Use

You can use this procedure to display parameter changes.

Procedure

Choose CCMS → Control → Performance Menu → Database → Activity
Alternatively, call transaction ST04.
Choose Detail analysis menu → Parameter changes.

This section lets you display the current and historical settings of the init<SID>.ora parameters, as well as the date they were changed. If you compare the changes in the database history with the parameter changes performed, you can work out the effect of the parameter change.

Note

Changes to parameters do not take effect until the database instance is restarted. For more information, see the Oracle documentation.