Re: what does the op:11.4 mean?
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 12 May 2008 17:55:37 +0100
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
Other related posts:
