ORA-1555:快照太旧:回滚段号 [英] ORA-1555: snapshot too old: rollback segment number

问题描述

关于的任何想法 ORA-1555:快照太旧:回滚段号 我收到此错误，似乎没有什么错.请说明在什么情况下会发生这种情况以及如何避免这种情况?

Any idea about ORA-1555: snapshot too old: rollback segment number I am getting this error and nothing seems to be wrong. Please state under what conditions in may occur and how it can be avoided?

推荐答案

我建议您阅读汤姆的答案: http://asktom.oracle .com/pls/asktom/f?p = 100:11:0 :::: P11_QUESTION_ID:1441804355350

I suggest you read Tom's answer : http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1441804355350

"ORA-1555发生在人们通常试图节省空间的情况下. 如果需要，回滚段可能会增长(使用OPTIMAL会缩小).所以， 他们将从10个左右的1meg回滚段开始.这些回滚段可能 如果我们让它们每个都增长到100兆(在此示例中)，那么它们将永远不会增长，除非 您得到一笔大交易.
"

"The ORA-1555 happens when people try to save space typically. They'll have small rollback segments that could grow if they needed (and will shrink using OPTIMAL). So, they'll start with say 10 or so 1meg rollback segments. These rollback segments COULD grow to 100meg each if we let them (in this example) however, they will NEVER grow unless you get a big transaction.
"

这篇关于ORA-1555:快照太旧:回滚段号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！