Re: Trace file question

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 - 13:13:24 CST