-- EVENT MONITORING SELECT EVENT , SUM(TIME_WAITED) SUM , ROUND(RATIO_TO_REPORT(SUM(TIME_WAITED)) OVER (), 2) AS RATIO FROM GV$ACTIVE_SESSION_HISTORY WHERE SAMPLE_TIME BETWEEN SYSDATE - 3/1440 AND SYSDATE GROUP BY EVENT ORDER BY SUM DESC ; -- FIND SQL_ID FROM EVENT SELECT SQL_ID, EVENT , SUM(TIME_WAITED) SUM , ROUND(RATIO_TO_REPORT(SUM(TIME_WAITED)) OVER (), 2) AS RATIO FROM GV$ACTIVE_SESSION_HISTORY WHERE SAMPLE_TIME BETWEEN SYSDATE - 3/1440 AND SYSDATE AND EVENT = 'latch: cache buffers chains' GROUP BY SQL_ID, EVENT ORDER BY SUM DESC ; -- FIND SQL TEXT FROM SQL_ID SELECT SQL_FULLTEXT FROM V$SQLAREA WHERE SQL_ID = '5frpptd8mtvx0' ...