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

/*******产生一个事务*********/
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博客 ” ，链接：http://blog.itpub.net/9240380/viewspace-758110/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9240380/viewspace-758110/