This discussion is archived
3 Replies Latest reply: Apr 4, 2013 10:54 AM by user6233945 RSS

SQL Trace is not generating file

user6233945 Newbie
Currently Being Moderated
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.
  • 1. Re: SQL Trace is not generating file
    sb92075 Guru
    Currently Being Moderated
    user6233945 wrote:
    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.
    IIRC for V9 TIMED_STATISTICS defaulted to false
    SQL> show parameter timed
    
    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    timed_os_statistics                  integer     0
    timed_statistics                     boolean     TRUE
  • 2. Re: SQL Trace is not generating file
    user6233945 Newbie
    Currently Being Moderated
    That is also covered.
    SQL> show parameter timed_statistics

    NAME TYPE VALUE
    ------------------------------------ ----------- ------------------------------
    timed_statistics boolean TRUE
  • 3. Re: SQL Trace is not generating file
    user6233945 Newbie
    Currently Being Moderated
    Can somebody help on this please?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points