11.4 is LOCK ROW PIECE. -Gopal On Mon, May 12, 2008 at 8:26 AM, yuefu li <liyuefu@xxxxxxxxxxxx> 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@xxxxxxxxxxxx > Gmail: liyuefu@xxxxxxxxx MSN: fengshanjian2@xxxxxxxxxxx > 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 > -- > //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/ -- //www.freelists.org/webpage/oracle-l