下面这个脚本是显示哪些活动事务占用undo空间
set lines 200
set pages 999
clear col
set termout off
set trimout on
set trimspool on
REM
REM Current transactions
REM
REM Will show only last transaction by a user
REM
REM May need to use 786472.1 for better picture
REM of activity
connect / as sysdba
alter session set nls_date_format='dd-Mon-yyyy hh24:mi';
col username format a10 wrapped heading "User"
col name format a22 wrapped heading "Undo Segment Name"
col xidusn heading "Undo|Seg #"
col xidslot heading "Undo|Slot #"
col xidsqn heading "Undo|Seq #"
col ubafil heading "File #"
col ubablk heading "Block #"
col start_time format a10 word_wrapped heading "Started"
col status format a8 heading "Status"
col blk format 999,999,999 heading "KBytes"
col used_urec heading "Rows"
col username format a10
col OSUSER format a10
col MACHINE format a10
col