Re: Trace file question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 29 Mar 2001 07:00:59 +0200
Message-ID: <tc5gpb4r2ifcdb@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 Wed Mar 28 2001 - 23:00:59 CST