Search notes:

Oracle: V$DIAG_INFO

v$diag_info displays the state of the Automatic Diagnostic Repository (ADR).

select
-- inst_id,
   value
from
   v$diag_info
where
   name = 'Default Trace File';

Name

Names that are found in 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.

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1740469023, '3.15.186.178', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/dynamic-performance-views/diag/info/index(70): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78

Oracle: V$DIAG_INFO

Name

See also