|
执行的脚本如下:
SQL> select * from v$rollname;
USN NAME
---------- ------------------------------
0 SYSTEM
11 _SYSSMU11_2158802674$
alter system dump undo header "_SYSSMU11_2158802674$";
insert into tuser(id,name,pwd,uuid) values(4,'hell','hh','4');
commit;
alter system dump undo header "_SYSSMU11_2158802674$";
select * from v$diag_info where name='Default Trace File';
!date
Thu Jan 16 16:34:01 CST 2014
去trace文件查询这个时间的dump文件如下:
*** 2014-01-16 16:34:01.103
********************************************************************************
Undo Segment: _SYSSMU11_2158802674$ (11)
********************************************************************************
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 spare2: 0 #extents: 2 #blocks: 15
last map 0x00000000 #maps: 0 offset: 4080
Highwater:: 0x0300000d ext#: 0 blk#: 4 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
-----------------------------------------------------------------
0x03000009 length: 7
0x03000010 length: 8
Retention Table
-----------------------------------------------------------
Extent Number:0 Commit Time: 1389860682
Extent Number:1 Commit Time: 1389861045
TRN CTL:: seq: 0x0019 chd: 0x001f ctl: 0x0021 inc: 0x00000000 nfb: 0x0001
mgc: 0xb000 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)
uba: 0x0300000d.0019.04 scn: 0x0000.002695e8
Version: 0x01
FREE BLOCK POOL::
uba: 0x0300000d.0019.06 ext: 0x0 spc: 0x1c7a
uba: 0x00000000.0018.22 ext: 0x1 spc: 0xa62
uba: 0x00000000.0010.34 ext: 0x1 spc: 0x1ea
uba: 0x00000000.0000.00 ext: 0x0 spc: 0x0
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 0x001c 0x0004 0x0000.00269608 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1389860924
0x01 9 0x00 0x001d 0x001e 0x0000.002696b2 0x0300000c 0x0000.000.00000000 0x00000001 0x00000000 1389861227
0x02 9 0x00 0x001c 0x000f 0x0000.00269626 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1389860984
0x03 9 0x00 0x001c 0x0005 0x0000.002695ec 0x03000015 0x0000.000.00000000 0x00000001 0x00000000 1389860863
0x04 9 0x00 0x001c 0x0007 0x0000.0026960a 0x03000016 0x0000.000.00000000 0x00000001 0x00000000 1389860924
0x05 9 0x00 0x001c 0x0000 0x0000.00269606 0x03000015 0x0000.000.00000000 0x00000001 0x00000000 1389860924
0x06 9 0x00 0x001c 0x0002 0x0000.00269624 0x03000016 0x0000.000.00000000 0x00000001 0x00000000 1389860984
0x07 9 0x00 0x001c 0x0006 0x0000.0026960c 0x03000016 0x0000.000.00000000 0x00000001 0x00000000 1389860924
0x08 9 0x00 0x001c 0x000c 0x0000.00269648 0x03000009 0x0000.000.00000000 0x00000001 0x00000000 1389861045
0x09 9 0x00 0x001c 0x000d 0x0000.0026962a 0x03000017 0x0000.000.00000000 0x00000001 0x00000000 1389860984
0x0a 9 0x00 0x001c 0x0010 0x0000.00269662 0x03000009 0x0000.000.00000000 0x00000001 0x00000000 1389861087
0x0b 9 0x00 0x001c 0x000e 0x0000.00269644 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1389861045
0x0c 9 0x00 0x001c 0x000a 0x0000.00269657 0x03000009 0x0000.000.00000000 0x00000001 0x00000000 1389861078
0x0d 9 0x00 0x001c 0x000b 0x0000.00269642 0x03000017 0x0000.000.00000000 0x00000001 0x00000000 1389861045
0x0e 9 0x00 0x001c 0x0008 0x0000.00269646 0x03000009 0x0000.000.00000000 0x00000001 0x00000000 1389861045
0x0f 9 0x00 0x001c 0x0009 0x0000.00269628 0x03000017 0x0000.000.00000000 0x00000001 0x00000000 1389860984
0x10 9 0x00 0x001c 0x0013 0x0000.00269669 0x03000009 0x0000.000.00000000 0x00000001 0x00000000 1389861105
0x11 9 0x00 0x001c 0x001a 0x0000.00269693 0x0300000b 0x0000.000.00000000 0x00000001 0x00000000 1389861166
0x12 9 0x00 0x001c 0x0017 0x0000.0026966f 0x0300000a 0x0000.000.00000000 0x00000001 0x00000000 1389861106
0x13 9 0x00 0x001c 0x0015 0x0000.0026966b 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1389861106
0x14 9 0x00 0x001c 0x0018 0x0000.0026967c 0x0300000a 0x0000.000.00000000 0x00000001 0x00000000 1389861121
0x15 9 0x00 0x001c 0x0012 0x0000.0026966d 0x0300000a 0x0000.000.00000000 0x00000001 0x00000000 1389861106
0x16 9 0x00 0x001c 0x0014 0x0000.0026967a 0x0300000a 0x0000.000.00000000 0x00000001 0x00000000 1389861121
0x17 9 0x00 0x001c 0x0016 0x0000.00269678 0x0300000a 0x0000.000.00000000 0x00000001 0x00000000 1389861121
0x18 9 0x00 0x001c 0x0019 0x0000.0026968f 0x0300000a 0x0000.000.00000000 0x00000001 0x00000000 1389861166
0x19 9 0x00 0x001c 0x0011 0x0000.00269691 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1389861166
0x1a 9 0x00 0x001c 0x001d 0x0000.00269695 0x0300000b 0x0000.000.00000000 0x00000001 0x00000000 1389861166
0x1b 9 0x00 0x001c 0x0001 0x0000.002696a8 0x0300000c 0x0000.000.00000000 0x00000001 0x00000000 1389861197
0x1c 9 0x00 0x001c 0x001b 0x0000.002696a6 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1389861197
0x1d 9 0x00 0x001c 0x001c 0x0000.002696a4 0x0300000b 0x0000.000.00000000 0x00000001 0x00000000 1389861197
0x1e 9 0x00 0x001c 0x0020 0x0000.002696b4 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1389861227
0x1f 9 0x00 0x001b 0x0003 0x0000.002695ea 0x03000015 0x0000.000.00000000 0x00000001 0x00000000 1389860863
0x20 9 0x00 0x001c 0x0021 0x0000.002696b6 0x0300000d 0x0000.000.00000000 0x00000001 0x00000000 1389861227
0x21 9 0x00 0x001c 0xffff 0x0000.002696b8 0x0300000d 0x0000.000.00000000 0x00000001 0x00000000 1389861227
EXT TRN CTL::
usn: 11
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
********************************************************************************
Undo Segment: _SYSSMU11_2158802674$ (11)
********************************************************************************
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 spare2: 0 #extents: 2 #blocks: 15
last map 0x00000000 #maps: 0 offset: 4080
Highwater:: 0x0300000d ext#: 0 blk#: 4 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
-----------------------------------------------------------------
0x03000009 length: 7
0x03000010 length: 8
Retention Table
-----------------------------------------------------------
Extent Number:0 Commit Time: 1389860682
Extent Number:1 Commit Time: 1389861045
TRN CTL:: seq: 0x0019 chd: 0x0005 ctl: 0x0003 inc: 0x00000000 nfb: 0x0001
mgc: 0xb000 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)
uba: 0x0300000d.0019.09 scn: 0x0000.002695ec
Version: 0x01
FREE BLOCK POOL::
uba: 0x0300000d.0019.0c ext: 0x0 spc: 0x19fa
uba: 0x00000000.0018.22 ext: 0x1 spc: 0xa62
uba: 0x00000000.0010.34 ext: 0x1 spc: 0x1ea
uba: 0x00000000.0000.00 ext: 0x0 spc: 0x0
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 0x001c 0x0004 0x0000.00269608 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1389860924
0x01 9 0x00 0x001d 0x001e 0x0000.002696b2 0x0300000c 0x0000.000.00000000 0x00000001 0x00000000 1389861227
0x02 9 0x00 0x001c 0x000f 0x0000.00269626 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1389860984
0x03 9 0x00 0x001d 0xffff 0x0000.002696c3 0x0300000d 0x0000.000.00000000 0x00000001 0x00000000 1389861240
0x04 9 0x00 0x001c 0x0007 0x0000.0026960a 0x03000016 0x0000.000.00000000 0x00000001 0x00000000 1389860924
0x05 9 0x00 0x001c 0x0000 0x0000.00269606 0x03000015 0x0000.000.00000000 0x00000001 0x00000000 1389860924
0x06 9 0x00 0x001c 0x0002 0x0000.00269624 0x03000016 0x0000.000.00000000 0x00000001 0x00000000 1389860984
0x07 9 0x00 0x001c 0x0006 0x0000.0026960c 0x03000016 0x0000.000.00000000 0x00000001 0x00000000 1389860924
0x08 9 0x00 0x001c 0x000c 0x0000.00269648 0x03000009 0x0000.000.00000000 0x00000001 0x00000000 1389861045
0x09 9 0x00 0x001c 0x000d 0x0000.0026962a 0x03000017 0x0000.000.00000000 0x00000001 0x00000000 1389860984
0x0a 9 0x00 0x001c 0x0010 0x0000.00269662 0x03000009 0x0000.000.00000000 0x00000001 0x00000000 1389861087
0x0b 9 0x00 0x001c 0x000e 0x0000.00269644 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1389861045
0x0c 9 0x00 0x001c 0x000a 0x0000.00269657 0x03000009 0x0000.000.00000000 0x00000001 0x00000000 1389861078
0x0d 9 0x00 0x001c 0x000b 0x0000.00269642 0x03000017 0x0000.000.00000000 0x00000001 0x00000000 1389861045
0x0e 9 0x00 0x001c 0x0008 0x0000.00269646 0x03000009 0x0000.000.00000000 0x00000001 0x00000000 1389861045
0x0f 9 0x00 0x001c 0x0009 0x0000.00269628 0x03000017 0x0000.000.00000000 0x00000001 0x00000000 1389860984
0x10 9 0x00 0x001c 0x0013 0x0000.00269669 0x03000009 0x0000.000.00000000 0x00000001 0x00000000 1389861105
0x11 9 0x00 0x001c 0x001a 0x0000.00269693 0x0300000b 0x0000.000.00000000 0x00000001 0x00000000 1389861166
0x12 9 0x00 0x001c 0x0017 0x0000.0026966f 0x0300000a 0x0000.000.00000000 0x00000001 0x00000000 1389861106
0x13 9 0x00 0x001c 0x0015 0x0000.0026966b 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1389861106
0x14 9 0x00 0x001c 0x0018 0x0000.0026967c 0x0300000a 0x0000.000.00000000 0x00000001 0x00000000 1389861121
0x15 9 0x00 0x001c 0x0012 0x0000.0026966d 0x0300000a 0x0000.000.00000000 0x00000001 0x00000000 1389861106
0x16 9 0x00 0x001c 0x0014 0x0000.0026967a 0x0300000a 0x0000.000.00000000 0x00000001 0x00000000 1389861121
0x17 9 0x00 0x001c 0x0016 0x0000.00269678 0x0300000a 0x0000.000.00000000 0x00000001 0x00000000 1389861121
0x18 9 0x00 0x001c 0x0019 0x0000.0026968f 0x0300000a 0x0000.000.00000000 0x00000001 0x00000000 1389861166
0x19 9 0x00 0x001c 0x0011 0x0000.00269691 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1389861166
0x1a 9 0x00 0x001c 0x001d 0x0000.00269695 0x0300000b 0x0000.000.00000000 0x00000001 0x00000000 1389861166
0x1b 9 0x00 0x001c 0x0001 0x0000.002696a8 0x0300000c 0x0000.000.00000000 0x00000001 0x00000000 1389861197
0x1c 9 0x00 0x001c 0x001b 0x0000.002696a6 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1389861197
0x1d 9 0x00 0x001c 0x001c 0x0000.002696a4 0x0300000b 0x0000.000.00000000 0x00000001 0x00000000 1389861197
0x1e 9 0x00 0x001c 0x0020 0x0000.002696b4 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1389861227
0x1f 9 0x00 0x001c 0x0003 0x0000.002696c1 0x0300000d 0x0000.000.00000000 0x00000001 0x00000000 1389861240
0x20 9 0x00 0x001c 0x0021 0x0000.002696b6 0x0300000d 0x0000.000.00000000 0x00000001 0x00000000 1389861227
0x21 9 0x00 0x001c 0x001f 0x0000.002696b8 0x0300000d 0x0000.000.00000000 0x00000001 0x00000000 1389861227
EXT TRN CTL::
usn: 11
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
根据前面一个TRN CTL:: chd: 0x001f 从这个找到0x1f这条记录
0x1f 9 0x00 0x001b 0x0003 0x0000.002695ea 0x03000015 0x0000.000.00000000 0x00000001 0x00000000 1389860863
找出来是0x0000.002695ea
去下一个TRN CTL:: scn找 scn: 0x0000.002695ec 找出来是 0x0000.002695ec 差一点
请大师帮忙看看! 我哪里执行错了 谢谢了!!!
|
|