Database Administration (MOSC)

MOSC Banner

What alter system I can execute in order to have the full query of an ORA-01555 in the alert log or

edited May 10, 2010 7:38AM in Database Administration (MOSC) 4 commentsAnswered ✓
 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center