Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> can table locking improve performance ??

can table locking improve performance ??

From: <babette.turnerunderwood_at_sdc-dsc.gc.ca>
Date: Tue, 8 Jun 2004 14:41:57 -0400
Message-ID: <FCF2E0B5B7A9CC4EAAD504CE0D2BB5B365DD38@NCEV02.hrdc-drhc.net>

We have an initial load process that is very long running. The update of 38M rows takes hours and hours. There are two users on the entire system, us doing the load and another user to look at some of the v$ views during the load process.

Updates need to put exclusive row-level locks before being able to update rows. If we do a table level lock PRIOR to the update statement, what effect will it have on performance. Intuitively, we think it should be more efficient, but I don't know if Oracle will be more efficient in checking locks when updating rows or does the exact same source code apply, regardless if there is a table level lock.

In other words, in this case, can a table level lock improve performance ?


Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Tue Jun 08 2004 - 13:39:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US