SQL> show parameter diag
Above command will show the Alert file and trace location.
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest string /oracle/app/oracle
SQL> Alter System Set Diagnostic_Dest=' /oracle/app/oracle/tracedest';
It will change the Trace Files location.
SQL> show parameter diag
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest string /oracle/app/oracle/tracedest
Above command will show the Alert file and trace location.
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest string /oracle/app/oracle
SQL> Alter System Set Diagnostic_Dest=' /oracle/app/oracle/tracedest';
It will change the Trace Files location.
SQL> show parameter diag
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
diagnostic_dest string /oracle/app/oracle/tracedest
Comments
Post a Comment