1.回滚段的活动事务
SELECT name, xacts FROM v$rollname, v$rollstat
WHERE status = 'PENDING OFFLINE' AND v$rollname.usn = v$rollstat.usn;
NAME XACTS
------------------------------ ----------
_SYSSMU13_1506923025$ 9
2.
SELECT * FROM x$ktuxe WHERE ktuxecfl = 'DEAD';
ADDR INDX INST_ID KTUXEUSN KTUXESLT KTUXESQN KTUXERDBF KTUXERDBB KTUXESCNB KTUXESCNW KTUXESTA KTUXECFL KTUXEUEL KTUXEDDBF KTUXEDDBB KTUXEPUSN KTUXEPSLT KTUXEPSQN KTUXESIZ
---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------------- ------------------------ ---------- ---------- ---------- ---------- ---------- ---------- ----------
没有记录
3.dump undo header情况:
alter system dump undo header "_SYSSMU13_1506923025$";
********************************************************************************
Undo Segment: _SYSSMU13_1506923025$ (13)
********************************************************************************
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 spare2: 0 #extents: 2 #blocks: 15
last map 0x00000000 #maps: 0 offset: 4080
Highwater:: 0x00c0121a ext#: 0 blk#: 1 ext size: 7
#blocks in seg. hdr's freelists: 0
#blocks below: 0
mapblk 0x00000000 offset: 0
Unlocked
Map Header:: next 0x00000000 #extents: 2 obj#: 0 flag: 0x40000000
Extent Map
-----------------------------------------------------------------
0x00c01219 length: 7
0x00f22598 length: 8
Retention Table
-----------------------------------------------------------
Extent Number:0 Commit Time: 1290041932
Extent Number:1 Commit Time: 1289995529
TRN CTL:: seq: 0x0852 chd: 0x0009 ctl: 0x000c inc: 0x00000000 nfb: 0x0001
mgc: 0xb000 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)
uba: 0x00c0121a.0852.02 scn: 0x0000.20532739
Version: 0x01
FREE BLOCK POOL::
uba: 0x00c0121a.0852.02 ext: 0x0 spc: 0x1f32
uba: 0x00000000.0851.1d ext: 0xb spc: 0x14ac
uba: 0x00000000.0850.09 ext: 0xa spc: 0x1a94
uba: 0x00000000.0819.2a ext: 0xa spc: 0x266
uba: 0x00000000.0000.00 ext: 0x0 spc: 0x0
TRN TBL::
index state cflags wrap# uel scn dba parent-xid nub stmt_num cmt
------------------------------------------------------------------------------------------------
0x00 9 0x00 0x49d2 0x000c 0x0000.2054bb1a 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1290041932
0x01 9 0x00 0x4a61 0x000f 0x0000.2053dc8d 0x00eb7095 0x0000.000.00000000 0x00000001 0x00000000 1290004092
0x02 9 0x00 0x45d2 0x0021 0x0000.2053d5b5 0x00eb7095 0x0000.000.00000000 0x00000001 0x00000000 1290004075
0x03 9 0x00 0x49a8 0x0015 0x0000.20538cd5 0x00eb7094 0x0000.000.00000000 0x00000001 0x00000000 1290003851
0x04 9 0x00 0x4b03 0x0000 0x0000.2054bb17 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1290041932
0x05 9 0x00 0x4b12 0x001a 0x0000.20536aef 0x00eb7086 0x0000.000.00000000 0x00000001 0x00000000 1290003747
0x06 9 0x00 0x4b09 0x0002 0x0000.2053d5b2 0x00eb7093 0x0000.000.00000000 0x00000001 0x00000000 1290004075
0x07 9 0x00 0x4acb 0x0001 0x0000.2053d5e1 0x00eb7095 0x0000.000.00000000 0x00000001 0x00000000 1290004075
0x08 9 0x00 0x4af5 0x0020 0x0000.2053e7a8 0x00eb7095 0x0000.000.00000000 0x00000001 0x00000000 1290004152
0x09 9 0x00 0x4aed 0x0014 0x0000.2053273c 0x00eb7086 0x0000.000.00000000 0x00000001 0x00000000 1290003547
0x0a 9 0x00 0x4133 0x0003 0x0000.20538cc4 0x00eb7094 0x0000.000.00000000 0x00000001 0x00000000 1290003851
0x0b 9 0x00 0x4979 0x0019 0x0000.205340bd 0x00eb7086 0x0000.000.00000000 0x00000001 0x00000000 1290003626
0x0c 9 0x00 0x4925 0xffff 0x0000.207bba94 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1290062405
0x0d 9 0x00 0x4b0a 0x001c 0x0000.2053553e 0x00eb7086 0x0000.000.00000000 0x00000001 0x00000000 1290003687
0x0e 9 0x00 0x4b17 0x0004 0x0000.20542b66 0x00eb7095 0x0000.000.00000000 0x00000001 0x00000000 1290004393
0x0f 9 0x00 0x4b10 0x0008 0x0000.2053e027 0x00eb7095 0x0000.000.00000000 0x00000001 0x00000000 1290004110
0x10 9 0x00 0x4b04 0x0012 0x0000.2053b97c 0x00eb7093 0x0000.000.00000000 0x00000001 0x00000000 1290003989
0x11 9 0x00 0x4b0a 0x0013 0x0000.20538cb2 0x00eb7094 0x0000.000.00000000 0x00000001 0x00000000 1290003851
0x12 9 0x00 0x4933 0x0006 0x0000.2053c606 0x00eb7093 0x0000.000.00000000 0x00000001 0x00000000 1290004026
0x13 9 0x00 0x4b10 0x000a 0x0000.20538cb7 0x00eb7094 0x0000.000.00000000 0x00000001 0x00000000 1290003851
0x14 9 0x00 0x4b13 0x001b 0x0000.20532742 0x00eb7086 0x0000.000.00000000 0x00000001 0x00000000 1290003547
0x15 9 0x00 0x4a4d 0x001f 0x0000.20538cdb 0x00eb7094 0x0000.000.00000000 0x00000001 0x00000000 1290003851
0x16 9 0x00 0x4b0c 0x0011 0x0000.20538cb0 0x00eb7094 0x0000.000.00000000 0x00000001 0x00000000 1290003851
0x17 9 0x00 0x4afb 0x0007 0x0000.2053d5d3 0x00eb7095 0x0000.000.00000000 0x00000001 0x00000000 1290004075
0x18 9 0x00 0x342d 0x0016 0x0000.20538ca3 0x00eb7094 0x0000.000.00000000 0x00000001 0x00000000 1290003851
0x19 9 0x00 0x4b00 0x000d 0x0000.20534f78 0x00eb7086 0x0000.000.00000000 0x00000001 0x00000000 1290003663
0x1a 9 0x00 0x4b16 0x001d 0x0000.20537031 0x00eb7086 0x0000.000.00000000 0x00000001 0x00000000 1290003758
0x1b 9 0x00 0x4b0b 0x000b 0x0000.20532745 0x00eb7093 0x0000.000.00000000 0x00000020 0x00000000 1290003547
0x1c 9 0x00 0x4b10 0x0005 0x0000.205356d7 0x00eb7086 0x0000.000.00000000 0x00000001 0x00000000 1290003695
0x1d 9 0x00 0x4b0e 0x001e 0x0000.20537844 0x00eb7086 0x0000.000.00000000 0x00000001 0x00000000 1290003790
0x1e 9 0x00 0x4b13 0x0018 0x0000.20537e3f 0x00eb7094 0x0000.000.00000000 0x00000002 0x00000000 1290003818
0x1f 9 0x00 0x39e0 0x0010 0x0000.20538ce9 0x00eb7093 0x0000.000.00000000 0x00000001 0x00000000 1290003851
0x20 9 0x00 0x4b22 0x000e 0x0000.205419d1 0x00eb7095 0x0000.000.00000000 0x00000001 0x00000000 1290004333
0x21 9 0x00 0x4b17 0x0017 0x0000.2053d5c0 0x00eb7095 0x0000.000.00000000 0x00000001 0x00000000 1290004075
EXT TRN CTL::
usn: 13
sp1:0x00000000 sp2:0x00000000 sp3:0x00000000 sp4:0x00000000
sp5:0x00000000 sp6:0x00000000 sp7:0x00000000 sp8:0x00000000
EXT TRN TBL::
index extflag extHash extSpare1 extSpare2
---------------------------------------------------
0x00 0x00000000 0x00000000 0x00000000 0x00000000
0x01 0x00000000 0x00000000 0x00000000 0x00000000
0x02 0x00000000 0x00000000 0x00000000 0x00000000
0x03 0x00000000 0x00000000 0x00000000 0x00000000
0x04 0x00000000 0x00000000 0x00000000 0x00000000
0x05 0x00000000 0x00000000 0x00000000 0x00000000
0x06 0x00000000 0x00000000 0x00000000 0x00000000
0x07 0x00000000 0x00000000 0x00000000 0x00000000
0x08 0x00000000 0x00000000 0x00000000 0x00000000
0x09 0x00000000 0x00000000 0x00000000 0x00000000
0x0a 0x00000000 0x00000000 0x00000000 0x00000000
0x0b 0x00000000 0x00000000 0x00000000 0x00000000
0x0c 0x00000000 0x00000000 0x00000000 0x00000000
0x0d 0x00000000 0x00000000 0x00000000 0x00000000
0x0e 0x00000000 0x00000000 0x00000000 0x00000000
0x0f 0x00000000 0x00000000 0x00000000 0x00000000
0x10 0x00000000 0x00000000 0x00000000 0x00000000
0x11 0x00000000 0x00000000 0x00000000 0x00000000
0x12 0x00000000 0x00000000 0x00000000 0x00000000
0x13 0x00000000 0x00000000 0x00000000 0x00000000
0x14 0x00000000 0x00000000 0x00000000 0x00000000
0x15 0x00000000 0x00000000 0x00000000 0x00000000
0x16 0x00000000 0x00000000 0x00000000 0x00000000
0x17 0x00000000 0x00000000 0x00000000 0x00000000
0x18 0x00000000 0x00000000 0x00000000 0x00000000
0x19 0x00000000 0x00000000 0x00000000 0x00000000
0x1a 0x00000000 0x00000000 0x00000000 0x00000000
0x1b 0x00000000 0x00000000 0x00000000 0x00000000
0x1c 0x00000000 0x00000000 0x00000000 0x00000000
0x1d 0x00000000 0x00000000 0x00000000 0x00000000
0x1e 0x00000000 0x00000000 0x00000000 0x00000000
0x1f 0x00000000 0x00000000 0x00000000 0x00000000
0x20 0x00000000 0x00000000 0x00000000 0x00000000
0x21 0x00000000 0x00000000 0x00000000 0x00000000
哪个遇到过此类问题,或者上METALINK帮我查一下也行.我现在暂时上不了METALINK,封了上METALINK网络,谢谢.