The Oracle (tm) Users' Co-Operative FAQ

When are rollback segments supposed to shrink ?

Author's name: Jonathan Lewis

Author's Email:

Date written: 2nd Nov 2001

Oracle version(s): n/a

The purpose of the OPTIMAL option is to make sure that rollback segments shrink back to a known size automatically - but it doesn't seem to work properly on your system. Has something gone wrong.

Back to index of questions

This question is addressed by the following documents:

Author Title/URL Suggested by Referee's comments
Howard Rogers When do rollback segments shrink ? Jonathan Lewis A short pdf file with an intelligent discussion of the issues. You will need Adobe Acrobat to read this document.

NOTE - The referenced site was closed down by Oracle Australia. in May 2002. This link has been maintained in case Howards gets permission to re-open the site.



Further reading:

Back to top

Back to index of questions