same cursor number?

  • From: "LiShan Cheng" <exriscer@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 3 Apr 2006 12:16:54 +0200

Hi

I am tracing a process using 10046, in the raw trace files I noticed many
statement have same cursor number such as

PARSING IN CURSOR #16 len=92 dep=1 uid=67 oct=2 lid=67 tim=2271414838282
hv=3942153661 ad='3459f8f8'
INSERT INTO CT_sn (attrvalue,attrtype, entryid ) VALUES( :batValue,
:batSubType, :bEntryId )
END OF STMT

PARSING IN CURSOR #16 len=106 dep=1 uid=67 oct=2 lid=67 tim=2271414841098
hv=363125348 ad='34596ea0'
INSERT INTO CT_krbprincipalname (attrvalue,attrtype, entryid ) VALUES(
:batValue, :batSubType, :bEntryId )
END OF STMT

This makes a bit difficult searching which binds are happening at which
cursor.

I am not sure why is this?

TIA

Other related posts: