bind variable

[alainc]

Is it possible to see the values send by a session for a bind variable in a query ?

Ie select * from mytable where myparam :=B1

Where can i find the value for a specific session,

thanks

alain

[gpsingh]

alter session set events '10046 trace name context forever, level 4';
GO to udump directory and find the trace file of ur session .

[alainc]

thanks but it seems that i must do it from the selected session? can't i do it from another session ?

[npatel]

Run
exec dbms_system.set_ev(sid,serial#,10046,4,'')
as sys.

HTH
npatel