Thanks a lot. I created a sr in metalink, and I got the answer: The op:11.4 is related to the select ... for update . There will be a row lock on every rows returned. and I did a test about it, the test logfile dump is something like the dump file contains the op:11.4. --- Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>写道: > > LKR = LocK Row > > Regards > > Jonathan Lewis > http://jonathanlewis.wordpress.com > > Author: Cost Based Oracle: Fundamentals > http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html > > The Co-operative Oracle Users' FAQ > http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > > ----- Original Message ----- > From: "yuefu li" <liyuefu@xxxxxxxxxxxx> > To: <oracle-l@xxxxxxxxxxxxx> > Sent: Monday, May 12, 2008 2:26 PM > Subject: what does the op:11.4 mean? > > > > 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 > > > ----------------------------------------------------------- > > -- > //www.freelists.org/webpage/oracle-l > > > 李曰福 Li Yuefu ----------------------------------------------------------- MP: 13816280733 Email: liyuefu@xxxxxxxxxxxx Gmail: liyuefu@xxxxxxxxx MSN: fengshanjian2@xxxxxxxxxxx Blog: http://fengshanjian.net ----------------------------------------------------------- ___________________________________________________________ 雅虎邮箱,您的终生邮箱! http://cn.mail.yahoo.com/ -- //www.freelists.org/webpage/oracle-l