View the Exhibit to examine the output for the V$DIAG_INFO view. Which statements are
true regarding the location of diagnostic traces? (Choose all that apply.)
Exhibit:
A.
The path to the location of the background as well as the foreground process trace files is
/u01/oracle/diag/ rdbms/orclbi/orclbi/trace.
B.
The location of the text alert log file is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.
C.
The location of the trace file for the current session is
/u01/oracle/diag/rdbms/orclbi/orclbi/trace.
D.
The location of the XML-formatted version of the alert log is
/u01/oracle/diag/rdbms/orclbi/orclbi/alert.
A, C and D are correct:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/diag001.htm
Viewing ADR Locations with the V$DIAG_INFO View
The V$DIAG_INFO view lists all important ADR locations for the current Oracle Database instance.
SELECT * FROM V$DIAG_INFO;
INST_ID NAME VALUE
——- ——————— ————————————————————-
1 Diag Enabled TRUE
1 ADR Base /u01/oracle
1 ADR Home /u01/oracle/diag/rdbms/orclbi/orclbi
1 Diag Trace /u01/oracle/diag/rdbms/orclbi/orclbi/trace
1 Diag Alert /u01/oracle/diag/rdbms/orclbi/orclbi/alert
1 Diag Incident /u01/oracle/diag/rdbms/orclbi/orclbi/incident
1 Diag Cdump /u01/oracle/diag/rdbms/orclbi/orclbi/cdump
1 Health Monitor /u01/oracle/diag/rdbms/orclbi/orclbi/hm
1 Default Trace File /u01/oracle/diag/rdbms/orclbi/orclbi/trace/orcl_ora_22769.trc
1 Active Problem Count 8
1 Active Incident Count 20
The following table describes some of the information displayed by this view.
Table 8-3 Data in the V$DIAG_INFO View
Name Description
ADR Base
Path of ADR base
ADR Home
Path of ADR home for the current database instance
Diag Trace
Location of background process trace files, server process trace files, SQL trace files, and the text-formatted version of the alert log
Diag Alert
Location of the XML-formatted version of the alert log
Default Trace File
Path to the trace file for the current session