Search notes:

oradebug doc event name sql_trace

sql_trace is the name for the event with number 10046. 
SQL> oradebug doc event name sql_trace

sql_trace: event for sql trace

Usage
-------
sql_trace
   wait            < false | true >,
   bind            < false | true >,
   plan_stat       < never | first_execution | all_executions | adaptive >,
   level           <ub4>

Simple example

In a session with SYSDBA privileges: 
SQL> oradebug setospid 15628
Oracle pid: 27, Windows thread id: 15628, image: ORACLE.EXE (SHAD)

SQL> oradebug event sql_trace wait=true, bind=false, plan_stat=first_execution
Statement processed.

SQL> oradebug tracefile_name
C:\ORACLE\DB\ORA19\DIAG\diag\rdbms\ora19\ora19\trace\ora19_ora_15628.trc
Then in session to be traced: 
select …
Turn off tracing (in first (SYSDBA) session): 
SQL> rem oradebug event sql_trace level=0
SQL> oradebug close_trace

Using ALTER SESSION

alter session  set events'sql_trace wait=false, bind=false, plan_stat=never';
  …
alter session  set events'sql_trace off';

Index