Sentinel: Error running AnalyzeTables.sh

  • 3499058
  • 03-Nov-2006
  • 26-Apr-2012

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

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.