oracle redo opcode(一)

2014-11-24 15:58:20 · 作者: · 浏览: 0
oracle redo opcode
[sql] 
 Layer 1 : Transaction Control - KCOCOTCT       
  
Opcode 1 : KTZFMT   
  
Opcode 2 : KTZRDH   
  
Opcode 3 : KTZARC  
  
Opcode 4 : KTZREP  
  
       
  
    Layer 2 : Transaction Read -  KCOCOTRD       
  
       
  
    Layer 3 : Transaction Update -  KCOCOTUP       
  
       
  
    Layer 4 : Transaction Block -  KCOCOTBK     [ktbcts.h]  
  
         Opcode 1 : Block Cleanout   
  
         Opcode 2 : Physical Cleanout   
  
         Opcode 3 : Single Array Change  
  
         Opcode 4 : Multiple Changes to an Array  
  
         Opcode 5 : Format Block  
  
       
  
    Layer 5 : Transaction Undo -  KCOCOTUN     [ktucts.h]  
  
         Opcode 1 : Undo block or undo segment header - KTURDB  
  
         Opcode 2 : Update rollback segment header - KTURDH  
  
         Opcode 3 : Rollout a transaction begin   
  
         Opcode 4 : Commit transaction (transaction table update)   
  
- no undo record   
  
         Opcode 5 : Create rollback segment (format) - no undo record   
  
         Opcode 6 : Rollback record index in an undo block - KTUIRB  
  
         Opcode 7 : Begin transaction (transaction table update)   
  
         Opcode 8 : Mark transaction as dead   
  
         Opcode 9 : Undo routine to rollback the extend of a rollback segment   
  
         Opcode 10 :Redo to perform the rollback of extend of rollback segment   
  
                    to the segment header.   
  
         Opcode 11 :Rollback DBA in transaction table entry - KTUBRB   
  
         Opcode 12 :Change transaction state (in transaction table entry)   
  
         Opcode 13 :Convert rollback segment format (V6 -> V7)   
  
         Opcode 14 :Change extent allocation parameters in a rollback segment   
  
         Opcode 15 :  
  
         Opcode 16 :  
  
         Opcode 17 :  
  
         Opcode 18 :  
  
         Opcode 19 : Transaction start audit log record  
  
         Opcode 20 : Transaction continue audit log record       
  
         Opcode 24 : Kernel Transaction Undo Relog CHanGe - KTURLGU  
  
  
  
    Layer 6 : Control File -  KCOCODCF     [tbs.h]  
  
       
  
    Layer 10 : INDEX -  KCOCODIX     [kdi.h]  
 
Opcode 1 : load index block (Loader with direct mode) Opcode 2 : Insert leaf row Opcode 3 : Purge leaf row Opcode 4 : Mark leaf row deleted Opcode 5 : Restore leaf row (clear leaf delete flags) Opcode 6 : Lock index block Opcode 7 : Unlock index block Opcode 8 : Initialize new leaf block Opcode 9 : Apply Itl Redo Opcode 10 :Set leaf block next link Opcode 11 :Set leaf block previous link Opcode 12 :Init root block after split Opcode 13 :Make leaf block empty Opcode 14 :Restore block before image Opcode 15 :Branch block row insert Opcode 16 :Branch block row purge Opcode 17 :Initialize new branch block Opcode 18 :Update keydata in row Opcode 19 :Clear row's split flag Opcode 20 :Set row's split flag Opcode 21 :General undo above the cache (undo) Opcode 22 :Undo operation on leaf key above the cache (undo) Opcode 23 :Restore block to b-tree Opcode 24 :Shrink ITL (transaction entries) Opcode 25 :Format root block redo Opcode 26 :Undo of format root block (undo) Opcode 27 :Redo for undo of format root block Opcode 28 :Undo for migrating block Opcode 29 :Redo for migrating block Opcode 30 :IOT leaf block nonkey update Opcode 31 :Cirect load root redo Opcode 32 :Combine operation for insert and restore rows Layer 11 : Row Access - KCOCODRW [kdocts.h] Opcode 1 : Interpret Undo Record (Undo) Opcode 2 : Insert Row Piece Opcode 3 : Drop Row Piece Opcode 4 : Lock Row Piece Opcode 5 : Update Row Piece Opcode 6 : Overwrite Row Piece Opcode 7 : Manipulate First Column (add or delete the 1rst column) Opcode 8 : Change Forwarding address Opcode 9 : Change the Cluster Key Index Opcode 10 :Set Key Links (change the forwa