Re: Trace file question

From: DODO <dodo_at_Ihatespam.com>
Date: Fri, 30 Mar 2001 16:05:26 -0500
Message-ID: <ry6x6.172611$Z2.2121244@nnrp1.uunet.ca>

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 Fri Mar 30 2001 - 15:05:26 CST