Site icon Database Tutorials

Automatic Undo Management On 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.

 

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

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

Exit mobile version