ORA-01555 caused by SQL statement below (Query Duration=1767 sec
I want to know why if the undo_retention is set to 900 a query failed with Ora-01555 with Query duration =1767 ?
Do I have to change the undo_retention to bigger than 1767 seconds?
The following query showed that the query did not run out of space on the undo tablespace:
SQL> conn system
Enter password: ******************
Connected.
SQL> set wrap on
SQL> set pagesize 50
SQL> set linesize 195
SQL> column begin_time format a25
SQL> column UNXPSTEALCNT heading "# Unexpired|Stolen"
SQL> column EXPSTEALCNT heading "# Expired|Reused"
SQL> column SSOLDERRCNT heading "ORA-1555|Error"
SQL> column NOSPACEERRCNT heading "Out-Of-space|Error"
SQL> column MAXQUERYLEN heading "Max Query|Length"
The following query showed that the query did not run out of space on the undo tablespace:
SQL> conn system
Enter password: ******************
Connected.
SQL> set wrap on
SQL> set pagesize 50
SQL> set linesize 195
SQL> column begin_time format a25
SQL> column UNXPSTEALCNT heading "# Unexpired|Stolen"
SQL> column EXPSTEALCNT heading "# Expired|Reused"
SQL> column SSOLDERRCNT heading "ORA-1555|Error"
SQL> column NOSPACEERRCNT heading "Out-Of-space|Error"
SQL> column MAXQUERYLEN heading "Max Query|Length"
2