Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Locking mode in 10g seems to have changed

Re: Locking mode in 10g seems to have changed

From: Anurag Varma <avoracle_at_gmail.com>
Date: 3 Aug 2006 09:47:57 -0700
Message-ID: <1154623677.418687.74270@b28g2000cwb.googlegroups.com> 






claytonarends_at_gmail.com wrote:


--snip--


>   10g

>     LOCKED_MODE = 3


>     MODE_HELD = Row-X (SX)

>

>   9i

>     LOCKED_MODE = 2


>     MODE_HELD = Row-X (SS)

>



--snip--


>

> - Clayton




This change was done in 9.2.0.6 or 9.2.0.7.



See metalink bug note: 4115353  SELECT FOR UPDATE CHANGED TO ROW
EXCLUSIVE


Anurag
Received on Thu Aug 03 2006 - 11:47:57 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US