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

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *