10046 & 10053 trace generation

10046 & 10053 trace generation

sqlplus <app user>/<pwd>

alter session set timed_statistics = true;
alter session set statistics_level=ALL;
alter session set max_dump_file_size=UNLIMITED;
alter session set tracefile_identifier='10046_10053_with_correct_Restuls';
alter session set events '10046 trace name context forever, level 12';
alter session set events '10053 trace name context forever, level 1';

select value from employee where value like 'WORK\_%' ESCAPE '\'

select 1 from dual;

exit;