7 Replies Latest reply: Mar 2, 2013 7:46 AM by user10274093 RSS

    Trace file

    user10274093
      Hi,
      in 11g R2,
      when you set
      alter session set tracefile_identifier='10046';
      alter session set events '10046 trace name context forever, level 12';


      Where would be the destination of my trace file ? Where can I find it ?

      Thanks.
        • 1. Re: Trace file
          TSharma-Oracle
          UDUMP directory
          • 2. Re: Trace file
            user10274093
            Thank you. And udump is in C:\oracle\admin\mydb ?

            I ask this because it has not been created by default.
            Should I create it manually before running my query ?

            Regards.
            • 3. Re: Trace file
              TSharma-Oracle
              go to sqlplus
              login as sys
              show parameter dump

              It will show you the location of your dump file....well another thing if you are on 11g, your trace file location should be

              show parameter diagnostic_dest

              OR

              SELECT VALUE FROM V$DIAG_INFO WHERE NAME = 'Diag Trace';
              • 4. Re: Trace file
                TSharma-Oracle
                Sorry I did not see your version is 11g

                so check

                show parameter diagnostic_dest

                This 'trace' folder will be the location of your trace file
                • 5. Re: Trace file
                  Aman....
                  It's going to be in the trace folder under the Oracle_Base/Diag folder.

                  Aman....
                  • 6. Re: Trace file
                    Jonathan Lewis
                    user10274093 wrote:
                    Thank you. And udump is in C:\oracle\admin\mydb ?

                    I ask this because it has not been created by default.
                    Should I create it manually before running my query ?
                    The trace file may not appear until you start doing a little work.

                    In your version of Oracle you will eventually see two files, one with the suffix .trc - the trace file - and one with the suffix .trm which is a file used by Oracle for their own purposes.

                    Also in your version of Oracle, the fully qualified name of the trace file will appear in v$process as column tracefile. You could write a high precision query joining v$session for your session to v$process to find exactly the right row, but I usually just query v$process where tracefile like '%ora%' to get the right location then do " ls -ltr *ora* " to pick up the latest list of files.

                    Regards
                    Jonathan Lewis
                    • 7. Re: Trace file
                      user10274093
                      yes.
                      Thank you John.
                      Thanks to all.