Setup extended trace

alter session set timed_statistics=true;
alter session set max_dump_file_size=unlimited;
alter session set tracefile_identifier='my_trace_file_name';

alter session set events '10046 trace name context forever, level 12';

execute sys.dbms_system.set_ev(46, 13217, 10046, 12, '');


dbms_system.set_bool_param_in_session(
sid => 42,
serial# => 1215,
parnam => 'timed_statistics',
bval => true)
dbms_system.set_int_param_in_session(
sid => 42,
serial# => 1215,
parnam => 'max_dump_file_size',
intval => 2147483647)