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;
-- sample test source Sample database with test suite http://www.slideshare.net/bytebot/mariadb-10-the-complete-tutorial http://ora-sysdba.tistory.com/
댓글
댓글 쓰기