欢迎使用CSDN-markdown编辑器

select a.username,
a.sid,
a.sql_hash_value,
b.name,
a.status,
c.used_urec,
c.used_ublk,
c.used_ublk*8/1024/1024,
a.machine
from v$session a,v$rollname b,v$transaction  c
where a.saddr=c.ses_addr
and b.usn=c.xidusn
and used_ublk*8/1024/1024>10