The Oracle (tm) Users' Co-Operative FAQ
When are rollback segments supposed to shrink ?
| Author's name: Jonathan Lewis Author's Email: Jonathan@jlcomp.demon.co.uk |
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. |
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:
最后修改时间：2020-04-16 15:12:15
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
