早教吧作业答案频道 -->其他-->
系统提示ora－01555,如何加大rollbacksegment?我的系统提示ora－01555,查询代码含义提示：ORA－01555：snapshottoooldandhowtoavoiditRollbacksegmentsholdpre-imagesofchangeddata.Thesepre-imagesareheldfortwopurpo
题目详情
系统提示ora－01555,如何加大rollback segment?
我的系统提示ora－01555,查询代码含义提示：ORA－01555：snapshot too old and how to avoid it Rollback segments hold pre-images of changed data.These pre-images are held for two purposes:to enable a transaction to be rolled back and,crucially,to enable Oracle to return read-consistent views of the data.This means that if you execute a long- running query or transaction,and someone else (or perhaps even your own transaction) subsequently changes the data that your query is accessing,Oracle will use the pre-images in the rollback segment to return the data to your query in the state it was at the moment the query started.建议：Increase the size/number of rollback segments 请问,如何加大rollback segment?
我的系统提示ora－01555,查询代码含义提示：ORA－01555：snapshot too old and how to avoid it Rollback segments hold pre-images of changed data.These pre-images are held for two purposes:to enable a transaction to be rolled back and,crucially,to enable Oracle to return read-consistent views of the data.This means that if you execute a long- running query or transaction,and someone else (or perhaps even your own transaction) subsequently changes the data that your query is accessing,Oracle will use the pre-images in the rollback segment to return the data to your query in the state it was at the moment the query started.建议：Increase the size/number of rollback segments 请问,如何加大rollback segment?
▼优质解答
答案和解析
ora-01555 is normal error in oracle database. You can resize the rollback tablespace following suggestion. If you didn't know how to do it, please reference oracle database online document from OTN.
看了 系统提示ora－01555,...的网友还看了以下：
急救!若a>0,b>0,且a+b=c.求证:(1)当r＞1时a＾r+b＾r＜c＾r;(2)当r＜1 2020-04-05 …
a,b属于R,记max｛a,b}=【a,a大于等于b】【b,a小于b】,函数f(x)=max{/x 2020-05-15 …
设A为n阶方阵,E为N阶单位矩阵,且A^2-A=2E,证明则r(2E-A)+r(E+A)=n设A为 2020-05-15 …
比较急请指教分子间同时存在着引力和斥力,若分子间引力、斥力随分子距离r的变化规律f引=b/(r^a 2020-06-16 …
离散数学已知集合A,R为A上的等价关系,R已给出,求集合A关于R的商集A/R是什么.设A={1,2 2020-07-30 …
设A,B,C为三个n阶方阵,且|AB|不等于零,则正确的结论是（）A.R(ABC)=R(A)B.R 2020-07-30 …
设A为m×n矩阵，B为n×p矩阵，则矩阵方程AX=B有解的充分必要条件是（）A．r（A）=r（B） 2020-07-31 …
lingo中如何用a,b来代表常数min=(a^2+r^2-2*a*r*cos(c1))^(1/2) 2020-11-06 …
我们用符号“||”定义过一些数字概念，如实数绝对值的概念：对于a∈R，|a|=a，a＞00，a＝0− 2020-11-17 …
递回关系式的运算公式(数列)以下是推导一个公式"a=a+r(1-p^n)/(1-p)"的过程a=p* 2021-01-13 …