Re: same cursor number?

Hi,

Cursor number is reused when the cursor is closed.

Regards

On 4/3/06, LiShan Cheng <exriscer_at_gmail.com> 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

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