Database Trace

Alter session set sql_trace=true;
alter system set trace_enabled=true;
execute dbms_support.start_trace_in_session (sid, serial#,bind=>true,wait=>true)
alter session set tracefile_identifier='577' event '10046 trace name context forever, level 1;
alter session set event '10046 trace name context off';


select * from dba_enabled_traces;