/*******产生一个事务*********/
SQL> insert into t_ts values(1);

1 row created.

/*******查询上述事务对应的回滚段头及文件******/
SQL> select segment_name,header_file,header_block from dba_segments where segment_name=(select name from v$rollname where usn=(select xidusn from v$transaction));

SEGMENT_NAME HEADER_FILE HEADER_BLOCK
-------------------------------------------------------------------------------- ----------- ------------
_SYSSMU6_821479913$ 3 208

/*******转储回滚段头********/
SQL> alter system dump datafile 3 block 208;

System altered

/********另一处方式转储回滚段头*******/
SQL> alter system dump undo header '_SYSSMU6_821479913$';

System altered

/*****具体事务涉及的undo block请参看v$transaction*********/

ITPub博客

dump转储undo segment header block回滚段头块小方法

最新文章