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

exeRCiSe 9.1 (continued)
3. Use the ALTER SYSTEM command to change the value of DIAGNOSTIC_DEST :
SQL> alter system set diagnostic_dest=”c:\temp”;
4. Verify that the directory structure has been created. Oracle creates the diag direc-
tory under the diagnostic_dest directory and creates the directory tree under the
diag directory:
SQL> host
c:\temp>cd diag
c:\temp\diag>tree
Folder PATH listing for volume CPACK042
Volume serial number is 8656-F008
C:.
rdbms
orcl
orcl
alert
cdump
hm
incident
incpkg
ir
lck
log
ddl
debug
test
metadata
metadata_dgif
metadata_pv
stage
sweep
trace
c:\temp\diag>