
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
