
|
 |

|
 Æ®·£Àè¼Ç ¸ð´ÏÅ͸µ
|
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 ;
|
|
|
|
|
|
|