www.1q.co.kr(park1q.com)

ID :  Password : Auto  

   회원:0명 / 손님:0명
 

 

Technote

자료 및 관리팁

  • DBA Notes
  • Q & A

    북마크
  • Asktom
       (Oracle 의 대표 Forum)
  • Technical Bulltin(KR)
       (기술지원게시판)
  • Dbazine

  •  

     


     db link 세션 모니터링
    park1q  2009-05-12 15:36:42, 조회 : 4,534, 추천 : 1138


    ************************ db link 세션 모니터링 ************************
    1. local site 에서 remote 의 100만건 테이블을 select 했을경우
    Select /*+ ORDERED */
           substr(s.ksusemnm, 1, 10) || '-' || substr(s.ksusepid, 1, 10) "ORIGIN",
           substr(g.K2GTITID_ORA, 1, 35) "GTXID",
           substr(s.indx, 1, 4) || '.' || substr(s.ksuseser, 1, 5) "LSESSION",
           substr(decode(bitand(ksuseidl, 11),
                         1,
                         'ACTIVE',
                         0,
                         decode(bitand(ksuseflg, 4096), 0, 'INACTIVE', 'CACHED'),
                         2,
                         'SNIPED',
                         3,
                         'SNIPED',
                         'KILLED'),
                  1,
                  1) "S",
           substr(event, 1, 10) "WAITING"
      from x$k2gte g, x$ktcxb t, x$ksuse s, v$session_wait w
     where g.K2GTDXCB = t.ktcxbxba
       and g.K2GTDSES = t.ktcxbses
       and s.addr = g.K2GTDSES
       and w.sid = s.indx

     
    ########## On local site
    ORIGIN                         GTXID                          LSESSION                       S    WAITING
    ------------------------------ ------------------------------ -----------------------------  ---- ----------------------------------------
    MSHOMEPAR-2284:2792           ADM1Q.8d6cf5d2.2.19.21959      151.474                        I    SQL*Net me


    ########## On remote site
    ORIGIN                         GTXID                          LSESSION                       S  WAITING
    ------------------------------ ------------------------------ ------------------------------ -- --------------------
    adm01-10481                    ADM1Q.8d6cf5d2.2.19.21959      524.36185                      I  SQL*Net me


      추천하기 프린트   목록보기

    Copyright 1999-2018 Zeroboard

     

     
     
    [Today:3 / Total:154186]    Design by p@rk1q