We have a RT job that is using MQ. It parses the XML message and it then runs few select queries on few tables. All queries here are sparse.
All these tables are small except one. One of the table holds information that gets update in real time mode.
So far things were running fine - except now we have started getting error as:
Code: Select all
lkp_location,0: The OCI function OCIStmtFetch returned status -1. Error code: 12,801, Error message: ORA-12801: error signaled in parallel query server P075
ORA-01555: snapshot too old: rollback segment number 10 with name "_SYSSMU10$" too small. (CC_OraStatement::fetch, file CC_OraStatement.cpp, line 1,390)
Is there any alternative to this?