Home » RDBMS Server » Server Administration » Which query causing ORA-01555 error (RDBMS 10.1.0.4 Sun Solaris 9)
Which query causing ORA-01555 error [message #313589] Sun, 13 April 2008 19:53 Go to next message
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 #313590 is a reply to message #313589] Sun, 13 April 2008 20:06 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>How can we get the full query?
By using grep against the application source code.

Does the application actually have multiple SQL statement that begins with this identical string (500+) characters?

Re: Which query causing ORA-01555 error [message #313594 is a reply to message #313590] Sun, 13 April 2008 20:38 Go to previous messageGo to next message
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.
Re: Which query causing ORA-01555 error [message #313596 is a reply to message #313589] Sun, 13 April 2008 20:42 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>ORA-01555 caused by SQL statement below (SQL ID: g843tb6cj54u4, >Query Duration=254036 sec,
>SCN: 0x001d.0e442913):
>Fri Apr 11 10:27:46 2008
>Or it will be overwritten?

The only way to know for sure, is to query V$SQLAREA.

Do keyword search on ORA-01555 on http://asktom.oracle.com

[Updated on: Sun, 13 April 2008 20:44] by Moderator

Report message to a moderator

Re: Which query causing ORA-01555 error [message #313599 is a reply to message #313596] Sun, 13 April 2008 21:29 Go to previous message
suiren97
Messages: 48
Registered: May 2007
Location: Malaysia
Member
No such sql_id in v$sqlarea now..

Previous Topic: Change the character set after database creation
Next Topic: Change NLS_DATE_FORMATE of Database......??
Goto Forum:
  


Current Time: Thu Dec 08 16:25:20 CST 2016

Total time taken to generate the page: 0.12009 seconds