10046 trace and binds,

From: Fedock, John \(KAM.RIC\) <"Fedock,>
Date: Thu, 6 Aug 2009 12:47:26 -0400
Message-ID: <F5CEB91927193A4981057F06AA3FDD1F25CA1F_at_kamricsvexch1.us.kline.com>

From a 10046 trace, with binds and waits. Oracle 10.2.0.4, HP-UX.  

It says cursor #3, but I do not see any bind info, like I expected to. Does this mean the binds were NULL?    

---

PARSING IN CURSOR #3 len=14875 dep=1 uid=430 oct=3 lid=430 tim=3363421613000 hv=4282579666 ad='14d296a0'

SELECT * FROM (SELECT OT.VESSEL_CD VESSEL, OT.VOYAGE_CD VOYAGE, OT.LEG_CD LEG, OT.PORT_OF_CALL_CD PORT, OT.PORT_SEQUENCE_ID SEQ, CASE WHEN (OT.OPERATOR_CD = NH.OPERATOR_CD OR (OT.OPERATOR_CD IS NULL AND NH.OPERATOR_CD IS NULL)) THEN NULL ELSE OT.OPERATOR_CD || '->' || ... DELETED REST OF STATEMENT FOR READABILITY END OF STMT PARSE
#3:c=50000,e=53754,p=0,cr=3,cu=0,mis=1,r=0,dep=1,og=1,tim=3363421612981

WAIT #3: nam='row cache lock' ela= 2139 cache id=16 mode=0 request=3 obj#=-1 tim=3363421635821

---

         

John Fedock

"K" Line America, ISD Department  

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 06 2009 - 11:47:26 CDT