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: Ted Chyn <tedchyn_at_yahoo.com>
Date: 20 Jul 2002 20:49:17 -0700
Message-ID: <44a19320.0207201949.45bbc47b@posting.google.com>


sybrand,
thnx for the answer.
row share: others can read
rows exclusive: access is completely blocked

when I tested this in sqlplus whether lmode =2(row share) or 3(row share exclusive) does not make any difference. In both cases updater does not block reader. If it is so,
there must be something else differs between the two.

ted

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:<tm6ijugh8nc66adje9qeehb2kn1e847283_at_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 - 22:49:17 CDT

Original text of this message

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