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 - 11:15:54 CST
