10046 trace and binds,
- From: "Fedock, John \(KAM.RIC\)" <John.Fedock@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 6 Aug 2009 12:47:26 -0400
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
Other related posts: