What alter system I can execute in order to have the full query of an ORA-01555 in the alert log or
What alter system I can execute in order to have the full query of an ORA-01555 in the alert log or a trace file?
ORA-01555 caused by SQL statement below (Query Duration=22624 sec, SCN: 0x0726.e
3addadd):
Sat May 8 07:20:26 2010
SELECT /*+NESTED_TABLE_GET_REFS+*/ "AWASDM"."F_AWAS".* FROM "AWASDM"."F_AWAS"
Sat May 8 08:09:25 2010
Thread 1 advanced to log sequence 215061
ORA-01555 caused by SQL statement below (Query Duration=22624 sec, SCN: 0x0726.e
3addadd):
Sat May 8 07:20:26 2010
SELECT /*+NESTED_TABLE_GET_REFS+*/ "AWASDM"."F_AWAS".* FROM "AWASDM"."F_AWAS"
Sat May 8 08:09:25 2010
Thread 1 advanced to log sequence 215061
0