what does the op:11.4 mean?

From: yuefu li <liyuefu_at_yahoo.com.cn>
Date: Mon, 12 May 2008 06:26:01 -0700 (PDT)
Message-ID: <598042.22431.qm@web15002.mail.cnb.yahoo.com>

hi all,

I create a dump file from logfile, for I want to know why the redo file is so big. I found much op:5.1 followed by op:11.4.

I know op:5.1 is the information for undo, such as insert(op:11.2), delete(op:11.3), update(op:11.5). but I don't know what's for op:11.4.

such as:

REDO RECORD - Thread:1 RBA: 0x00b958.00000003.0100 LEN: 0x00d8 VLD: 0x01
SCN: 0x000d.22a825bf SUBSCN: 1 05/04/2008 14:59:56 CHANGE #1 TYP:0 CLS:18 AFN:74 DBA:0x1280fd97 SCN:0x000d.22a825bf SEQ: 1 OP:5.1
ktudb redo: siz: 72 spc: 5688 flg: 0x0022 seq: 0x0b3e rec: 0x22

            xid: 0x0001.026.001bb38e
ktubu redo: slt: 38 rci: 33 opc: 11.1 objn: 7547 objd: 7547 tsn: 6
Undo type: Regular undo Undo type: Last buffer split: No
Tablespace Undo: No

             0x00000000
KDO undo record:
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x1280fd97.0b3e.21
KDO Op code: LKR row dependencies Disabled   xtype: XA bdba: 0x0cc0a309 hdba: 0x01c07d09 itli: 2 ispac: 0 maxfr: 4863
tabn: 0 slot: 53 to: 0
CHANGE #2 TYP:0 CLS: 1 AFN:51 DBA:0x0cc0a309 SCN:0x000d.22a825bf SEQ: 1 OP:11.4
KTB Redo
op: 0x02 ver: 0x01
op: C uba: 0x1280fd97.0b3e.22
KDO Op code: LKR row dependencies Disabled   xtype: XA bdba: 0x0cc0a309 hdba: 0x01c07d09 itli: 2 ispac: 0 maxfr: 4863
tabn: 0 slot: 53 to: 2

ÀîÔ»¸£ Li Yuefu

---

  MP: 13816280733 Email: liyuefu_at_yahoo.com.cn   Gmail: liyuefu_at_gmail.com MSN: fengshanjian2_at_hotmail.com   Blog: http://fengshanjian.net

---

---

Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
--

http://www.freelists.org/webpage/oracle-l Received on Mon May 12 2008 - 08:26:01 CDT