QUESTION POSED ON: 25 March 2009
We are executing a package in our testing database which is completely in sync with our production database. The package has many procedures, and in production the package gets executed in six hours. But in our test database the package gets stuck in one of the procedures and throws the error ORA-12801: error signaled in parallel query server P005:
ORA-01555: snapshot too old: rollback segment number 1 with name "_SYSSMU1$" too small
The procedures in test and in production are identical, but we still get the error. We are not able to pinpoint the cause because the same procedure is working fine in production. Can you provide any insight here?
|
