EVENT SQL MONITORING

-- 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'
;