ORA-01555 caused by SQL statement
Hello All,
I'm seeing an ORA -1555 error after running for more than 50+ hours r in the database alert logfile for the past couple of days. It's 10.2.0.5 db on AIX server. Last PSU 10.2.0.5.3 was applied on AUG -2011.
Question here is when i check for the SQL_ID details in the below query and ASH report it doesn't show up. Any comments/solutions to prevent the error and do we have any queries after tuning the query to test and confirm this will not happen again?
FYI -- undo_retention is 18000
Select sql_fulltext from v$sqlarea where sql_id = '&SQL_ID';
I'm seeing an ORA -1555 error after running for more than 50+ hours r in the database alert logfile for the past couple of days. It's 10.2.0.5 db on AIX server. Last PSU 10.2.0.5.3 was applied on AUG -2011.
Question here is when i check for the SQL_ID details in the below query and ASH report it doesn't show up. Any comments/solutions to prevent the error and do we have any queries after tuning the query to test and confirm this will not happen again?
FYI -- undo_retention is 18000
Select sql_fulltext from v$sqlarea where sql_id = '&SQL_ID';
0