REDO Opcode参考

redo dump中的opcode的含义:

Layer and corresponding Operation codes description :
===================================================
Layer 1 : Transaction Control - KCOCOTCT
Opcode 1 : KTZ ForMaT block - KTZFMT
Opcode 2 : Transaction Z Redo Data Header - KTZRDH
Opcode 3 : KTZ Allocate Record Callback - KTZARC
Opcode 4 : KTZ REPlace record value - KTZREP
Opcode 5 : KTZ Undo for RePlace - KTZURP
Layer 2 : Transaction Read - KCOCOTRD
Layer 3 : Transaction Update - KCOCOTUP
Layer 4 : Transaction Block - KCOCOTBK [ktbcts.h]
Opcode 1 : Block cleanout opcode - KTBOPCLN
Opcode 2 : physical cleanout opcode - KTBPHCLN
Opcode 3 : single array change - KTBSARC
Opcode 4 : Multiple changes to an array - KTBMARC
Opcode 5 : format block - KTBOPFMB
Opcode 6 : commit-time block cleanout opcode - KTBOPBCC
Opcode 7 : ITL cleanout callback - KTBOPCLNL
Opcode 8 : Transaction Block Redo Block Commit Cleanout - KTBOPBCCL
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 - KTURBG
Opcode 4 : Commit transaction (transaction table update) - KTURCM
- no undo record
Opcode 5 : Create rollback segment (format) - no undo record - KTUFMT
Opcode 6 : Rollback record index in an undo block - KTUIRB
Opcode 7 : Begin transaction (transaction table update) - KTUUBG
Opcode 8 : Mark transaction as dead - KTURMR
Opcode 9 : Undo routine to rollback the extend of a rollback segment - KTUUAE
Opcode 10 : Redo to perform the rollback of extend of rollback segment - KTUREH
to the segment header.
Opcode 11 : Rollback DBA in transaction table entry - KTUBRB
Opcode 12 : Change transaction state (in transaction table entry) - KTURST
Opcode 13 : Convert rollback segment format (V6 -> V7) - KTURCT
Opcode 14 : Change extent allocation parameters in a rollback segment - KTURUC
Opcode 15 : Undo Redo ConverT transaction table - KTURCTS
Opcode 16 : KTU - Redo for ConverT to Unlimited extents format - KTURCTU
Opcode 17 : KTU Redo - Convert for extent Move in extent map in - KTURCTM
unlimited format to segment header
Opcode 18 : Transaction Undo segment Redo set Parent Xid - KTURPX
Opcode 19 : Transaction start audit log record - KTUTSL
Opcode 20 : Transaction continue audit log record - KTUTSC
Opcode 21 : Transaction Control Redo ConverT undo seg Down to 8.0 format- KTURCVD
Opcode 22 : Transaction Redo - PHysical Changes - KTURPHC
Opcode 23 : Disable Block level Recovery - KTURDBR
Opcode 24 : Kernel Transaction Undo Relog CHanGe - KTURLGU
Opcode 25 : Join sub Transaction - KTURJT
Opcode 26 : Undo STopper undo callback - KTUUST
Opcode 27 : Transaction Control System Managed us Format - KTUSMFMT
Opcode 28 : Undo Need To Propagate - KTUUNTP  askmaclean.com
Opcode 29 : big undo - KTUBDB
Opcode 30 : change ondisk state for a distributed transaction - KTURCDTS
Opcode 31 : Flashback Archive Txn Table Redo Callback - KTUFATTRC
Opcode 32 : Flashback Archive Txn Table Redo Set - KTUFATTRS
Opcode 33 : change notification commit marker - KTUCHNF
Opcode 34 : NTP bit for change notfn - KTUQCNTTRC
Opcode 35 : Flashback Archive Collect Txn Table Redo Set - KTUFACTTRS
Layer 6 : Control File - KCOCODCF [tbs.h]
Opcode 1 : TaBleSpace Remove DataFile - TBSCRDF
Opcode 2 : TaBleSpace Add DataFile - TBSCADF
Opcode 3 : TaBleSpace OFfLine - TBSCOFL
Opcode 4 : TaBleSpace ONLine - TBSCONL
QREF: REDO Opcode - Quick Reference (Doc ID 29733.1) To Bottom
Modified: 01-May-2013 Type: REFERENCE Status: PUBLISHED [ INTERNAL ] Priority: 3 (7)
Knowledge Authoring HealthPlan KM Reports Keyword Dictionary RCA Search Knowledge Base (Beta) Advanced
Opcode 4 : TaBleSpace ONLine - TBSCONL
Opcode 5 : TaBleSpace ReaD-Write - TBSCRDW
Opcode 6 : TaBleSpace ReaD-Only - TBSCRDO
Opcode 7 : TaBleSpace Remove TableSpace - TBSCRTS
Opcode 8 : TaBleSpace Add TableSpace - TBSCATS
Opcode 9 : TaBleSpace Undo TsPitr - TBSCUTP
Opcode 10 : TaBleSpace undo plugged datafile convert - TBSCUCV
Opcode 11 : Tablespace Undo Rename - TBSCREN
Layer 10 : INDEX - KCOCODIX [kdi.h]
Opcode 1 : load index block (Loader with direct mode) - KDICPDO
Opcode 2 : Insert leaf row - KDICLIN
Opcode 3 : Purge leaf row - KDICLPU
Opcode 4 : Mark leaf row deleted - KDICLDE
Opcode 5 : Restore leaf row (clear leaf delete flags) - KDICLRE
Opcode 6 : Lock index block - KDICLOK
Opcode 7 : Unlock index block - KDICULO
Opcode 8 : Initialize new leaf block - KDICLNE
Opcode 9 : Apply Itl Redo - KDICAIR
Opcode 10 :Set leaf block next link - KDICLNX
Opcode 11 :Set leaf block previous link - KDICLPR
Opcode 12 :Init root block after split - KDICRSP
Opcode 13 :Make leaf block empty - KDICLEM
Opcode 14 :Restore block before image - KDICIMA
Opcode 15 :Branch block row insert - KDICBIN
Opcode 16 :Branch block row purge - KDICBPU
Opcode 17 :Initialize new branch block - KDICBNE
Opcode 18 :Update keydata in row - KDICLUP
Opcode 19 :Clear row's split flag - KDICLCL
Opcode 20 :Set row's split flag - KDICLSE
Opcode 21 :General undo above the cache (undo) - KDICUGE
Opcode 22 :Undo operation on leaf key above the cache (undo) - KDICULK
Opcode 23 :Restore block to b-tree - KDICREB
Opcode 24 :Shrink ITL (transaction entries) - KDICSIT
Opcode 25 :Format root block redo - KDICFRB
Opcode 26 :Undo of format root block (undo) - KDICUFB
Opcode 27 :Redo for undo of format root block - KDICUFR
Opcode 28 :Undo for migrating block - KDICUMG
Opcode 29 :Redo for migrating block - KDICMG
Opcode 30 :IOT leaf block nonkey update - KDICLNU
Opcode 31 :Direct load root redo - KDICDLR
Opcode 32 :Combine operation for insert and restore rows - KDICCOM
Opcode 33 : Temp index redo apply - KDICTIX  askmaclean.com
Opcode 34 : Remove block from b-tree and empty block - KDICFRE
Opcode 35 : - KDICLCU
Opcode 36 : Supplemental logging - KDICLMN
Opcode 37 : Undo of non-key updates - KDICULN
Opcode 38 : Logical non-key update - KDICICU
Opcode 39 : Branch update range - KDICBUR
Opcode 40 : Branch DBA update - KDICBDU
Layer 11 : Row Access - KCOCODRW [kdocts.h]
Opcode 1 : Interpret Undo Record (Undo) - KDOIUR
Opcode 2 : Insert Row Piece - KDOIRP
Opcode 3 : Drop Row Piece - KDODRP
Opcode 4 : Lock Row Piece - KDOLKR
Opcode 5 : Update Row Piece - KDOURP
Opcode 6 : Overwrite Row Piece - KDOORP
Opcode 7 : Manipulate First Column (add or delete the 1st column) - KDOMFC
Opcode 8 : Change Forwarding address - KDOCFA
Opcode 9 : Change the Cluster Key Index - KDOCKI
Opcode 10 : Set Key Links- KDOSKL
Change the forward & backward key links on a cluster key
Opcode 11 : Quick Multi-Insert (ex: insert as select ...) - KDOQMI
Opcode 12 : Quick Multi-Delete - KDOQMD
Opcode 13 : Toggle Block Header flags - KDOTBF
Opcode 14 : KDODSC
Opcode 15 : KDOMBC
Opcode 16 : Logminer support - RM for rowpiece with only logminer columns - KDOLMN
Opcode 17 : Logminer support - RM for LOB id key information - KDOLLB
Opcode 18 : Logminer support - RM for LOB operation errors - KDOLBE
Opcode 19 : Logminer support - array updates - KDOURA
Opcode 20 : Logminer support - KDOSHK
Opcode 21 : Logminer support - KDOURP2
Opcode 22 : Logminer support - KDOCMP
Opcode 23 : Logminer support - KDODCU
Opcode 24 : Logminer support - KDOMRK
Opcode 25 : Logminer support - KDOAIR
Layer 12 : Cluster - KCOCODCL [?]
Layer 13 : Transaction Segment - KCOCOTSG [ktscts.h]
Opcode 1 : Data Segment Format - KTSDSF
Opcode 2 : format free list block - KTSFFB
Opcode 3 : redo for convert to unlimited extents format - KTSRCTU
Opcode 4 : fix segment header by moving its extent to ext 0 - KTSRFSH
Opcode 5 : format data block - KTSFRBFMT
Opcode 6 : set link value on block - KTSFRBLNK
Opcode 7 : freelist related fgroup/segheader redo - KTSFRGRP
Opcode 8 : freelist related fgroup/segheader undo - KTSFUGRP
Opcode 9 : undo for linking block to xnt freelist - KTSFUNLK
Opcode 10 : BITMAP - format segment header - KTSBSFO
Opcode 11 : BITMAP - format bitmap block - KTSBBFO
Opcode 12 : BITMAP - format bitmap index block - KTSBIFO
Opcode 12 : BITMAP - format bitmap index block - KTSBIFO
Opcode 13 : BITMAP - redo for bmb - KTSBBREDO
Opcode 14 : BITMAP - undo for BMB - KTSBBUNDO
Opcode 15 : BITMAP - redo for index map - KTSBIREDO
Opcode 16 : BITMAP - undo for index map - KTSBIUNDO
Opcode 17 : Bitmap Seg - format segment Header - KTSPHFO
Opcode 18 : Bitmap Seg - format First level bitmap block - KTSPFFO
Opcode 19 : Bitmap Seg - format Second level bitmap block - KTSPSFO
Opcode 20 : Bitmap Seg - format Third level bitmap block - KTSPTFO
Opcode 21 : Bitmap Seg - format data block - KTSPBFO
Opcode 22 : Bitmap Seg - Redo for L1 bmb - KTSPFREDO
Opcode 23 : Bitmap Seg - Undo for L1 BMB - KTSPFUNDO
Opcode 24 : Bitmap Seg - Redo for L2 bmb - KTSPSREDO
Opcode 25 : Bitmap Seg - Undo for L2 BMB - KTSPSUNDO
Opcode 26 : Bitmap Seg - Redo for L3 bmb - KTSPTREDO
Opcode 27 : Bitmap Seg - Undo for L3 BMB - KTSPTUNDO
Opcode 28 : Bitmap Seg - Redo for pagetable segment header block - KTSPHREDO
Opcode 29 : Bitmap Seg - Undo for pagetable segment header block - KTSPHUNDO
Opcode 30 : Bitmap Seg - format L1 BMB for LOB segments - KTSPLBFFO
Opcode 31 : Bitmap Seg - Shrink redo for L1 - KTSKFREDO
Opcode 32 : Bitmap Seg - Shrink redo for segment header - KTSKHREDO
Opcode 33 : Bitmap Seg - Shrink redo for extent map blk - KTSKEREDO
Opcode 34 : Bitmap Seg - Shrink undo for segment header - KTSKHUNDO
Opcode 35 : Bitmap Seg - Shrink undo for L1 - KTSKFUNDO
Opcode 36 : Bitmap Seg shrink related - KTSKSREDO
Opcode 37 : Bitmap Seg shrink related - KTSKSUNDO
Opcode 38 : Bitmap Seg shrink related - KTSKTREDO
Opcode 39 : Bitmap Seg shrink related - KTSKTUNDO
Opcode 40 : Bitmap Seg - Shrink redo for extent map blk - KTSKEUNDO
Opcode 41 : NGLOB format opcode Extent Header - KTSLEFREDO
Opcode 42 : NGLOB format opcode Persistent Undo - KTSLPFREDO
Opcode 43 : NGLOB format opcode Hash bucket - KTSLHFREDO
Opcode 44 : NGLOB format opcode Free SPace - KTSLFFREDO
Opcode 45 : NGLOB format opcode Segment Header - KTSLSFREDO
Opcode 46 : NGLOB format opcode data block - KTSLBFREDO
Opcode 47 : NGLOB block update Extent Header redo - KTSLEUREDO
Opcode 48 : NGLOB block update Extent Header undo - KTSLEUUNDO
Opcode 49 : NGLOB block update Hash Bucket redo - KTSLHUREDO
Opcode 50 : NGLOB block update Hash Bucket undo - KTSLHUUNDO
Opcode 51 : NGLOB block update Free Space redo - KTSLFUREDO
Opcode 52 : NGLOB block update Free Space undo - KTSLFUUNDO
Opcode 53 : NGLOB block update Persistent Undo redo - KTSLPUREDO
Opcode 54 : NGLOB block update Persistent Undo undo - KTSLPUUNDO
Opcode 55 : NGLOB block update Segment Header redo - KTSLSUREDO
Opcode 56 : NGLOB block update Segment Header undo - KTSLSUUNDO
Layer 14 : Transaction Extent - KCOCOTEX [kte.h]
Opcode 1 : Unlock Segment Header - KTECUSH
Opcode 2 : Redo set extent map disk LocK - KTECRLK
Opcode 3 : redo for conversion to unlimited format - KTEFRCU
Opcode 4 : extent operation redo - KTEOPEMREDO
Opcode 5 : extent operation undo - KTEOPEUNDO
Opcode 6 : extent map format redo - KTEOPEFREDO
Opcode 7 : redo - KTECNV
Opcode 8 : undo for truncate ops, flush the object - KTEOPUTRN
Opcode 9 : undo for reformat of a ctl block - KTEFUCTL
Opcode 10 : redo to facilitate above undo - KTEFRCTL
Opcode 11 : redo to clean xids in seghdr/fgb - KTECRCLN
Opcode 12 : SMU-Retention: Redo to propagate extent commit time - KTEOPRPECT
Layer 15 : Table Space - KCOCOTTS [ktt.h]
Opcode 1 : format save undo header - KTTFSU
Opcode 2 : add save undo record - KTTSUN
Opcode 3 : move to next block - KTTNBK
Opcode 4 : point to next save undo record - KTTNAS
Opcode 5 : update saveundo blk during save undo application - KTTUSB
Layer 16 : Row Cache - KCOCOQRC
Layer 17 : Recovery (REDO) - KCOCORCV [kcv.h]
Opcode 1 : End Hot Backup - KCVOPEHB
This operation clears the hot backup
in-progress flags in the indicated list of files
Opcode 2 : ENable Thread - KCVOPENT
This operation creates a redo record
signalling that a thread has been enabled
Opcode 3 : Crash Recovery Marker - KCVOPCRM
Opcode 4 : ReSiZeable datafiles - KCVOPRSZ
Opcode 5 : tablespace ONline - KCVOPONL
Opcode 6 : tablespace OFFline - KCVOPOFF
Opcode 7 : tablespace ReaD Write - KCVOPRDW
Opcode 8 : tablespace ReaD Only - KCVOPRDO
Opcode 9 : ADDing datafiles to database - KCVOPADD
Opcode 10 : tablespace DRoP - KCVOPDRP
Opcode 11 : Tablespace PitR - KCVOPTPR
Opcode 12 : PLUgging datafiles to database - KCVOPPLG_PRE10GR2
Opcode 13 : convert plugged in datafiles - KCVOPCNV
Opcode 14 : ADding dataFiles to database - KCVOPADF_PRE10GR2
Opcode 15 : heart-beat redo - KCVOPHBR
Opcode 16 : tablespace rename - KCVOPTRN
Opcode 17 : ENable Thread - KCVOPENT_10GR2
Opcode 18 : tablespace ONline - KCVOPONL_10GR2
Opcode 19 : tablespace OFFline - KCVOPOFF_10GR2
Opcode 20 : tablespace ReaD Write - KCVOPRDW_10GR2
Opcode 21 : tablespace ReaD Only - KCVOPRDO_10GR2
Opcode 22 : PLUgging datafiles to db - KCVOPPLG_10GR2
Opcode 23 : ADding dataFiles to database - KCVOPADF_10GR2
Opcode 24 : convert plugged in datafiles - KCVOPCNV_10GR2
Opcode 25 : Tablespace PitR - KCVOPTPR_10GR2
Opcode 26 : for file drop in tablespace - KCVOPFDP
Opcode 27 : for internal thread enable - KCVOPIEN
Opcode 28 : readable standby metadata flush - KCVOPMFL
Opcode 29 : database key creation (after bumping compatible to 11g) - KCVOPDBK
Opcode 30 : ADding dataFiles to database - KCVOPADF
Opcode 31 : PLUgging datafiles to db - KCVOPPLG
Opcode 32 : for modifying space header info - KCVOPSPHUPD
Opcode 33 : TSE Masterkey Rekey - KCVOPTMR
Layer 18 : Hot Backup Log Blocks - KCOCOHLB [kcb.h] / [kcb2.h]
Opcode 1 : Log block image - KCBKCOLB
Opcode 2 : Recovery testing - KCBKCORV
Opcode 3 : Object/Range reuse - KCBKCOREU
Layer 19 : Direct Loader Log Blocks - KCOCODLB [kcbl.h]
Opcode 1 : Direct block logging - KCBLCOLB
Opcode 2 : Invalidate range - KCBLCOIR
Opcode 3 : Direct block relogging - KCBLCRLB
Opcode 4 : Invalidate range relogging - KCBLCRIR
Layer 20 : Compatibility Segment operations - KCOCOKCK [kck.h]
Opcode 1 : Format compatibility segment - KCKFCS
Opcode 2 : Update compatibility segment - KCKUCS
Opcode 3 : Update Root Dba in controlfile and file header 1 - KCKURD
Opcode 4 : Set bit in a SQL Tuning Existence Bit Vector - KCK_INV_SQL_SIG
Opcode 5 : Invalidate an SQL Statement by Signature - KCK_INV_SQL_SIG
Opcode 6 : Unauthorize cursors after sys privilege revoke - KCK_UNAUTH_CUR
Layer 21 : LOB segment operations - KCOCOLFS [kdl2.h]
Opcode 1 : Write data into ILOB data block - KDLOPWRI
Layer 22 : Tablespace bitmapped file operations - KCOCOTBF [ktfb.h]
Opcode 1 : format space header - KTFBHFO
Opcode 2 : space header generic redo - KTFBHREDO
Opcode 3 : space header undo - KTFBHUNDO
Opcode 4 : space bitmap block format - KTFBBFO
Opcode 5 : bitmap block generic redo - KTFBBREDO
Layer 23 : write behind logging of blocks - KCOCOLWR [kcbb.h]
Opcode 1 : Dummy block written callback - KCBBLWR
Opcode 2 : log reads - KCBBLRD
Opcode 3 : log DirectWrites - KCBBLDWR
Layer 24 : Logminer related (DDL or OBJV# redo) - KCOCOKRV [krv0.h]
Opcode 1 : common portion of the ddl - KRVDDL
Opcode 2 : direct load redo - KRVDLR
Opcode 3 : lob related info - KRVLOB
Opcode 4 : misc info - KRVMISC
Opcode 5 : user info - KRVUSER
Opcode 6 : direct load redo 10i - KRVDLR10
Opcode 7 : logminer undo opcode - KRVUOP
Opcode 8 : xmlredo - doc or dif - opcode - KRVXML
Opcode 9 : PL/SQL redo - KRVPLSQL
Opcode 10 : Uniform Redo Unchained - KRVURU
Opcode 11 : txn commit marker - KRVCMT
Opcode 12 : supplog marker - KRVCFF
Layer 25 : Queue Related - KCOCOQUE [kdqs.h]
Opcode 1 : undo - KDQSUN
Opcode 2 : init - KDQSIN
Opcode 3 : enqueue - KDQSEN
Opcode 4 : update - KDQSUP
Opcode 5 : delete - KDQSDL
Opcode 6 : lock - KDQSLK
Opcode 7 : min/max - KDQSMM
Layer 26 : Local LOB Related - KCOCOLOB [kdli3.h]
Opcode 1 : generic lob undo - KDLIRUNDO
Opcode 2 : generic lob redo - KDLIRREDO
Opcode 3 : lob block format redo - KDLIRFRMT
Opcode 4 : lob invalidation redo - KDLIRINVL
Opcode 5 : lob cache-load redo - KDLIRLOAD
Opcode 6 : direct lob direct-load redo - KDLIRBIMG
Opcode 7 : dummy calibration redo - KDLIRCALI
Layer 27 : Block Change Tracking - KCOCOBCT [krc2.h]
Opcode 1 : op-code for bitmap switch - KRCPBSW
-------------------------------------------------------

 

关注刘相兵的新浪微博

扫码加入微信Oracle小密圈,了解Oracle最新技术下载分享资源

Trackbacks

  1. […] didn’t take long for someone to email me a much longer list that has been published elsewhere on the Internet. The results don’t have the hierarchical style display I have above, so I may copy the extra […]

Speak Your Mind

沪公网安备 31010802001379号

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569