Oracle Database Discussions

Hi All -

I am helping the team with a performance issue. Oracle has asked to do some tracing on the SQL. We know the SQL ID that we want to trace, but it runs as part of an application process. Thus, we are not able to run it directly. So, for example, MOS has asked us to do the following:

alter session set tracefile_identifier='10046_10053_&your_name';

alter session set timed_statistics = true;

alter session set statistics_level=all;

alter session set max_dump_file_size = unlimited;

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

alter session set events '10053 trace name context forever, level 1';

-- /*Run SQL-s here*/ ------

select 'Verify Close' from dual;

alter session set events '10046 trace name context off';

alter session set events '10053 trace name context off';

Is it possible to enable the tracing for the SQL/SQL ID that will run as part of the nightly process?

Thanks in advance!

DB Version 12.2.0.1

Regards,

Charles