v$diag_info displays the state of the Automatic Diagnostic Repository (ADR). select * from v$diag_info;
v$diag_info include Diag Enabled | This value indicates if the ADR is enabled. |
ADR Base | |
ADR Home | |
Diag Trace | Directories where trace files are written |
Diag Alert | |
Diag Incident | |
Diag Cdump | |
Health Monitor | |
Default Trace File | The location of the (default) trace files for the current process. See also tracing SQL execution. |
Active Problem Count | |
Active Incident Count | |
ORACLE_HOME | Location of the Oracle home |
Attention Log | Introduced in 21c. |