MY COMPASS

SELECT EVENT, A.*     FROM V$ACTIVE_SESSION_HISTORY A    WHERE     SAMPLE_TIME BETWEEN TO_DATE ('20160106 120000',                                           'YYYYMMDD HH24MISS')                              AND TO_DATE ('20160106 163000',                                           'YYYYMMDD HH24MISS')          AND EVENT = 'enq: TX - row lock contention' ORDER BY SAMPLE_ID DESC;