--v$transaction 列出活动的事务。这种方法事务提交之后used_ublk清空,不能用于查看ddl是否生成undo
select used_ublk
from v$transaction
where addr =
(select taddr
from v$session
where sid = (select sid from v$mystat where rownum = 1));
--v$mystat 包含当前会话的统计信息,是累加的,可以用于查看ddl是否生成undo
select vs.name, ms.value
from v$mystat ms, v$sysstat vs
where ms.statistic# = vs.statistic#
and name = 'undo change vector size';
ddl操作是否会产生undo?