Search notes:

Oracle: DBMS_SQLDIAG.DUMP_TRACE

dbms_sqldiag.dump_trace performs a 10053 trace, yet without executing the SQL statement. 
begin
   dbms_sqldiag.dump_trace (
      p_sql_id       => '…'        ,
      p_child_number =>  …         ,
      p_component    => 'Optimizer', -- or 'Compiler'
      p_file_id      => 'CBO_TRACE'
   );
end;
/

See also

dbms_sqldiag.

Links

Julian Dyke's Oracle Internals

Index