Re: Block Locks

Ed Jennings wrote:
>
> If an application is using array processing with a large array
> size ( > 2000); and it is doing inserts into a table: At what
> point will Oracle escalate the row level locks to block locks
> and/or table locks???
>
> Does anyone know if this formula is published?
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~
> jennings_at_dca.net To quote 'Oracle7 Server Concepts Manual' page 10-4
 "Note: ORACLE never escalates locks"

I think this is true.

Torben Bach Pedersen
DBA
Kommunedata I/S
Ã…rhus
Denmark Received on Fri Sep 06 1996 - 00:00:00 CEST