Find Oracle User Trace File Location

In Oracle SQL, execute the following command

SQL> show parameter user_dump_dest;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
user_dump_dest                       string      /oracle/SID/saptrace/diag/rdbms
                                                 /prd/SID/trace

You May Also Like

Leave a Reply?