| Which query causing ORA-01555 error [message #313589] |
Sun, 13 April 2008 19:53  |
suiren97
Messages: 48
Registered: May 2007
Location: Malaysia
|
Member |
|
|
ORA-01555 error encountered - alert log and trace file. The query shows not complete from log file. How can we get the full query?
ORA-01555 caused by SQL statement below (SQL ID: g843tb6cj54u4, Query Duration=254036 sec,
SCN: 0x001d.0e442913):
Fri Apr 11 10:27:46 2008
SELECT RCT . TRANSACTION_ID TX_ID , HRU . NAME ORG , PLC1 . DISPLAYED_FIELD SRC_TYPE , POV
. VENDOR_NAME SRC , NVL ( POV . ATTRIBUTE1 , 'N' ) SIC_TYPE , POV . segment1 SUPPLIER_COD
E , RSL . ITEM_DESCRIPTION DES , RSH . RECEIPT_NUM RECEIPT_NUM , RSH . SHIPMENT_HEADER_ID
SHIPMENT_HEADER , POH . PO_HEADER_ID PO_HEADER , POL . PO_LINE_ID PO_LINE , PLL . LINE_LOC
ATION_ID LINE_LOCATION , POR . PO_RELEASE_ID PO_RELEASE , POH . SEGMENT1 || DECODE ( POR .
RELEASE_NUM , NULL , NULL , '-' || POR . RELEASE_NUM ) || DECODE ( POL . LINE_NUM , NULL
|
|
|
|
|
|
| Re: Which query causing ORA-01555 error [message #313594 is a reply to message #313590] |
Sun, 13 April 2008 20:38  |
suiren97
Messages: 48
Registered: May 2007
Location: Malaysia
|
Member |
|
|
Does the application actually have multiple SQL statement that begins with this identical string (500+) characters?
--> need to check with developer.
Other than using grep command, is there any way to chk on DB side where SQL ID was shown in the alert log? Or it will be overwritten?
Pls advise.
Thank you.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
