Re: what does the op:11.4 mean?

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Mon, 12 May 2008 11:03:16 -0500
Message-ID: <3b0f44a10805120903x6cb5d518y2315840cb73947a2@mail.gmail.com>


11.4 is LOCK ROW PIECE.

-Gopal

On Mon, May 12, 2008 at 8:26 AM, yuefu li <liyuefu_at_yahoo.com.cn> wrote:
> 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
>
>
>

-- 
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
http://www.amazon.com/gp/product/007146509X/
--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 12 2008 - 11:03:16 CDT

Original text of this message