查看undo中sql语句的占用情况
select *
from (select maxqueryid, round(sum(undoblks) * 8 / 1024) consumed_size_MB
from v$undostat
group by maxqueryid
order by consumed_size_MB desc)
where rownum < 50;
查看undo中sql语句的占用情况
select *
from (select maxqueryid, round(sum(undoblks) * 8 / 1024) consumed_size_MB
from v$undostat
group by maxqueryid
order by consumed_size_MB desc)
where rownum < 50;