揭密一致性读------之UNDO一致性构造
来源：互联网 发布：最新手游服务端源码 编辑：程序博客网 时间：2024/05/19 05:04
转载请注明出处：http://blog.csdn.net/guoyjoe/article/details/14088663
gyj@OCM> create table gyj(id int,name char(2000));
Table created.
gyj@OCM> insert into gyj values(1,'AAAAA');
1 row created.
gyj@OCM> commit;
Commit complete.
gyj@OCM> var x refcursor;
gyj@OCM> exec open :x for select * from gyj where id=1;
PL/SQL procedure successfully completed.
gyj@OCM> update gyj set name='BBBBB' where id=1;
1 row updated.
gyj@OCM> commit;
Commit complete.
gyj@OCM> update gyj set name='CCCCC' where id=1;
1 row updated.
gyj@OCM> commit;
Commit complete.
gyj@OCM> update gyj set name='DDDDD' where id=1;
1 row updated.
gyj@OCM> commit;
Commit complete.
gyj@OCM> update gyj set name='EEEEE' where id=1;
1 row updated.
gyj@OCM> print :x;
ID NAME
---------- ----------
1 AAAAA
gyj@OCM> alter system flush buffer_cache;
System altered.
gyj@OCM> select * from v$transaction;ADDR XIDUSN XIDSLOT XIDSQN UBAFIL UBABLK UBASQN UBAREC STATUS START_TIME START_SCNB START_SCNW START_UEXT START_UBAFIL START_UBABLK START_UBASQN START_UBAREC SES_ADDR FLAG SPA REC NOU PTX NAME PRV_XIDUSN PRV_XIDSLT PRV_XIDSQN PTX_XIDUSN PTX_XIDSLT PTX_XIDSQN DSCN-B DSCN-W USED_UBLK USED_UREC LOG_IO PHY_IO CR_GET CR_CHANGE START_DATE DSCN_BASE DSCN_WRAP START_SCN DEPENDENT_SCN XID PRV_XID PTX_XID---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------------- -------------------- ---------- ---------- ---------- ------------ ------------ ------------ ------------ ---------------- ---------- --- --- --- --- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ------------ ---------- ---------- ---------- ------------- ---------------- ---------------- ----------------000000008FF105A0 7 2 14757 3 84972 1174 21 ACTIVE 11/02/13 18:29:52 13027640 13 3 84972 1174 21 000000009147B7E0 3587 NO NO NO NO 0 0 0 0 0 0 0 0 1 1 11 3 24 0 02-NOV-13 0 0 13027640 0 07000200A5390000 0000000000000000 0000000000000000sys@OCM> select * from X$KTUXE where KTUXESTA='ACTIVE';ADDR INDX INST_ID KTUXEUSN KTUXESLT KTUXESQN KTUXERDBF KTUXERDBB KTUXESCNB KTUXESCNW KTUXESTA KTUXECFL KTUXEUEL KTUXEDDBF KTUXEDDBB KTUXEPUSN KTUXEPSLT KTUXEPSQN KTUXESIZ---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------------- ------------------------ ---------- ---------- ---------- ---------- ---------- ---------- ----------00002AC148607908 304 1 7 2 14757 3 84972 13027640 0 ACTIVE NONE 13 0 0 0 0 0 1sys@OCM> select header_file,header_block from dba_segments where segment_name='_SYSSMU7_4222772309$';HEADER_FILE HEADER_BLOCK----------- ------------ 3 224sys@OCM> select EXTENT_ID,FILE_ID, BLOCK_ID,BYTES,BLOCKS,STATUS from dba_undo_extents where segment_name='_SYSSMU7_4222772309$'; EXTENT_ID FILE_ID BLOCK_ID BYTES BLOCKS STATUS---------- ---------- ---------- ---------- ---------- --------- 0 3 224 65536 8 EXPIRED 1 3 600 65536 8 EXPIRED 2 3 3200 1048576 128 EXPIRED 3 3 4992 1048576 128 EXPIRED 4 3 6528 1048576 128 EXPIRED 5 3 8192 1048576 128 EXPIRED 6 3 9600 1048576 128 EXPIRED 7 3 11136 1048576 128 EXPIRED 8 3 12800 1048576 128 EXPIRED 9 3 14208 1048576 128 EXPIRED 10 3 15744 1048576 128 EXPIRED 11 3 17408 1048576 128 EXPIRED 12 3 18688 1048576 128 EXPIRED 13 3 84864 8388608 1024 ACTIVE 14 3 178560 8388608 1024 EXPIRED sys@OCM> select * from v$rollstat; USN LATCH EXTENTS RSSIZE WRITES XACTS GETS WAITS OPTSIZE HWMSIZE SHRINKS WRAPS EXTENDSAVESHRINK AVEACTIVE STATUS CUREXT CURBLK---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- --------------- ---------- ---------- 0 0 6 385024 8112 0 93 0 385024 0 0 0 0 ONLINE 5 4 1 1 16 14802944 1172136 0 832 0 14802944 0 1 00 104857 ONLINE 15 45 2 2 5 3268608 930888 0 871 0 3268608 0 1 00 104857 ONLINE 3 53 3 0 17 2088960 1175554 0 948 0 2088960 0 16 140 123087 ONLINE 14 56 4 1 17 15851520 981912 0 779 0 15851520 0 1 00 104857 ONLINE 16 45 5 2 24 19259392 581992 0 688 0 19259392 0 1 00 104857 ONLINE 23 81 6 0 3 1171456 807088 0 810 0 1171456 0 1 00 104857 ONLINE 0 4 7 1 15 28434432 246082 1 361 0 28434432 0 0 0 0 ONLINE 13 108 8 2 5 3268608 843906 0 789 0 3268608 0 1 00 104857 ONLINE 4 95 9 0 12 10608640 725944 0 775 0 10608640 0 1 00 104857 ONLINE 3 75 10 1 5 2285568 800262 0 727 0 2285568 0 4 00 109093 ONLINE 2 83
********************************************************************************
Undo Segment: _SYSSMU7_4222772309$ (7)
********************************************************************************
Extent Control Header
-----------------------------------------------------------------
Extent Header:: spare1: 0 spare2: 0 #extents: 15 #blocks: 3471
last map 0x00000000 #maps: 0 offset: 4080
Highwater:: 0x00c14bec ext#: 13 blk#: 108 ext size: 1024
#blocks in seg. hdr's freelists: 0
#blocks below: 0
mapblk 0x00000000 offset: 13
Unlocked
Map Header:: next 0x00000000 #extents: 15 obj#: 0 flag: 0x40000000
Extent Map
-----------------------------------------------------------------
0x00c000e1 length: 7
0x00c00258 length: 8
0x00c00c80 length: 128
0x00c01380 length: 128
0x00c01980 length: 128
0x00c02000 length: 128
0x00c02580 length: 128
0x00c02b80 length: 128
0x00c03200 length: 128
0x00c03780 length: 128
0x00c03d80 length: 128
0x00c04400 length: 128
0x00c04900 length: 128
0x00c14b80 length: 1024
0x00c2b980 length: 1024
Retention Table
-----------------------------------------------------------
Extent Number:0 Commit Time: 1383361817
Extent Number:1 Commit Time: 1383361818
Extent Number:2 Commit Time: 1383361825
Extent Number:3 Commit Time: 1383361834
Extent Number:4 Commit Time: 1383361842
Extent Number:5 Commit Time: 1383361852
Extent Number:6 Commit Time: 1383361859
Extent Number:7 Commit Time: 1383361867
Extent Number:8 Commit Time: 1383361876
Extent Number:9 Commit Time: 1383361884
Extent Number:10 Commit Time: 1383361892
Extent Number:11 Commit Time: 1383362419
Extent Number:12 Commit Time: 1383369709
Extent Number:13 Commit Time: 1383369709
Extent Number:14 Commit Time: 1383361817
TRN CTL:: seq: 0x0496 chd: 0x0010 ctl: 0x001c inc: 0x00000000 nfb: 0x0000
mgc: 0xb000 xts: 0x0068 flg: 0x0001 opt: 2147483646 (0x7ffffffe)
uba: 0x00c14bec.0496.15 scn: 0x0000.00c6c607
Version: 0x01
FREE BLOCK POOL::
uba: 0x00000000.0496.14 ext: 0xd spc: 0x153a
uba: 0x00000000.0496.02 ext: 0xd spc: 0x1eee
uba: 0x00000000.0496.05 ext: 0xd spc: 0x1d20
uba: 0x00000000.0142.1f ext: 0x2 spc: 0x15f8
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 0x39a7 0x0005 0x0000.00c6c753 0x00c14beb 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x01 9 0x00 0x39a2 0x0016 0x0000.00c6c6e1 0x00c14beb 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x02 10 0x80 0x39a5 0x000d 0x0000.00c6c938 0x00c14bec 0x0000.000.00000000 0x00000001 0x00000000 0
0x03 9 0x00 0x39a5 0x000d 0x0000.00c6c80c 0x00c14bec 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x04 9 0x00 0x39a6 0x0015 0x0000.00c6c641 0x00c14be1 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x05 9 0x00 0x39a6 0x0012 0x0000.00c6c770 0x00c14beb 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x06 9 0x00 0x39a5 0x000e 0x0000.00c6c6b3 0x00c14beb 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x07 9 0x00 0x39a6 0x0000 0x0000.00c6c73d 0x00c14beb 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x08 9 0x00 0x39a6 0x0003 0x0000.00c6c7f2 0x00c14beb 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x09 9 0x00 0x39a3 0x0018 0x0000.00c6c7cd 0x00c14beb 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x0a 9 0x00 0x39a1 0x0007 0x0000.00c6c734 0x00c14beb 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x0b 9 0x00 0x39a6 0x0020 0x0000.00c6c879 0x00c14bec 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x0c 9 0x00 0x39a5 0x0009 0x0000.00c6c7c3 0x00c14beb 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x0d 9 0x00 0x39a5 0x001e 0x0000.00c6c824 0x00c14bec 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x0e 9 0x00 0x39a3 0x0001 0x0000.00c6c6c9 0x00c14beb 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x0f 9 0x00 0x39a6 0x000b 0x0000.00c6c860 0x00c14bec 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x10 9 0x00 0x39a5 0x001d 0x0000.00c6c619 0x00c14be1 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x11 9 0x00 0x39a5 0x001a 0x0000.00c6c680 0x00c14be1 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x12 9 0x00 0x39a3 0x0019 0x0000.00c6c787 0x00c14beb 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x13 9 0x00 0x39a5 0x0021 0x0000.00c6c8a9 0x00c14bec 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x14 9 0x00 0x39a4 0x0006 0x0000.00c6c6a0 0x00c14beb 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x15 9 0x00 0x39a4 0x001b 0x0000.00c6c65f 0x00c14be1 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x16 9 0x00 0x39a4 0x0017 0x0000.00c6c6f5 0x00c14beb 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x17 9 0x00 0x39a5 0x001f 0x0000.00c6c707 0x00c14beb 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x18 9 0x00 0x39a4 0x0008 0x0000.00c6c7e3 0x00c14beb 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x19 9 0x00 0x39a5 0x000c 0x0000.00c6c7aa 0x00c14beb 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x1a 9 0x00 0x39a3 0x0014 0x0000.00c6c690 0x00c14beb 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x1b 9 0x00 0x39a3 0x0011 0x0000.00c6c676 0x00c14be1 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x1c 9 0x00 0x39a4 0xffff 0x0000.00c6c917 0x00000000 0x0000.000.00000000 0x00000000 0x00000000 1383388137
0x1d 9 0x00 0x39a4 0x0004 0x0000.00c6c627 0x00c14be1 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x1e 9 0x00 0x39a5 0x000f 0x0000.00c6c841 0x00c14bec 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x1f 9 0x00 0x39a1 0x000a 0x0000.00c6c715 0x00c14beb 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x20 9 0x00 0x39a4 0x0013 0x0000.00c6c899 0x00c14bec 0x0000.000.00000000 0x00000001 0x00000000 1383387983
0x21 9 0x00 0x39a5 0x001c 0x0000.00c6c8dc 0x00c14bec 0x0000.000.00000000 0x00000001 0x00000000 1383388060
EXT TRN CTL::
usn: 7
sp1:0x00000000 sp2:0x00000000 sp3:0x00000000 sp4:0x00000000
sp5:0x00000000 sp6:0x7fff00000000 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
gyj@OCM> select dbms_rowid.rowid_relative_fno(rowid),dbms_rowid.rowid_block_number(rowid),id,name from gyj;
DBMS_ROWID.ROWID_RELATIVE_FNO(ROWID) DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID) ID NAME
------------------------------------ ------------------------------------ ---------- ----------
7 6495 1 EEEEE
sys@OCM> alter system dump datafile 7 block 6495;
Object id on Block? Y
seg/obj: 0x13344 csc: 0x00.c6c93d itc: 2 flg: E typ: 1 - DATA
brn: 0 bdba: 0x1c01958 ver: 0x01 opc: 0
inc: 0 exflg: 0
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0007.002.000039a5 0x00c14bec.0496.15 ---- 1 fsc 0x0000.00000000
0x02 0x0004.01a.000039be 0x00c2aafd.0433.04 C--- 0 scn 0x0000.00c6c938
bdba: 0x01c0195f
data_block_dump,data header at 0x2b035b568a64
===============
tsiz: 0x1f98
hsiz: 0x14
pbl: 0x2b035b568a64
76543210
flag=--------
ntab=1
nrow=1
frre=-1
fsbo=0x14
fseo=0x17bf
avsp=0x17ab
tosp=0x17ab
0xe:pti[0] nrow=1 offs=0
0x12:pri[0] offs=0x17bf
block_row_dump:
tab 0, row 0, @0x17bf
tl: 2009 fb: --H-FL-- lb: 0x1 cc: 2
col 0: [ 2] c1 02
col 1: [2000]
45 45 45 45 45 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
****************************************************************************************
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0007.002.000039a5 0x00c14bec.0496.15 ---- 1 fsc 0x0000.00000000
0x02 0x0004.01a.000039be 0x00c2aafd.0433.04 C--- 0 scn 0x0000.00c6c938
******************************************************************************************
Uba:0x00c14bec.0496.15==>3号文件，84972号块
sys@OCM> alter system dump datafile 3 block 84972;
UNDO BLK:
xid: 0x0007.002.000039a5 seq: 0x496 cnt: 0x15 irb: 0x15 icl: 0x0 flg: 0x0000
Rec Offset Rec Offset Rec Offset Rec Offset Rec Offset
---------------------------------------------------------------------------
0x01 0x1f60 0x02 0x1f00 0x03 0x1e50 0x04 0x1dd4 0x05 0x1d58
0x06 0x1cdc 0x07 0x1c70 0x08 0x1bc0 0x09 0x1b54 0x0a 0x1aa4
0x0b 0x19f4 0x0c 0x1988 0x0d 0x18d8 0x0e 0x185c 0x0f 0x17f0
0x10 0x1740 0x11 0x16b8 0x12 0x162c 0x13 0x15c4 0x14 0x1574
0x15 0x0ce8
*-----------------------------
* Rec #0x15 slt: 0x02 objn: 78660(0x00013344) objd: 78660 tblspc: 7(0x00000007)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00c14bec.0496.14 ctl max scn: 0x0000.00c6c5fb prv tx scn: 0x0000.00c6c607
txn start scn: scn: 0x0000.00c6c93a logon user: 90
prev brb: 12667873 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: L itl: xid: 0x0002.01d.00004c55 uba: 0x00c0035d.050b.28
flg: C--- lkc: 0 scn: 0x0000.00c6c92a
Array Update of 1 rows:
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 0
ncol: 2 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01c0195f hdba: 0x01c0195a
itli: 1 ispac: 0 maxfr: 4858
vect = 3
col 1: [2000]
44 44 44 44 44 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
*******************************************************************************************
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0007.002.000039a5 0x00c14bec.0496.15 ---- 1 fsc 0x0000.00000000
0x02 0x0004.01a.000039be 0x00c2aafd.0433.04 C--- 0 scn 0x0000.00c6c938
itl: xid: 0x0002.01d.00004c55 uba: 0x00c0035d.050b.28
flg: C--- lkc: 0 scn: 0x0000.00c6c92a
********************************************************************************************
Uba：0x00c2aafd.0433.04===》3号文件，174845号块
sys@OCM> alter system dump datafile 3 block 174845;
UNDO BLK:
xid: 0x0004.01a.000039be seq: 0x433 cnt: 0x4 irb: 0x4 icl: 0x0 flg: 0x0000
Rec Offset Rec Offset Rec Offset Rec Offset Rec Offset
---------------------------------------------------------------------------
0x01 0x1f1c 0x02 0x1e44 0x03 0x1d6c 0x04 0x14e0
*-----------------------------
* Rec #0x4 slt: 0x1a objn: 78660(0x00013344) objd: 78660 tblspc: 7(0x00000007)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00c2ae81.0434.37 ctl max scn: 0x0000.00c6c5f7 prv tx scn: 0x0000.00c6c5ff
txn start scn: scn: 0x0000.00c6c92a logon user: 90
prev brb: 12758656 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: L itl: xid: 0x0001.021.000039a0 uba: 0x00c2bd97.0267.01
flg: C--- lkc: 0 scn: 0x0000.00c6c924
Array Update of 1 rows:
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 0
ncol: 2 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01c0195f hdba: 0x01c0195a
itli: 2 ispac: 0 maxfr: 4858
vect = 3
col 1: [2000]
43 43 43 43 43 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
*******************************************************************************************
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0007.002.000039a5 0x00c14bec.0496.15 ---- 1 fsc 0x0000.00000000
0x02 0x0004.01a.000039be 0x00c2aafd.0433.04 C--- 0 scn 0x0000.00c6c938
itl: xid: 0x0002.01d.00004c55 uba: 0x00c0035d.050b.28
flg: C--- lkc: 0 scn: 0x0000.00c6c92a
itl: xid: 0x0001.021.000039a0 uba: 0x00c2bd97.0267.01
flg: C--- lkc: 0 scn: 0x0000.00c6c924
********************************************************************************************
uba: 0x00c0035d.050b.28 ===》3号文件，861号块
sys@OCM> alter system dump datafile 3 block 861;
UNDO BLK:
xid: 0x0002.003.00004c57 seq: 0x50b cnt: 0x29 irb: 0x29 icl: 0x0 flg: 0x0000
Rec Offset Rec Offset Rec Offset Rec Offset Rec Offset
---------------------------------------------------------------------------
0x01 0x1f38 0x02 0x1e88 0x03 0x1dd8 0x04 0x1d5c 0x05 0x1cf0
0x06 0x1c68 0x07 0x1c0c 0x08 0x1b84 0x09 0x1b28 0x0a 0x1a78
0x0b 0x1a0c 0x0c 0x195c 0x0d 0x18d4 0x0e 0x1874 0x0f 0x17ec
0x10 0x178c 0x11 0x1704 0x12 0x16a8 0x13 0x15f8 0x14 0x158c
0x15 0x1520 0x16 0x1470 0x17 0x13f4 0x18 0x1344 0x19 0x12d8
0x1a 0x1228 0x1b 0x11a0 0x1c 0x113c 0x1d 0x10c0 0x1e 0x100c
0x1f 0x0f9c 0x20 0x0f2c 0x21 0x0e7c 0x22 0x0e10 0x23 0x0d60
0x24 0x0cd0 0x25 0x0c64 0x26 0x0c14 0x27 0x0b58 0x28 0x02cc
0x29 0x0244
*-----------------------------
* Rec #0x28 slt: 0x1d objn: 78660(0x00013344) objd: 78660 tblspc: 7(0x00000007)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00c0035d.050b.26 ctl max scn: 0x0000.00c6c61f prv tx scn: 0x0000.00c6c63b
txn start scn: scn: 0x0000.00c6c924 logon user: 90
prev brb: 12583765 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x04 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: L itl: xid: 0x0009.01d.00004c91 uba: 0x00c02939.02d6.01
flg: C--- lkc: 0 scn: 0x0000.00c6c91b
Array Update of 1 rows:
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 0
ncol: 2 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01c0195f hdba: 0x01c0195a
itli: 1 ispac: 0 maxfr: 4858
vect = 3
col 1: [2000]
42 42 42 42 42 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
****************************************************************************************************************
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0007.002.000039a5 0x00c14bec.0496.15 ---- 1 fsc 0x0000.00000000 ......1
0x02 0x0004.01a.000039be 0x00c2aafd.0433.04 C--- 0 scn 0x0000.00c6c938 ......2
itl: xid: 0x0002.01d.00004c55 uba: 0x00c0035d.050b.28
flg: C--- lkc: 0 scn: 0x0000.00c6c92a ......3
itl: xid: 0x0001.021.000039a0 uba: 0x00c2bd97.0267.01
flg: C--- lkc: 0 scn: 0x0000.00c6c924 ......4
itl: xid: 0x0009.01d.00004c91 uba: 0x00c02939.02d6.01
flg: C--- lkc: 0 scn: 0x0000.00c6c91b
******************************************************************************************************************
uba: 0x00c2bd97.0267.01==》3号文件，179607号块
sys@OCM> alter system dump datafile 3 block 179607;
UNDO BLK:
xid: 0x0001.01c.0000399f seq: 0x267 cnt: 0x1e irb: 0x1e icl: 0x0 flg: 0x0000
Rec Offset Rec Offset Rec Offset Rec Offset Rec Offset
---------------------------------------------------------------------------
0x01 0x1774 0x02 0x16d8 0x03 0x1650 0x04 0x15c8 0x05 0x154c
0x06 0x14e4 0x07 0x145c 0x08 0x1344 0x09 0x12d0 0x0a 0x124c
0x0b 0x11e0 0x0c 0x117c 0x0d 0x1128 0x0e 0x10a4 0x0f 0x1028
0x10 0x0fac 0x11 0x0f38 0x12 0x0e9c 0x13 0x0d78 0x14 0x0d10
0x15 0x0cb8 0x16 0x0c64 0x17 0x0c08 0x18 0x0b94 0x19 0x0b38
0x1a 0x0ae4 0x1b 0x0a5c 0x1c 0x09e0 0x1d 0x0978 0x1e 0x08f0
*-----------------------------
* Rec #0x1 slt: 0x21 objn: 78660(0x00013344) objd: 78660 tblspc: 7(0x00000007)
* Layer: 11 (Row) opc: 1 rci 0x00
Undo type: Regular undo Begin trans Last buffer split: No
Temp Object: No
Tablespace Undo: No
rdba: 0x00000000Ext idx: 0
flg2: 0
*-----------------------------
uba: 0x00c2bd96.0267.3e ctl max scn: 0x0000.00c6c5f5 prv tx scn: 0x0000.00c6c5fc
txn start scn: scn: 0x0000.00c6c91b logon user: 90
prev brb: 12762517 prev bcl: 0
KDO undo record:
KTB Redo
op: 0x03 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: Z
Array Update of 1 rows:
tabn: 0 slot: 0(0x0) flag: 0x2c lock: 0 ckix: 0
ncol: 2 nnew: 1 size: 0
KDO Op code: 21 row dependencies Disabled
xtype: XAxtype KDO_KDOM2 flags: 0x00000080 bdba: 0x01c0195f hdba: 0x01c0195a
itli: 2 ispac: 0 maxfr: 4858
vect = 3
col 1: [2000]
41 41 41 41 41 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
gyj@OCM> select dump('AAAAA',16) from dual;
DUMP('AAAAA',16)
----------------------------
Typ=96 Len=5: 41,41,41,41,41
嘿嘿！手工终于找到了AAAAA了。
- 揭密一致性读------之UNDO一致性构造
- 揭密一致性读------之UNDO回滚链
- undo一致性读
- 探索undo一致性读
- 由读一致性分析undo
- undo系列学习之读一致性(ORA-01555错误机制分析)
- UNDO三大作用与一致性读机制浅析
- 一致性。
- 一致性
- Linux内核 文件一致性之主动一致性
- linux内核文件一致性之被动一致性
- Linux内核文件一致性之被动一致性
- oracle事务之oracle读一致性
- Oracle之数据库一致性读的原理
- oracle事务之oracle读一致性
- Oracle之数据库一致性读的原理
- Management之一致性
- 分布式初探之一致性
- java单例模式
- Configuring IPsec VPN with Kerio Control
- 【D3.js数据可视化系列教程】（十九）--交互图表之鼠标悬停
- Raucous Rockers
- oracle 11g ASM 的管理用户 asm shutdown immediate ORA-01031: insufficient privileges
- 揭密一致性读------之UNDO一致性构造
- 导航(1) 侧滑菜单导航 可替代AndroidSideMenu
- nyoj整数划分（二）
- SOAP
- web页面之弹出窗口
- windows7 64位 下配置mysql-5.5.25-winx64
- 跟踪G-Sensor有时不起作用的问题
- 总结篇 工作中犯过的错误（技术方面，工具方面）
- 关于mac环境下php代码无法解析的问题,特此记录!!!
