Oracle: DBMS_SQLDIAG.DUMP_TRACE

select lower(dummy) from dual;

select sql_id, child_number from v$sql where sql_text = 'select lower(dummy) from dual';
-- 68maq1b045ms3	0

begin
   dbms_sqldiag.dump_trace (
      p_sql_id       => '68maq1b045ms3',
      p_child_number =>  0             ,
      p_component    => 'Optimizer', -- or 'Compiler'
      p_file_id      => 'Renes10053Test'
   );
end;
/

select
   trc.payload
from
   v$diag_trace_file_contents trc
where
   trc.trace_filename like '%Renes10053Test%'
order by
   trc.line_number
;