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
G:\Tools\Console2>dir k:\oradata\diag\rdbms\orcl\orcl\trace\alert_orcl.log
驱动器 K 中的卷是 OraData
卷的序列号是 0B09-084E
k:\oradata\diag\rdbms\orcl\orcl\trace 的目录
2014-08-12 13:35 29,457,050 alert_orcl.log
1 个文件 29,457,050 字节
0 个目录 104,077,529,088 可用字节
G:\Tools\Console2>dir k:\oradata\diag\rdbms\orcl\orcl\alert\log.xml
驱动器 K 中的卷是 OraData
卷的序列号是 0B09-084E
k:\oradata\diag\rdbms\orcl\orcl\alert 的目录
2014-08-12 13:35 7,795,574 log.xml
1 个文件 7,795,574 字节
0 个目录 104,077,529,088 可用字节
http://docs.oracle.com/cd/E11882_01/server.112/e25494/diag.htm#ADMIN13025
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 |