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

ID :  Password : Auto  

   ȸ¿ø:0¸í / ¼Õ´Ô:0¸í
 

 

Technote

ÀÚ·á ¹× °ü¸®ÆÁ

  • DBA Notes
  • Q & A

    ºÏ¸¶Å©
  • Asktom
       (Oracle ÀÇ ´ëÇ¥ Forum)
  • Technical Bulltin(KR)
       (±â¼úÁö¿ø°Ô½ÃÆÇ)
  • Dbazine

  •  

     


     Æ®·£Àè¼Ç ¸ð´ÏÅ͸µ
    park1q  2017-06-23 14:41:01, Á¶È¸ : 3,842, Ãßõ : 1099


    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-2025 Zeroboard

     

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