How to investigate this ORA-01555 [message #314148] |
Tue, 15 April 2008 21:45 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sandhyaa
Messages: 79 Registered: February 2007
|
Member |
|
|
Hi,
I am using EBusiness Suite 11i and recently i saw ORA-01555 in the alert log file.
In this particular situation, the error message is not followed by the SQL Query.
How do i investigate this??
Section of alert log:
Tue Apr 15 15:40:07 2008
ORA-01555 caused by SQL statement below (Query Duration=1208256007 sec, SCN: 0x0001.805a7901):
Tue Apr 15 15:40:07 2008
table_4_200_3f11675_0_0_0
ORA-01555 caused by SQL statement below (Query Duration=1208256008 sec, SCN: 0x0001.805a7901):
Tue Apr 15 15:40:08 2008
table_4_200_3f11675_0_0_0
ORA-01555 caused by SQL statement below (Query Duration=1208256008 sec, SCN: 0x0001.805a7901):
Tue Apr 15 15:40:08 2008
table_4_200_3f11675_0_0_0
ORA-01555 caused by SQL statement below (Query Duration=1208256015 sec, SCN: 0x0001.805a7901):
Tue Apr 15 15:40:15 2008
table_4_200_3f11675_0_0_0
ORA-01555 caused by SQL statement below (Query Duration=1208256015 sec, SCN: 0x0001.805a7901):
Tue Apr 15 15:40:15 2008
table_4_200_3f11675_0_0_0
ORA-01555 caused by SQL statement below (Query Duration=1208256015 sec, SCN: 0x0001.805a7901):
Tue Apr 15 15:40:15 2008
table_4_200_3f11675_0_0_0
ORA-01555 caused by SQL statement below (Query Duration=1208256016 sec, SCN: 0x0001.805a7901):
Tue Apr 15 15:40:16 2008
table_4_200_3f11675_0_0_0
Regards,
sandi
|
|
|
|
|
|
|
|
|
|
|
Re: How to investigate this ORA-01555 [message #314365 is a reply to message #314148] |
Wed, 16 April 2008 08:21 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sandhyaa
Messages: 79 Registered: February 2007
|
Member |
|
|
Thanks Michel,
In one of your previous updates of this topic, you told that the object is related to OBJECT_ID=512
When I query ALL_OBJECTS for OBJECT_ID=512,
it corresponds to AUX_STATS$
SQL> DESC AUX_STATS$
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
SNAME NOT NULL VARCHAR2(30)
PNAME NOT NULL VARCHAR2(30)
PVAL1 NUMBER
PVAL2 VARCHAR2(255)
Regards,
Sandi
|
|
|
|
|