How the Oracle DBA can find the Wait time percentage of the total DB time during the last hour.
DBA Oracle
Compatibility: Oracle 11g
Creator: Cyrille MODIANO – Montreal
SELECT metric_name, ROUND(AVG(value),1) "Average Wait time %" FROM v$sysmetric_history WHERE metric_name = 'Database Wait Time Ratio' GROUP BY metric_name;