Hi, Cursor number is reused when the cursor is closed. Regards On 4/3/06, LiShan Cheng <exriscer@xxxxxxxxx> wrote: > > 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 > > -- Domingo Diaz Saenz