Diagnosing the Database and Managing Performance - OCP: Oracle Database 12c Administrator Certified Professional - page 402

FiGURe 9.1 Folders within the ADR home directory
The DBA can set the value of DIAGNOSTIC_DEST on each instance in
Real Application Clusters. The recommendation from Oracle is for each
instance in a cluster to have the same value for DIAGNOSTIC_DEST .
In Exercise 9.1, you'll set the diagnostic destination.
exeRCiSe 9.1
Setting the Diagnostic Destination
To set the value for the diagnostic destination, do the following:
1. Verify the current setting for DIAGNOSTIC_DEST .
SQL> show parameter diag
NAME TYPE VALUE
------------------------------------ ----------- ---------
diagnostic_dest string C:\ORACLE
2. Determine the new destination. Check the new destination for security, access,
and sufficient space. In this example, we're moving the diagnostic destination
from c:\oracle to c:\temp .