undo回滚对象查看

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