Re: Lock: Row Share

Sybrand Bakker wrote:

> 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.

Hi,
Thx for the relpy.
For a row, I can only apply 1 share lock. But for a table, I can apply n share locks at the same time.
???
Regards
Rosaline

>
>
> Hth
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Mon Apr 22 2002 - 14:27:16 CDT