Re: Trace file question

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 Thu Mar 29 2001 - 14:11:37 CST