Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: same cursor number?

Re: same cursor number?

From: LiShan Cheng <exriscer_at_gmail.com>
Date: Mon, 3 Apr 2006 14:49:56 +0200
Message-ID: <6e9345580604030549r18db3313wa409e32bcf50c2a7@mail.gmail.com>


thx all

LSC On 4/3/06, Ric Van Dyke <ric.van.dyke_at_hotsos.com> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *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
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 03 2006 - 07:49:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US