Skip to content

Instantly share code, notes, and snippets.

@Tracnac
Last active September 23, 2022 16:56
Show Gist options
  • Select an option

  • Save Tracnac/92a7200f07b7964795ee034dbf0a5573 to your computer and use it in GitHub Desktop.

Select an option

Save Tracnac/92a7200f07b7964795ee034dbf0a5573 to your computer and use it in GitHub Desktop.
Diagnostic directory #oracle
set linesize 128
col name for a24
col value for a96
SELECT NAME, VALUE
FROM V$DIAG_INFO;


NAME                     VALUE
------------------------ ------------------------------------------------------------------------------------------------
Diag Enabled             TRUE
ADR Base                 /opt/oracle/rdbms/admin
ADR Home                 /opt/oracle/rdbms/admin/diag/rdbms/gti11/GTI11
Diag Trace               /opt/oracle/rdbms/admin/diag/rdbms/gti11/GTI11/trace
Diag Alert               /opt/oracle/rdbms/admin/diag/rdbms/gti11/GTI11/alert
Diag Incident            /opt/oracle/rdbms/admin/diag/rdbms/gti11/GTI11/incident
Diag Cdump               /opt/oracle/rdbms/admin/diag/rdbms/gti11/GTI11/cdump
Health Monitor           /opt/oracle/rdbms/admin/diag/rdbms/gti11/GTI11/hm
Default Trace File       /opt/oracle/rdbms/admin/diag/rdbms/gti11/GTI11/trace/GTI11_ora_11716.trc
Active Problem Count     0
Active Incident Count    0
11 rows selected.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment