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

Home -> Community -> Usenet -> c.d.o.server -> Re: q: diffrence between row_shared and row_exclusive lock ?

Re: q: diffrence between row_shared and row_exclusive lock ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 20 Jul 2002 10:16:50 +0200
Message-ID: <tm6ijugh8nc66adje9qeehb2kn1e847283@4ax.com>


On 19 Jul 2002 23:17:36 -0700, tedchyn_at_yahoo.com (Ted Chyn) wrote:

>all,
>
>row shared lock lmode=2
>row exclusive lock lmode=3
>
>row shared is more restrictive than row exclusive.
>row shared can be generated with select ... for update of
>row exclusive can be generated with lock table in row exclusive mode
>or update statement.
>
>
>
>Can any one give me an working example explaining what are difference
>between these two type locks - in terms why one is more restritive
>than the other?
>
>thnx in advance
>ted chyn

row share: others can read
rows exclusive: access is completely blocked

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Jul 20 2002 - 03:16:50 CDT

Original text of this message

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