查看undo中sql语句的占用景况

查看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;

?

?