ACTIVE_SESSION_HISTORY 1월 06, 2016 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; 태그 active_session_history oracle 댓글
merge in mariadb (upsert) 1월 21, 2016 http://mechanics.flite.com/blog/2013/09/30/how-to-do-an-upsert-in-mysql/ merge =>insert ... on duplicate key update 자세한 내용 보기
댓글
댓글 쓰기