select s.sid,r.name,extents,used_ublk*8/1024 usered_mb,start_time
from v$transaction t,v$rollstat rs,v$rollname r,v$session s
where t.xidusn=rs.usn
and t.xidusn=r.usn
and t.addr=s.taddr;
select s.sid,r.name,extents,used_ublk*8/1024 usered_mb,start_time
from v$transaction t,v$rollstat rs,v$rollname r,v$session s
where t.xidusn=rs.usn
and t.xidusn=r.usn
and t.addr=s.taddr;
确定使用回滚段的大小
最新推荐文章于 2021-04-12 14:47:59 发布