Re: Lock: Row Share

"Fan Ruo Xin" <fanruox_at_sbcglobal.net> wrote in message news:3CC4643D.A790FE39_at_sbcglobal.net...
>
>
> 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

This is the whole purpose of row level locking.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address