event 10046
alter session set events '10046 trace name context forever,level 1|4|8|12';
alter session set events '10046 trace name context off';
or
exec dbms_monitor.session_trace_enable(sid,serial#,waits=>true,binds=>true); -- enable
exec dbms_monitor.session_trace_disable(sid,serial#); -- disable
event 10053
alter session set events '10046 trace name context forever,level 1|2';
alter session set events '10046 trace name context off';
sql_trace
alter session set tracefile_identifer='kin';
alter session set sql_mode=true;
alter session set sql_mode=false;
execute dbms_system.set_sql_trace_in_session(sid,serial#,true); -- enable
execute dbms_system.set_sql_trace_in_session(sid,serial#,false); -- disable
alter session set events '10046 trace name context forever,level 1|4|8|12';
alter session set events '10046 trace name context off';
or
exec dbms_monitor.session_trace_enable(sid,serial#,waits=>true,binds=>true); -- enable
exec dbms_monitor.session_trace_disable(sid,serial#); -- disable
event 10053
alter session set events '10046 trace name context forever,level 1|2';
alter session set events '10046 trace name context off';
sql_trace
alter session set tracefile_identifer='kin';
alter session set sql_mode=true;
alter session set sql_mode=false;
execute dbms_system.set_sql_trace_in_session(sid,serial#,true); -- enable
execute dbms_system.set_sql_trace_in_session(sid,serial#,false); -- disable