Re: Trace file question

You are welcome.

Yes, your interpretation is correct.

By the way, the dty=... tells you the datatype as in dump (...)

Martin

DODO wrote:
>
> Thanks Martin.
> Bear with me another moment please. Am I correct assuming that in the
> following excerpt:
>
> =====================
> PARSING IN CURSOR #1 len=69 dep=0 uid=46 oct=2 lid=46 tim=0 hv=2720346935
> ad='3d43f08'
> INSERT INTO PS289 (OID, SID, FTYPE, C1) VALUES (:1,:2,:3,:4)
> END OF STMT
> PARSE #1:c=0,e=0,p=0,cr=1,cu=0,mis=1,r=0,dep=0,og=0,tim=0
> BINDS #1:
> bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=72
> offset=0
> bfp=17c22128 bln=22 avl=04 flg=05
> value=12237
> bind 1: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0
> offset=24
> bfp=17c22140 bln=22 avl=04 flg=01
> value=12234
> bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0
> offset=48
> bfp=17c22158 bln=22 avl=02 flg=01
> value=1
> bind 3: dty=96 mxl=2000(2000) mal=00 scl=00 pre=00 oacflg=21 oacfl2=0
> size=2000 offset=0
> bfp=17c0b7b0 bln=2000 avl=00 flg=05
> XCTEND rlbk=0, rd_only=0
> EXEC #1:c=0,e=0,p=0,cr=1,cu=9,mis=0,r=1,dep=0,og=4,tim=0
> XCTEND rlbk=0, rd_only=1
> =====================
>
> :1 is bound to12237
> :2 to 12234
> :3 to 1

 and
> :4 to null?
>
> TIA,
> DODO
>
> "Martin Haltmayer" <Martin.Haltmayer_at_0800-einwahl.de> wrote in message
> news:3AC396F9.38128749_at_0800-einwahl.de...
> > Do not use level 8 but level 4. Level 8 will give you the wait events.
> >
> > Martin
> >
> >
> >
> > DODO wrote:
> > >
> > > Hi Sybrand,
> > >
> > > I still didn't get rid of the :1.
> > > I'm issuing the following:
> > >
> > > stmt := 'alter session set events ''10046 trace name context forever,
 level
> > > 8''';
> > > execute immediate stmt;
> > >
> > > Any other ideas?
> > > TIA,
> > > DODO
> > >
> > > "DODO" <dodo_at_Ihatespam.com> wrote in message
> > > news:f5Kw6.171974$Z2.2106716_at_nnrp1.uunet.ca...
> > > > Thank you, Sybrand.
> > > > DODO
> > > >
> > > > "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> > > > news:tc5gpb4r2ifcdb_at_beta-news.demon.nl...
> > > > >
> > > > > "DODO" <dodo_at_Ihatespam.com> wrote in message
> > > > > news:TYtw6.171774$Z2.2098536_at_nnrp1.uunet.ca...
> > > > > > Hello,
> > > > > > I have a question about what's inside a trace file. Hope I'll get
 help
 as
 I
> > > > > > did before(thanks again).
> > > > > > I can see in a trace file statements like
> > > > > >
> > > > > > SELECT OID, ID, NAME FROM TYPE WHERE OID = :1
> > > > > >
> > > > > > The question is, is there in the trace file recorded the value of
 ":1"?
> > > > > > TIA,
> > > > > >
> > > > > > DODO
> > > > > >
> > > > > >
> > > > >
> > > > > No, it is not recorded.
> > > > > Instead of an ordinary trace you'll need
> > > > > alter session set events '10046 trace name context forever, level 8'
> > > > >
> > > > > and you will get that info, and much more.
> > > > >
> > > > > Hth,
> > > > >
> > > > > Sybrand Bakker, Oracle DBA
> > > > >
> > > > >
> > > > >
> > > >
> > > >
Received on Sat Mar 31 2001 - 07:12:02 CST