Search notes:

Oracle Active Session History (ASH)

Each second, the performance relevant figures for each active session are stored in memory.
The figures can be queried from v$active_session_history.
ASH can be used for diagnosing performance problems.
ASH is an integral part of the database self-management framework.

See also

v$ash_info shows some information about the Active Session History sampling process.
$ORACLE_HOME/admin/rdbms/ashrpt.sql is an SQL*Plus script to generate an ASH report.
oradebug dump ashdump

Index

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...', 1741107539, '18.118.93.209', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/Active-Session-History(51): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78