SELECT 'ALTER SYSTEM DUMP UNDO BLOCK '''
|| (SELECT name
FROM sys.undo$
WHERE us# = xidusn)
|| ''' XID '
|| xidusn
|| ' '
|| xidslot
|| ' '
|| xidsqn
|| ';'
|| CHR (10)
|| 'ALTER SYSTEM DUMP UNDO HEADER '''
|| (SELECT name
FROM sys.undo$
WHERE us# = xidusn)
|| ''''
|| ';'
|| CHR (10)
|| 'ALTER SYSTEM DUMP DATAFILE '
|| UBAFIL
|| ' BLOCK '
|| UBABLK
|| ';'
c70
,XIDUSN
,XIDSLOT
,XIDSQN
,UBAFIL
,UBABLK
,UBASQN
,UBAREC
,STATUS
,used_ublk
,USED_UREC
,xid
,ADDR
,START_DATE
FROM v$transaction;
--在执行类似这个
ALTER SYSTEM DUMP UNDO BLOCK '_SYSSMU10_1197734989$' XID 10 15 2983;
|