wdcps1062*\O02RCD1A-30: cat alert_O02RCD1A.log-3|egrep -i "Error|Fail|Invalid|ORA-|Global Enqueue Services Deadlock detected"
ORA-01555 caused by SQL statement below (SQL ID: cvvgqq7jch9ps, Query Duration=7795 sec, SCN: 0x090f.42a0e988):
For ORA-01555,
Cause: Rollback records needed by a reader for consistent read
are overwritten by other writers.
Action: If in Automatic Undo Management mode, increase the setting of
UNDO_RETENTION. Otherwise, use larger rollback segments.
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 15000
undo_tablespace string UNDOTBS1
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22578826/viewspace-714195/ ，如需转载，请注明出处，否则将追究法律责任。
