3 Replies Latest reply: Apr 4, 2013 12:54 PM by user6233945 RSS

    SQL Trace is not generating file

    user6233945
      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
          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
            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
              Can somebody help on this please?