select * from v$fast_start_transactions;
USN SLT SEQ STATE UNDOBLOCKSDONE UNDOBLOCKSTOTAL PID CPUTIME PARENTUSN PARENTSLT PARENTSEQ XID PXID RCVSERVERS
---------- ---------- ---------- ---------------- -------------- --------------- ---------- ---------- ---------- ---------- ---------- ---------------- ---------------- ----------
11005 11 138 RECOVERING 5555 17772 27 21 0 0 0 FD2A0B008A000000 0000000000000000 3
select * from v$rollname where usn=11005;
USN NAME
---------- ------------------------------
11005 _SYSSMU11005_3138824131$
alter system dump undo block "_SYSSMU11005_3138824131$" XID 11005 11 138;
select * from v$diag_info;
object number（objn）或者object id（objd）
more /ora11203/app/diag/rdbms/crmdb/crmdb/trace/crmdb_ora_8070.trc |grep objn |more
* Rec #0x2e slt: 0x0b objn: 76496(0x00012ad0) objd: 76496 tblspc: 4(0x00000004)
* Rec #0x2d slt: 0x0b objn: 76495(0x00012acf) objd: 76495 tblspc: 4(0x00000004)
* Rec #0x2c slt: 0x0b objn: 83147(0x000144cb) objd: 83147 tblspc: 4(0x00000004)
* Rec #0x2b slt: 0x0b objn: 76497(0x00012ad1) objd: 76497 tblspc: 4(0x00000004)
select owner,object_name,object_type from dba_objects where object_id in ('76496','76495','83147','76497'); EMR T_EC_TENT TABLE EMR TENT_INDEX INDEX EMR I_XXX INDEX EMR IND_BAZ INDEX
