Automatic Undo Management On Oracle

dbtut July 2, 2018 ORACLE

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“.

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux