Re: Q: Detecting values of bind vars

Or if you want to see bind variables for a session you cannot alter and/or didn't initiate ( ie. some other user running a 3rd party application ):

    execute sys.dbms_system.set_ev(SID,SERIAL#,10046,LEVEL,'');

where
SID=users sid
SERIAL#=users serial#
LEVEL=level of the trace ( level 4 gets bind variables )

-Kevin

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:hpbmcto1temudc0i4rt6k5b07g172okpv3_at_4ax.com...
> On Wed, 4 Apr 2001 11:26:56 +0200, "Ivan Bajon"
> <bajon_at_nospam@worldonline.dk> wrote:
>
> >Hi folks
> >
> >(8.1.6)
> >
> >I just came across the views v$sql_bind_data and v$sql_bind_metadata. Can
> >these be used to determine the values of the bind vars in whatever SQL a
> >user is currently executing? If so, how?
> >
> >Regards,
> >Ivan Bajon, ocp
> >
> Visit www.ixora.com.au and download the toolkit located . You need to
> set an event for this and the info will end up in your trace file.
> From the top of my head it is
> alter session set event="10046 trace name level 12 context forever"
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
Received on Thu Apr 05 2001 - 16:36:03 CDT