Re: same cursor number?
- From: "LiShan Cheng" <exriscer@xxxxxxxxx>
- To: "Ric Van Dyke" <ric.van.dyke@xxxxxxxxxx>
- Date: Mon, 3 Apr 2006 14:49:56 +0200
thx all
LSC
On 4/3/06, Ric Van Dyke <ric.van.dyke@xxxxxxxxxx> wrote:
>
> This is normal and expected behavior. Once a cursor is closed the number
> can be reused. You may also notice that the numbers don't necessarily
> appear in any particular order.
>
>
>
> Ric Van Dyke
>
> Hotsos Enterprises
>
> Cell 248-705-0624
>
> -----------------------
>
> Hotsos Symposium, be there:
>
> http://www.hotsos.com/portal/events/SYM06
> ------------------------------
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *LiShan Cheng
> *Sent:* Monday, April 03, 2006 6:17 AM
> *To:* oracle-l
> *Subject:* same cursor number?
>
>
>
> 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:
