SQL Trace is not generating file
I am having this issue for last 4-5 days.
I am trying to generate sql trace file.
I have set sql_trace in both database (through init.ora) and also in the session level.
SQL> show parameter sql_trace
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sql_trace boolean TRUE
SQL> show parameter trace_enabled
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
trace_enabled boolean TRUE
SQL> show parameter user_dump
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
user_dump_dest string /oracle/admin/itst50/udump
SQL> select * from dual;
D
-
X
SQL>
itst50--/oracle/admin/itst50/udump>> lt
total 70
drwxr-xr-x 2 oracle dba 1024 Apr 3 22:47 .
-rw-r----- 1 oracle dba 460 Apr 3 22:47 itst50_ora_22167.trc
-rw-r----- 1 oracle dba 460 Apr 3 18:21 itst50_ora_11240.trc
drwxr-xr-x 11 oracle dba 1024 Apr 3 18:11 ..
No file created today.
I have also tried in the session level and it does not work.
I have looked in the bdump directory and it is not there either. Please HELP.