Automatic Undo Management On Oracle

dbtut

6 years ago

To run the database in automatic undo management mode, you must set undo_management to auto from the oracle startup parameters.

You can use the following script to change it.

ALTER SYSTEM SET UNDO_MANAGEMENT=AUTO SCOPE=SPFILE;

1	ALTER SYSTEM SET UNDO_MANAGEMENT=AUTO SCOPE=SPFILE;

For a database running on multiple instances in the Rack structure, you must change it as follows.

ALTER SYSTEM SET UNDO_MANAGEMENT=AUTO SID='*' SCOPE=SPFILE;

1	ALTER SYSTEM SET UNDO_MANAGEMENT=AUTO SID='*' SCOPE=SPFILE;

You should restart the database after this. To Restart the Database You can read the article titled “How to Restart the Oracle Database“.