Creating SQL Optimizer Trace Files

Create SQL Trace File

begin
dbms_sqldiag.dump_trace(p_sql_id=>'c9hgbv0rg64hx',
                               p_child_number=>0,  
                               p_component=>'Compiler',
                               p_file_id=>'DSPACE_Trace_File');
end;

Find Trace File

select value from v$diag_info where name = 'Default Trace File';