Undo段中区的状态free expiredinactiveactive 显示UNDO区信息 SELECT extent_ id, bytes, status FROM dba_ _undo_ _extentsWHERE segment_ name=' SYSSMU1S' ; 图解一一个事务的操作流程 Undo段的组成:段头、回滚块 事务ID select xid, xidusn, xidslot, xidsqn, ubab1k, ubafil from vStransaction;事务表 undo段的第一一个 数据块,每一个回滚段最多可以47个事务回滚段的段头块 select * from vSro1 lname; select header. block, header_ file from dba segments where segment_ _name='_ SYSSMU1S' ;alter system dump undo header,SYSSMU1S' :/转储回滚段头Ialter system dump datafile 5 block 4308;//转储回滚段数据块事务槽: xid、uba | |
select spid from v$process where addr in (select paddr from v$session where sid=(select sid from v$mystat where rownum=1)) ; | |