Automatic Diagnostic Repository (ADR)

存放数据库诊断日志、跟踪文件的目录，称作ADR base，对应初始化参数

diagnostic_dest。 如果设置了ORACLE_BASE环境变量，DIAGNOSTIC_DEST等

于ORACLE_BASE，如果没有设置ORACLE_BASE，则等于ORACLE_HOME/log 。

SQL> show parameter diagnostic_dest

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

diagnostic_dest                      string      /u01/product

SQL>

dbtest$ls

alert  cdump  hm  incident  incpkg  ir  lck  metadata  stage  sweep  trace

可以通过  SQL> select name,value from v$diag_info;  查看相关信息。

ADRCI Command-Line Utility  命令行工具

dbtest$which adrci

/u01/product/oracle/bin/adrci

dbtest$adrci

ADRCI: Release 11.2.0.1.0 - Production on Tue Aug 24 14:12:26 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

ADR base = "/u01/produc

adrci>

备注： 在adrci中命令大小写不敏感。

在ADRCI中得到帮助：

adrci> help

HELP [topic]

Available Topics:

CREATE REPORT

ECHO

EXIT

HELP

HOST

IPS

PURGE

RUN

SET BASE

SET BROWSER

SET CONTROL

SET ECHO

SET EDITOR

SET HOMES | HOME | HOMEPATH

SET TERMOUT

SHOW ALERT

SHOW BASE

SHOW CONTROL

SHOW HM_RUN

SHOW HOMES | HOME | HOMEPATH

SHOW INCDIR

SHOW INCIDENT

SHOW PROBLEM

SHOW REPORT

SHOW TRACEFILE

SPOOL

There are other commands intended to be used directly by Oracle, type

"HELP EXTENDED" to see the list

adrci>