OP Codes Reference

信息

This posting was prompted by a tweet from Kamil Stawiarski in response to a question about how he’d discovered the meaning of Redo Op Codes 5.1 and 11.6 – and credited me and Julian Dyke with “the hardest part”.

Over the years I’ve accumulated (from Julian Dyke, or odd MoS notes, etc.) and let dribble out the occasional interpretation of a few op codes – typically in response to a question on the OTN database forum or the Oracle-L listserver, and sometimes as a throwaway comment in a blog post, but I’ve never published the full set of codes that I’ve acquired (or guessed) to date.

It’s been some time since I’ve looked closely at a redo stream, and there are many features of Oracle that I’ve never had to look at at the level of the redo so there are plenty of gaps in the list – and maybe a few people will use the comments to help fill the gaps.

It’s possible that I may be able to add more op codes over the new days – I know that somewhere I have some op codes relating to space management, and a batch relating to LOB handling, but it looks like I forgot to add them to the master list – so here’s what I can offer so far:

1. Transaction Control

2. Transaction read

3. Transaction update

4. Block cleanout

4.1 Block cleanout record
4.2 Physical cleanout
4.3 Single array change
4.4 Multiple array changes
4.5 Format block
4.6 ktbcc redo -  Commit Time Block Cleanout Change

5 Transaction undo management

5.1 Update undo block
5.2 Get undo header
5.3 Rollout a transaction begin
5.4 On a rollback or commit
5.5 Create rollback segmenr
5.6 On a rollback of an insert
5.7 Restore transaction table slot.
    In the ktubl for 'dbms_transaction.local_transaction_id'
    (begin transaction) - also arrives for incoming distributed
    tx, no data change but TT slot acquired. Also for recursive
    transaction (e.g. truncate). txn start scn:  0xffff.ffffffff
    Also prior to securefile LOB insertion.
5.8 Mark transaction as dead
5.9 Rollback extension of rollback seg
5.10    Rollback segment header change for extension of rollback seg
5.11    Mark undo as applied during rollback
5.19    Transaction audit record - first
5.20    Transaction audit record - subsequent
5.23    ktudbr redo: disable block level recovery (reports XID)
5.24    ktfbhundo - File Space Header Undo

• 5.6 and 5.11 – used with rollback; each row of an object get’s its own rollback record with partial XID information (XIDSLT and XIDSQN)
• 5.4 I’ve noticed, that it’s used only for COMMIT in 12.1 (but of course rollback is like applying reverse operations and then – commiting them ;)) Funny thing is, that there is no direct XID number in this change vector – you have to calculate it from CLS (next byte after opcode), which will give you XIDUSN = (u_short) ((cls-17)/2+1), XIDSLT (30 bytes from opcode is an array_size byte and you have to jump 30+array_size to get it – sometimes also +2 if the array_size is not even) and XIDSQN, which is 4 bytes from XIDSLT. All together gives the XID of the committed transaction.

6. Control file

10. Index

10.1    SQL load index block
10.2    Insert Leaf Row
10.3    Purge Leaf Row
10.4    Delete Leaf Row
10.5    Restore Leaf during rollback
10.6    (kdxlok) Lock block (pre-split)
10.7    (kdxulo) unlock block during undo
10.8    (kdxlne) initialize leaf block being split
10.9    (kdxair) apply XAT do to ITL 1  -- (service ITL) related to leaf block split
10.10   Set leaf block next pointer
10.11   (kdxlpr) (UNDO) set kdxleprv (previous pointer)
10.12   Initialize root block after split
10.13   index redo (kdxlem): (REDO) make leaf block empty,
10.14   Restore block before image
10.15   (kdxbin) Insert branch block row
10.16   Purge branch row
10.17   Initialize new branch block
10.18   Update key data in row -- index redo (kdxlup): update keydata
10.19   Clear split flag
10.20   Set split flag
10.21   index general undo (branch) operations
10.22   Undo leaf operation
10.23   restore block to tree
10.24   Shrink ITL
10.25   format root block
10.26   format root block (undo)
10.27   format root block (redo)
10.28   Migrating block (undo)
10.29   Migrating block (redo)
10.30   Update nonkey value
10.31   index root block redo (kdxdlr):  create/load index
10.34   make branch block empty
10.35   index redo (kdxlcnu): update nonkey
10.37   undo index change (kdxIndexlogicalNonkeyUpdate) -- bitmap index
10.38   index change (kdxIndexlogicalNonkeyUpdate) -- bitmap index
10.39   index redo (kdxbur) :  branch block update range
10.40   index redo (kdxbdu) :  branch block DBA update,

11. Table

11.1  undo row operation
11.2  insert row  piece
11.3  delete row piece
11.4  lock row piece
11.5  update row piece
11.6  overwrite row piece
11.7  manipulate first column
11.8  change forwarding address - migration
11.9  change cluster key index
11.10 Set Cluster key pointers
11.11 Insert multiple rows
11.12 Delete multiple rows
11.13 toggle block header flags
11.17 Update multiple rows
11.19 Array update ?
11.20 SHK (mark as shrunk?)
11.24 HCC update rowid map ?

12. Cluster

13. Segment management

13.1    ktsfm redo: -- allocate space ??
13.5    KTSFRBFMT (block format) redo
13.6    (block link modify) (? index )  (options: lock clear, lock set)
13.7    KTSFRGRP (fgb/shdr modify freelist) redo: (options unlink block, move HWM)
13.13   ktsbbu undo - undo operation on bitmap block
13.14   ktsbbu undo - undo operation on bitmap block
13.17   ktsphfredo - Format Pagetable Segment Header
13.18   ktspffredo - Format Level1 Bitmap Block
13.19   ktspsfredo - Format Level2 Bitmap Block
13.21   ktspbfredo - Format Pagetable Datablock
13.22   State change on level 1 bitmap block
13.23   Undo on level 1 bitmap block
13.24   State change on level 2 bitmap block
13.25   Undo on level 2 bitmap block
13.26   State change on level 3 bitmap block
13.27   Undo on level 3 bitmap block
13.28   Update LHWM and HHWM on segment header
13.29   Undo on segment header
13.31   Segment shrink redo for L1 bitmap block
13.32   Segment shrink redo for segment header block
13.41   KTSL - Format LOB Extent Header Block (EHB)
13.42   KTSL - Format LOB Persisten Undo Block (PUB)
13.43   KTSL - Format LOB Hash Bucket Block (UFS)  -- uncommitted free space
13.44   KTSL - Format LOB Free Space Block (FSB)   -- also CFS, committed free space
13.45   KTSL - Format LOB Segment Header Block (SHB)
13.49   KTSL - HBB redo record
13.50   KTSL - LOB Hash Bucket Block (HBB) undo
13.51   KTSL - FSB redo record (Free Space Block)
13.52   KTSL - LOB Free Space Block (FSB) undo record:
13.53   KTSL - PUA redo record: (Persistent Undo Amend ?)
13.54   KTSL - LOB Persistent Undo Block (PUB) undo record
13.55   KTSL - Segment Header (SHB) redo record
13.56   KTSL - LOB Segment Header Block (SHB) undo record

14. Extent management

14.1    ktecush redo: clear extent control lock
14.2    ktelk redo - lock extent (map)
14.3    Extent de-allocate
14.4    kteop redo - redo operation on extent map
14.5    kteopu undo - undo operation on extent map
14.8    kteoputrn - undo operation for flush for truncate

15. Tablespace

16. Row cache

17. Recovery management

17.1    End backup mode marker
17.3    Crash Recovery at scn:  0x0000.02429111
17.28   STANDBY METADATA CACHE INVALIDATION

18. Block image (hot backups)

18.1    Block image
18.3    Reuse redo entry
           (Prewarm range reuse:  tsn=1 base=0x058000c4 nblks=8)
        or (Object reuse: tsn=2 objd=76515)

19. Direct loader

19.1    Direct Loader block redo entry (for logged direct path writes)
19.2    Direct Loader invalidate block range redo entry (for nologging direct path writes)
19.3    Direct block relogging - KCBLCRLB
19.4    Invalidate range relogging - KCBLCRIR

20. Compatibility segment

21. LOB segment

21.1    kdlop (Long Feild) redo:  [sic]
        (insert basicfile clob)

22. Locally managed tablespace

22.2    ktfbhredo - File Space Header Redo:
22.3    ktfbhundo - File Space Header Undo:
22.5    ktfbbredo - File BitMap Block Redo:
22.16   File Property Map Block (FPM)

23. Block writes

23.1    Block written record
23.2    Block read record (BRR)

24. DDL statements

24.1    DDL
24.2    Direct load block end mark
24.4    Media recovery marker
24.10   ??
24.11   ??

25. Queues

26. LOB

26.4    Invalidate LOB (?) (KDLI) 
26.6    Load LOB (KDLI)

• 26.6 add or modify a lob segment (always in 8060 bytes chunks, so one LOB can have many redo records) Of course only for out-of-row storage

27. Block Change Tracking

(E & O.E) – you’ll notice that some of the descriptions include question marks – those are guesses – and some are little more than the raw text extracted from a redo change vector with no interpretation of what they might mean.

Update It 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 entries into the list above when I get a little time.

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