|
[oracle-l]
||
[Date Prev]
[04-2006 Date Index]
[Date Next]
||
[Thread Prev]
[04-2006 Thread Index]
[Thread Next]
Re: same cursor number?
- From: "Domingo Diaz Saenz" <domingo.diazs@xxxxxxxxx>
- To: exriscer@xxxxxxxxx
- Date: Mon, 3 Apr 2006 12:23:45 +0200
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
|
|
