Re: Need help on Page Locking feature

Oracle does have to revert to Page Locking (actually Oracle Block Locking) when you use Oracle Parallel Server, otherwise for a single instance it is as Keith has mentioned.

Andrew

Keith Jamieson wrote:

> If you lock a Page you only lock rows on that table which are on that
> page.
> If you lock a Table you lock all rows, irrespective of which page they
> are on.
>
> Page locking allows greater concurrency than table locking.
>
> Page Locking
>
> Jim Kennedy wrote:
>
> > Table Locking. Why would you want to lock a page?
> > Jim
> > Pearapon S. wrote in message <7fforp$tbf$1_at_news.ksc.co.th>...
> > >Dear Everyone,
> > >
> > > Does Oracle support " Page and Table Locking " feature ?
> > >
> > >Thank you very much in advance.
> > >
> > >Regards,
> > >Pearapon S.
> > >pearapon_at_ksc.th.com
> > >
> > >
> > >
Received on Tue Apr 20 1999 - 08:55:45 CDT