ALTER SESSION SET sql_trace=TRUE;

ALTER SESSION SET sql_trace=FALSE;

EXEC DBMS_SESSION.set_sql_trace(sql_trace => TRUE);

EXEC DBMS_SESSION.set_sql_trace(sql_trace => FALSE);

ALTER SESSION SET EVENTS '10046 trace name context forever, level 8';

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

EXEC DBMS_SYSTEM.set_sql_trace_in_session(sid=>123, serial#=>1234, sql_trace=>TRUE);

EXEC DBMS_SYSTEM.set_sql_trace_in_session(sid=>123, serial#=>1234, sql_trace=>FALSE);

EXEC DBMS_SYSTEM.set_ev(si=>123, se=>1234, ev=>10046, le=>8, nm=>' ');

EXEC DBMS_SYSTEM.set_ev(si=>123, se=>1234, ev=>10046, le=>0, nm=>' ');

CONN sys/password AS SYSDBA; -- User must have SYSDBA.

ORADEBUG SETMYPID; -- Debug current session.

ORADEBUG SETOSPID 1234; -- Debug session with the specified OS process.

ORADEBUG SETORAPID 123456; -- Debug session with the specified Oracle process ID.

ORADEBUG EVENT 10046 TRACE NAME CONTEXT FOREVER, LEVEL 12;

ORADEBUG TRACEFILE_NAME; -- Display the current trace file.

ORADEBUG EVENT 10046 TRACE NAME CONTEXT OFF;

EXEC DBMS_SUPPORT.start_trace(waits=>TRUE, binds=>FALSE);

EXEC DBMS_SUPPORT.stop_trace;

EXEC DBMS_SUPPORT.start_trace_in_session(sid=>123, serial=>1234, waits=>TRUE, binds=>FALSE);

EXEC DBMS_SUPPORT.stop_trace_in_session(sid=>123, serial=>1234);

EXEC DBMS_MONITOR.session_trace_enable;

EXEC DBMS_MONITOR.session_trace_enable(waits=>TRUE, binds=>FALSE);

EXEC DBMS_MONITOR.session_trace_disable;

EXEC DBMS_MONITOR.session_trace_enable(session_id=>1234, serial_num=>1234);

EXEC DBMS_MONITOR.session_trace_enable(session_id =>1234, serial_num=>1234, waits=>TRUE, binds=>FALSE);

EXEC DBMS_MONITOR.session_trace_disable(session_id=>1234, serial_num=>1234);

EXEC DBMS_MONITOR.client_id_trace_enable(client_id=>'tim_hall');

EXEC DBMS_MONITOR.client_id_trace_enable(client_id=>'tim_hall', waits=>TRUE, binds=>FALSE);

EXEC DBMS_MONITOR.client_id_trace_disable(client_id=>'tim_hall');

EXEC DBMS_MONITOR.serv_mod_act_trace_enable(service_name=>'db10g', module_name=>'test_api', action_name=>'running');

EXEC DBMS_MONITOR.serv_mod_act_trace_enable(service_name=>'db10g', module_name=>'test_api', action_name=>'running', -> waits=>TRUE, binds=>FALSE);

EXEC DBMS_MONITOR.serv_mod_act_trace_disable(service_name=>'db10g', module_name=>'test_api', action_name=>'running');

ALTER SESSION SET EVENTS 'trace[rdbms.SQL_Optimizer.*][sql:sql_id]';

alter session set "_px_trace"="all";