Disable SQL TRACE seems to be not working
Hi,
For finding the SQL TRACE file, I executed the below SQL :
SQL> alter system set sql_trace=true;
System altered.
SQL> alter system set timed_statistics=true;
System altered.
SQL> alter system set max_dump_file_size=unlimited;
System altered.
SQL> alter system set tracefile_identifier='DAILY_JOB2';
System altered.
SQL> alter system set events '10046 trace name context forever, level 12';
System altered.
and then this command
SQL> alter system set sql_trace=false;
System altered.
But still, the SQL trace files getting generated, even after 20-30 mins. Any idea why?