Re: How to see bind variable with tkprof?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 5 May 1999 18:50:07 +0100
Message-ID: <925926891.18535.1.nnrp-12.9e984b29@news.demon.co.uk>

alter session set events '10046 trace name context forever, level 4' Dumps all the bind variable information in the trace file. tkprof will still hide it, you need to read the trace file itself (use 'fold' if the lines are too long for your (unix) editor).

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Olivier ZILLER wrote in message <7gpi5j$4gb$1_at_arcturus.ciril.fr>...
>Hello,
>
> i'm using tkprof and my problem is that i could not see with it the
>value of the bind variables (i see select x from t1 where c1=:b1 but i need
>the value of b1).
Received on Wed May 05 1999 - 12:50:07 CDT