Database Administration & Monitoring A look at PostgreSQL 9.6 – The wait interface 16.05.2016 by Daniel Westermann For a long time there was no real wait interface in PostgreSQL core. Now, with the upcoming 9.6, pg_stat_activity was extended to provide more meaningful information for what a session is currently waiting on.
Database Administration & Monitoring, Oracle Oracle 12.1.0.2: Wait event histograms in μs 04.08.2014 by Oracle Team By Franck Pachot . When an Oracle Database spends a high percentage of its DB time in User I/O, I usually check the wait event histograms in order to see if the storage system is working well. But today,(…)