619.View the Exhibit and note the contents of V$DIAG_INFO.
Which statement is true about the ADR?
A. The text alert log file will be available in Diag Trace
B. A copy alert log file will be kept in Diag Incident for every incident.
C. The XML version of the alert log file will be available in Diag Trace.
D. An Automatic Database Diagnostic Management (ADDM) report is generated and stored in the Health
Monitor whenever an incident occurs.
Answer: A
答案解析:
参考:http://docs.oracle.com/cd/E11882_01/server.112/e25494/diag.htm#ADMIN12566
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 9-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 |