기본 콘텐츠로 건너뛰기

ACTIVE_SESSION_HISTORY


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;

댓글

이 블로그의 인기 게시물

redo log list

-------------------------------------------------------------------------------- SELECT GROUP#, STATUS, TYPE, MEMBER, IS_RECOVERY_DEST_FILE   FROM GV$LOGFILE  ORDER BY GROUP#, MEMBER; -------------------------------------------------------------------------------- SELECT *   FROM V$LOG  ORDER BY GROUP#; -------------------------------------------------------------------------------- SELECT A.GROUP#, A.MEMBER, B.STATUS, B.BYTES/1024/1024 AS MBytes   FROM V$LOGFILE A, V$LOG B WHERE A.GROUP# = B.GROUP#  ORDER BY A.GROUP#, A.MEMBER; -------------------------------------------------------------------------------- SELECT *   FROM V$LOG_HISTORY  ORDER BY SEQUENCE# DESC; --------------------------------------------------------------------------------