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

ID :  Password : Auto  

   회원:0명 / 손님:0명
 

 

Technote

자료 및 관리팁

  • DBA Notes
  • Q & A

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

  •  

     


     트랜잭션 모니터링
    park1q  2009-05-14 14:20:43, 조회 : 3,167, 추천 : 976


    SELECT s.sid,
           s.username,
           t.used_ublk * 8192 / 1024 / 1024 / 1024 used_ublk_GB,
           t.used_urec,
           rs.segment_name,
           r.rssize / 1024 / 1024 / 1024 rssize_GB,
           r.status
      FROM v$transaction t, v$session s, v$rollstat r, dba_rollback_segs rs
     WHERE s.saddr = t.ses_addr
       AND t.xidusn = r.usn
       AND rs.segment_id = t.xidusn
     ORDER BY t.used_ublk DESC;
     
    SELECT /*+ ordered no_merge(r) use_hash(t r s p) */
           s.username,       -- 0
           s.sid,            -- 1
           s.serial#,        -- 2
           p.spid,           -- 3
           s.machine,        -- 4
           t.status,         -- 5
           t.recursive,      -- 6
           r.name,           -- 7
           s.module,         -- 8
           s.program,        -- 9
           trunc((sysdate - to_date(t.start_time, 'MM/DD/YY HH24:MI:SS')) * 86400) duration, -- 10
           t.used_ublk,      -- 11
           t.used_urec,      -- 12
           t.log_io,         -- 13
           t.phy_io          -- 14
      FROM v$transaction t, v$rollname r, v$session s, v$process p
     WHERE s.saddr = t.ses_addr
       and t.xidusn = r.usn
       and s.paddr = p.addr
     ORDER BY 1 asc ;
     


      추천하기 프린트   목록보기

    Copyright 1999-2018 Zeroboard

     

     
     
    [Today:5 / Total:157070]    Design by p@rk1q