Re: How to set event 10046 at level 8 for another session?

Jayaraman Ashok wrote:
>
> Hi
> Is it possible to trace another session by setting the 10046 event at
> level 8? Can it be done using dbms_system.set_int_param_in_session() ?
> Kindly help me in this regard as i would like to know waits and bind
> variable values for the other session.
>
> Cheers,
> Ashok

sys.dbms_system.set_sql_trace_in_session

or if you need a higher level, dbms_system.set_ev

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."