Environment
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows 2000 Server
RedHat Linux
Solaris 9
Sentinel 5.1.x
Situation
Table ESECDBA.EVENTS: ERROR: ORA-12801: error signaled in parallel
query server P003
ORA-01555: snapshot too old: rollback segment number 3 with name"_SYSSMU3$" too small
ORA-12801: error signaled in parallel query server P003
ORA-01555: snapshot too old: rollback segment number 3 with name"_SYSSMU3$" too small
ORA-01555: snapshot too old: rollback segment number 3 with name"_SYSSMU3$" too small
ORA-12801: error signaled in parallel query server P003
ORA-01555: snapshot too old: rollback segment number 3 with name"_SYSSMU3$" too small
Resolution
"snapshot too old" usually happens when an Oracle operation is
running for too long. In this case, the table is too big, the table
analyze is running for to long of a time.
If the database is too large, running AnalyzeTable.sh can be costly. It is recommend not to run AnalyzeTable.sh against a very large database. However, it is recommended to run AnalyzePartitions.sh regularly.
If the database is too large, running AnalyzeTable.sh can be costly. It is recommend not to run AnalyzeTable.sh against a very large database. However, it is recommended to run AnalyzePartitions.sh regularly.