Migration to Automatic Undo Management - Oracle 10g

« Previous Topics
Flashback Features And Undo Space
Monitoring The Undo Tablespace
Managing Undo Tablespaces
Next Topics »
Best Practices
What Are Oracle-managed Files?
Enabling The Creation And Use Of Oracle-managed Files

If you are still using rollback segments to manage undo space, Oracle strongly recommends that you migrate your database to automatic undo management. Oracle Database provides a function that provides information on how to size your new undo tablespace based on the configuration and usage of the rollback segments in your system. DBA privileges are required to execute this function:

The function returns the sizing information directly.
« Previous Topics
Flashback Features And Undo Space
Monitoring The Undo Tablespace
Managing Undo Tablespaces
Next Topics »
Best Practices
What Are Oracle-managed Files?
Enabling The Creation And Use Of Oracle-managed Files

List of Tutorials

List of Topics

Interview Questions

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Oracle 10g Topics