Re: Table Locking

From: Joseph Dimech <joe_at_tsc-corp.com>
Date: Fri, 03 Dec 2004 18:07:40 GMT
Message-ID: <MX1sd.158$Af2.28@trnddc06>

Hi Michael:

This is true, I do have SELECT FOR UPDATE statemnets in my code. But a row share table lock still give a high degree of concurrency for a table so this would not present any problems for me. Another process would still be able to lock its own rows and update them. The type of problem locks I am experiencing are Share table locks or Share Row Exclusive Locks. I never ask for these and don't know how I am getting them. The database should only be acquiring Row share or Row Exclusive Table locks for the type of SQL I am using. Oracle documentation states that it never escalates locks. So I don't know...

Joe

"BlackBeltDBA" <michael_at_cloreoffice.com> wrote in message news:1102087608.140019.295430_at_z14g2000cwz.googlegroups.com...
> SELECT FOR UPDATE uses row share table locks.
>
Received on Fri Dec 03 2004 - 12:07:40 CST