dbms_system.set_ev(sid,serial#,10046,level,'')

4=binds

8=waits

12=binds and waits

alter system set events '10046 trace name context forever, level <lvl>';

ALTER SYSTEM SET EVENTS '10046 trace name context off';