最近项目日志中发现了这样的错误:
Caused by: java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 1 with name "_SYSSMU1$" too small
版本是oracle 10g,采用的是自动管理模式
我把undo_retention由原来的900改成了1800,还是不行
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
undo_management string AUTO
undo_retention integer 1800
undo_tablespace string UNDOTBS1
望各位大虾帮忙!
Caused by: java.sql.SQLException: ORA-01555: snapshot too old: rollback segment number 1 with name "_SYSSMU1$" too small
版本是oracle 10g,采用的是自动管理模式
我把undo_retention由原来的900改成了1800,还是不行
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
undo_management string AUTO
undo_retention integer 1800
undo_tablespace string UNDOTBS1
望各位大虾帮忙!
贴出来再具体分析。
然后去服务器主机上,到上面结果中的目录下找alert_SID.log这里的SID,即你的实例名。查看日志内容,找到与ORA-01555相关的内容。
ORA-01555 caused by SQL statement below (SQL ID: 5fh8svvrp7kqz, Query Duration=0 sec, SCN: 0x0000.0022b4e1):
Thu Mar 4 17:39:04 2010
select dbemployee0_.ID as ID20_0_, dbemployee0_.NUM as NUM20_0_, dbemployee0_.NAME as NAME20_0_, dbemployee0_.GENDER as GENDER20_0_, dbemployee0_.TEL1 as TEL5_20_0_, dbemployee0_.TEL2 as TEL6_20_0_, dbemployee0_.TEL3 as TEL7_20_0_, dbemployee0_.TEL4 as TEL8_20_0_, dbemployee0_.EMAIL1 as EMAIL9_20_0_, dbemployee0_.EMAIL2 as EMAIL10_20_0_, dbemployee0_.EMAIL3 as EMAIL11_20_0_, dbemployee0_.EMAIL4 as EMAIL12_20_0_, dbemployee0_.DESCRIBE as DESCRIBE20_0_, dbemployee0_.AVAIABLE as AVAIABLE20_0_, dbemployee0_.DEPARTMENTID as DEPARTM15_20_0_ from EMPLOYEE dbemployee0_ where dbemployee0_.ID=:1
ORA-01555 caused by SQL statement below (SQL ID: az33m61ym46y4, Query Duration=0 sec, SCN: 0x0000.0022b4e1):
Thu Mar 4 17:39:04 2010
SELECT NULL AS table_cat,
o.owner AS table_schem,
o.object_name AS table_name,
o.object_type AS table_type,
NULL AS res
FROM all_objects o
WHERE o.owner LIKE :1 ESCAPE '/'
AND o.object_name LIKE :2 ESCAPE '/'
AND o.object_type IN ('xxx', 'TABLE')
ORDER BY table_type, table_schem, table_name
oracle QQ群:54775466
期待您的一起探讨
欢迎爱好者入群学习