기본 콘텐츠로 건너뛰기

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;

댓글

이 블로그의 인기 게시물

[BOOK] 헬로 데이터 과학

R 환경 구축  https://cran.r-project.org/ https://www.rstudio.com/ 저자 URL facebook : www.facebook.com/hellodatascience blog : www.hellodatascience.com facebook2 : www.facebook.com/group/livingdata github https://github.com/jykim/dbook QS http://quantifiedself.com Reference https://en.wikipedia.org/wiki/Missing_data https://www.kaggle.com/competitions OECD - https://data.oecd.org 국가 통계 포털 - http://kosis.kr