Tuesday, October 29, 2013

Automatic undo management

After 10G onward ensures automatic undo space management is enabled. Not using automatic undo management can cause unnecessary contention and performance issues in your database. This may include among other issues, contention for the rollback segment header blocks, in the form of buffer busy waits and increased probability of ORA-1555s (Snapshot Too Old).

No comments:

Post a Comment