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