Oracle 11g的目錄結構有一些變化，增加了自動診斷庫(Automatic Diagnostic Repository)。ADR實際上是個目錄，位置由11g的新引數diagnostic_dest確定。如果設定了ORACLE_BASE環境變數，則diagnostic_dest的值就是$ORACLE_BASE,否則為$ORACLE_HOME/log。有了diagnostic_dest引數後，原先的bdump/cdump/udump等引數都失效, 此外ASM, CRS等的trace/log資訊，Health Monitor報告等也都放在這裡。[@more@]

察看ADR資訊：
SQL> select * from v$diag_info;

INST_ID NAME VALUE
---------- ------------------------- --------------------------------------------------------------
1 Diag Enabled TRUE
1 ADR Base d:apphz00540
1 ADR Home d:apphz00540diagrdbmsorclorcl
1 Diag Trace d:apphz00540diagrdbmsorclorcltrace
1 Diag Alert d:apphz00540diagrdbmsorclorclalert
1 Diag Incident d:apphz00540diagrdbmsorclorclincident
1 Diag Cdump d:apphz00540diagrdbmsorclorclcdump
1 Health Monitor d:apphz00540diagrdbmsorclorclhm
1 Default Trace File d:apphz00540diagrdbmsorclorcltraceorcl_ora_3868.trc
1 Active Problem Count 0
1 Active Incident Count 0

11 rows selected

其中：
ADR Base => Directory path for the ADR base.
ADR Home => Directory path for the ADR home for a specific database instance.
Diag Trace => The text-based alert file is stored here in addition to trace files. This directory corresponds to the old bdump directory.
Diag Alert => The XML-version alert log is found here.
Diag Incident => Location for the incident packages.
Diag Cdump => Core dump directory corresponding to cdump.
Default Trace File => Path to the session trace files (SQL trace files).

11g中引入adrci工具，方便使用者和ADR互動。

C:Documents and Settingshz00540>adrci

ADRCI: Release 11.1.0.6.0 - Beta on 星期四 2月 12 14:30:31 2009

ADR base = "d:apphz00540"
adrci>

比較常用的命令如：
-help
-show home
-host
-set ...

個人感覺這個工具用處不是太大。

11g_Automatic_Diagnostic_Repository