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