Find trace file in Oracle

The following script returns the path to the trace file that the current session writes. It returns the path whether or not tracing is enabled.

Check the value for user_dump_dest

Create a directory

Create a function

Now just the select the trace file name.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Comments

  1. expdba

    Also 11g onwards, tracefile name is available directly from v$process (column tracefile) and can be viewed from sqlplus (using host vi or host notepad commands)…

    TRACEFILE VARCHAR2(513) Trace file name of the process

Leave a Reply