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