Re: How to anticipate (Oracle) database locks.

Jan Brunia wrote:

> Hello,
>
> The lock I'm referring to is actually a deadlock according the database
> experts
> I talk to. It seems that a table is locked and until it's released another
> program can
> do an access.
>
> I did some searching on the web and I encountered the term pessimistic
> access.
>
> I have some more information about the issue. This is it. Doe sthis make any
> sense
> to you? Hope it does.
>
> Kind regards,
>
> Jan
>
> <snipped>

In Oracle, locking makes sense in rare circumstances ... with the emphasis on rare.

I would be more concerned about getting rid of any locking before I would worry about locking something ... until I found a clear and compelling reason to create a lock. And if I found one ... I'd be looking for the fastest possible method for completeing the transaction and releasing it.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)