oracle v diag info,V$DIAG_INFO及V$DIAG_CRITICAL_ERROR视图

ADR(Automatic Diagnostic Repository) Directory structure for a Database Instance

通过V$DIAG_INFO视图查看ADR分布位置信息：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

Table 9-3 Data in the V$DIAG_INFO ViewNameDescriptionADR BasePath of ADR base

ADR HomePath of ADR home for the current database instance

Diag TraceLocation of background process trace files, server process trace files, SQL trace files, and the text-formatted version of the alert log

Diag AlertLocation of the XML-formatted version of the alert log

Default Trace FilePath to the trace file for the current session

ColumnDatatypeNULLDescriptionINST_IDDNUMBERNOT NULL当前实例ID

NAMEVARCHAR2(64)NOT NULL跟踪记录名称

VALUEVARCHAR2(512)

NUMBERNOT NULL跟踪文件路径

Table 9-4 Data in the V$DIAG_CRITICAL_ERROR ViewColumnDescriptionFACILITYThe facility that can report the error, such as Oracle Database (ORA) or Oracle Call Interface (OCI)

ERRORThe error number