Oracle Viewing ADR Locations with the V$DIAG_INFO View - Help check Snapshot agent work
https://docs.oracle.com/cd/B28359_01/server.111/b28310/diag001.htm#ADMIN11258
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 ＜－－ Open this one
1 Active Problem Count 8
1 Active Incident Count 20
The following table describes some of the information displayed by this view.
Table 8-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 |
