Got error ORA-01555 caused by SQL statement after SQL running for 4 hours
Entry on the Alert Log:
2019-07-30T11:28:28.410317-07:00
ORA-01555 caused by SQL statement below (SQL ID: 5krf9735qnq4w, Query Duration=15247 sec, SCN:0x000005925e8744a7 ):
Entry on the output of SQL file
ORA-12801: error signaled in parallel query server P00J, instance usrncwd1:ala01p1 (1)
ORA-01555: snapshot too old: rollback segment number 412 with name "_SYSSMU412_705708902$" too small
SQL> show parameter undo
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
temp_undo_enabled boolean FALSE
undo_management string AUTO
undo_retention integer 54000
undo_tablespace string UNDOTBS1
SQL> SELECT tablespace_name, retention FROM dba_tablespaces;
TABLESPACE_NAME RETENTION
------------------------------ -----------
DATA01 NOT APPLY
DATA02 NOT APPLY
SYSAUX NOT APPLY
SYSTEM NOT APPLY
TEMP NOT APPLY
UNDOTBS1 NOGUARANTEE
UNDOTBS2 NOGUARANTEE
UNDOTBS3 NOGUARANTEE
UNDOTBS4 NOGUARANTEE
Please advise on resolving the issue.
Thanks
USERS NOT APPLY
10 rows selected.