Re: Lock: Row Share

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 22 Apr 2002 20:33:54 +0200
Message-ID: <spf8cug3c0hv0448jic6ockok013h26qvg@4ax.com>

On Mon, 22 Apr 2002 15:07:33 GMT, Rosaline <Rosaline_at_hotmail.com> wrote:

>Hi,
>(I am looking at ORACLE 8I certification. )
>
>"Share locks prevent other exclusive locks".
>But:
>"Row Share (RS)
>This lock prevents other sessions from acquiring another RS or ... on
>the rows affected."
>
>I can't understand why RS can't be compatible with RS on the same rows.
>Someone can explain it to me?
>Thanks in advance
>Rosaline

Row Share means that other sessions are allowed to read the record, not update.
Evidently you can only apply 1 row share lock on a row, otherwise it wouldn't be a lock.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Apr 22 2002 - 13:33:54 CDT