Re: Locking

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 10 Aug 1998 21:26:45 +0200
Message-ID: <35CF4974.F31EA44C@sybrandb.demon.nl>

Hi Tong,

2) wait forever until the first process finishes. If you don't want that you will have to lock the tables involved explicitly with a lock ... <lockmode> nowait. Of course, Oracle usually applies row level locks only, and escalates only in specific cases to the table level. Usually you won't notice locking problems. Please make sure all primary and foreign keys are properly indexed. If during constraint checking a full table scan is necessary because of lack of index Oracle will escalate the lock.

Hth
Sybrand Bakker

twang_at_visa.com wrote:

> Hi,
>
> I got a question about the locking in Oracle. When two processes access a
> table, one lock the table as for insert or update and the other tries to lock
> the same table, the second process fails to lock the table, What's default
> behavior for the second process 1)return immediately with error(Informix
> does) 2)suspended until the first finish and resume to access the table 3)
> ??
>
> Thanks a lot!
>
> Tong
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Mon Aug 10 1998 - 14:26:45 CDT