238.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.)
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.
Answer: ACD
答案解析：
参考：http://docs.oracle.com/cd/E11882_01/server.112/e25494/diag.htm#ADMIN13483
B错，应该为 the text alert log file is /u01/oracle/diag/rdbms/orclbi/orclbi/trace
| Subdirectory Name | Contents |
|---|---|
|
alert |
The XML-formatted alert log |
|
cdump |
Core files |
|
incident |
Multiple subdirectories, where each subdirectory is named for a particular incident, and where each contains dumps pertaining only to that incident |
|
trace |
Background and server process trace files, SQL trace files, and the text-formatted alert log |
|
(others) |
Other subdirectories of ADR home, which store incident packages, health monitor reports, and other information |
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.
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 |