回复: Re: what does the op:11.4 mean =3F?=

  • From: li yuefu <liyuefu@xxxxxxxxxxxx>
  • To: jonathan@xxxxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 14 May 2008 09:05:10 +0800 (CST)

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


Other related posts:

  • » 回复: Re: what does the op:11.4 mean =3F?=