揭密一致性读------之UNDO回滚链

出处: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.


  1. gyj@OCM> select * from v$transaction;  
  2.   
  3.   
  4. 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  
  5. ---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------------- -------------------- ---------- ---------- ---------- ------------ ------------ ------------ ------------ ---------------- ---------- --- --- --- --- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ------------ ---------- ---------- ---------- ------------- ---------------- ---------------- ----------------  
  6. 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 0000000000000000  
  7.   
  8.   
  9. sys@OCM> select * from X$KTUXE where  KTUXESTA='ACTIVE';  
  10.   
  11.   
  12. ADDR                   INDX    INST_ID   KTUXEUSN   KTUXESLT   KTUXESQN  KTUXERDBF  KTUXERDBB  KTUXESCNB  KTUXESCNW KTUXESTA         KTUXECFL KTUXEUEL  KTUXEDDBF  KTUXEDDBB   KTUXEPUSN  KTUXEPSLT  KTUXEPSQN   KTUXESIZ  
  13. ---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------------- ------------------------ ---------- ---------- ---------- ---------- ---------- ---------- ----------  
  14. 00002AC148607908        304          1          7          2      14757          3      84972   13027640          0 ACTIVE           NONE           13   0          0          0          0          0          1  
  15.   
  16.   
  17. sys@OCM> select header_file,header_block from dba_segments where segment_name='_SYSSMU7_4222772309$';  
  18.   
  19.   
  20. HEADER_FILE HEADER_BLOCK  
  21. ----------- ------------  
  22.           3          224  
  23.   
  24.   
  25. sys@OCM> select EXTENT_ID,FILE_ID, BLOCK_ID,BYTES,BLOCKS,STATUS from dba_undo_extents where segment_name='_SYSSMU7_4222772309$';  
  26.   
  27.   
  28.  EXTENT_ID    FILE_ID   BLOCK_ID      BYTES     BLOCKS STATUS  
  29. ---------- ---------- ---------- ---------- ---------- ---------  
  30.          0          3        224      65536          8 EXPIRED  
  31.          1          3        600      65536          8 EXPIRED  
  32.          2          3       3200    1048576        128 EXPIRED  
  33.          3          3       4992    1048576        128 EXPIRED  
  34.          4          3       6528    1048576        128 EXPIRED  
  35.          5          3       8192    1048576        128 EXPIRED  
  36.          6          3       9600    1048576        128 EXPIRED  
  37.          7          3      11136    1048576        128 EXPIRED  
  38.          8          3      12800    1048576        128 EXPIRED  
  39.          9          3      14208    1048576        128 EXPIRED  
  40.         10          3      15744    1048576        128 EXPIRED  
  41.         11          3      17408    1048576        128 EXPIRED  
  42.         12          3      18688    1048576        128 EXPIRED  
  43.         13          3      84864    8388608       1024 ACTIVE  
  44.         14          3     178560    8388608       1024 EXPIRED  
  45.    
  46.  sys@OCM> select * from v$rollstat;  
  47.   
  48.   
  49.        USN      LATCH    EXTENTS     RSSIZE     WRITES      XACTS       GETS      WAITS    OPTSIZE    HWMSIZE    SHRINKS      WRAPS    EXTENDSAVESHRINK  AVEACTIVE STATUS               CUREXT     CURBLK  
  50. ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- --------------- ---------- ----------  
  51.          0          0          6     385024       8112          0         93          0                385024          0          0          0   0 ONLINE                    5          4  
  52.          1          1         16   14802944    1172136          0        832          0              14802944          0          1          00     104857 ONLINE                   15         45  
  53.          2          2          5    3268608     930888          0        871          0               3268608          0          1          00     104857 ONLINE                    3         53  
  54.          3          0         17    2088960    1175554          0        948          0               2088960          0         16         140     123087 ONLINE                   14         56  
  55.          4          1         17   15851520     981912          0        779          0              15851520          0          1          00     104857 ONLINE                   16         45  
  56.          5          2         24   19259392     581992          0        688          0              19259392          0          1          00     104857 ONLINE                   23         81  
  57.          6          0          3    1171456     807088          0        810          0               1171456          0          1          00     104857 ONLINE                    0          4  
  58.          7          1         15   28434432     246082          1        361          0              28434432          0          0          0   0 ONLINE                   13        108  
  59.          8          2          5    3268608     843906          0        789          0               3268608          0          1          00     104857 ONLINE                    4         95  
  60.          9          0         12   10608640     725944          0        775          0              10608640          0          1          00     104857 ONLINE                    3         75  
  61.         10          1          5    2285568     800262          0        727          0               2285568          0          4          00     109093 ONLINE                    2         83         
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 0000000000000000


sys@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          1


sys@OCM> select header_file,header_block from dba_segments where segment_name='_SYSSMU7_4222772309$';


HEADER_FILE HEADER_BLOCK
----------- ------------
          3          224


sys@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了。 
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值