Just a quick query to run to see if there’s a particular wait event that’s spiking during a timeframe: select COUNT(*), event, sample_time, inst_id from gv$active_session_history where sample_time BETWEEN TRUNC(SYSDATE) + (10/24) + (50/60)/24 AND TRUNC(SYSDATE) + (10/24) + (56/60)/24 HAVING COUNT(*) > 10 GROUP BY event, sample_time, inst_id ORDER BY sample_time, event, instead ; […]