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;
* Sites to Learn Coding FreeCodeCamp Codecademy Code * Refs Top 10 Websites to Learn Coding DataScience Learning Site Class Central : MOOC Trending Courses Online 45
댓글
댓글 쓰기