bbed提交事务系列十一

背景

  了解下bbed手工提交一个DML事务
结论
1,bbed修改的内容，有时会被冲掉，可能与未即时把缓冲内容写入到磁盘有关
2,bbed修改前后都要在会话1（当前形成事务的会话）进行强制刷新缓冲池操作
3,bbed修改ktbbh.ktbbhitl对数组编号下面的ktbitflg为00,即可以手工用BBED提交事务
4,kbbitflg对应itl中的lck

测试

会话1


SQL> create table t_bbed_tran(a int,b int);


Table created.


SQL> insert into t_bbed_tran values(8,8);


1 row created.


SQL> alter system flush buffer_cache;


System altered.






会话2


SQL> select * from t_bbed_tran;


no rows selected




bbed提交事务


SQL> select DBMS_ROWID.ROWID_RELATIVE_FNO(ROWID) file_no,DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID) block_no,dbms_rowid.rowid_row_number(rowid) record_no from t_bbed_tran;


   FILE_NO   BLOCK_NO  RECORD_NO
---------- ---------- ----------
         4     100399          0


BBED> p ktbbh.ktbbhitl[0]
struct ktbbhitl[0], 24 bytes                @44      
   struct ktbitxid, 8 bytes                 @44      
      ub2 kxidusn                           @44       0x012a
      ub2 kxidslt                           @46       0x001f
      ub4 kxidsqn                           @48       0x000014c0
   struct ktbituba, 8 bytes                 @52      
      ub4 kubadba                           @52       0x01c0057e
      ub2 kubaseq                           @56       0x04f2
      ub1 kubarec                           @58       0x06
   ub2 ktbitflg                             @60       0x0001 (NONE)  --要修改的结构体
   union _ktbitun, 2 bytes                  @62      
      sb2 _ktbitfsc                         @62       0
      ub2 _ktbitwrp                         @62       0x0000
   ub4 ktbitbas                             @64       0x00000000


BBED> m /x 00 offset 60
Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y 
 File: /oracle/oradata/guowang/users01.dbf (4)
 Block: 100399           Offsets:   60 to  571           Dba:0x0101882f
------------------------------------------------------------------------
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00010100 ffff1400 8f1f7b1f 7b1f0000 01008f1f 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 


 <32 bytes per line>




BBED> sum apply
Check value for File 4, Block 100399:
current = 0xd4fa, required = 0xd4fa


会话1
强制刷新缓冲池，把BBED修改的内容写入到磁盘中，便于在会话2看到这个最新修改的内容
alter system flush buffer_cache;


会话2
即可查看到用BBED手工提交的事务
SQL> select * from t_bbed_tran;


         A          B
---------- ----------
         8          8




继续测试，如果重启数据库，用BBED手工提交的事务，还存在吗？可见用BBED手工提交的事务，事务不会丢失
SQL> conn scott/system
Connected.
SQL> select * from t_bbed_tran;


         A          B
---------- ----------
         8          8

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9240380/viewspace-1821173/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9240380/viewspace-1821173/