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

Home -> Community -> Usenet -> c.d.o.server -> Re: Locking Problem

Re: Locking Problem

From: Ross Mohan <rmohan_at_ix.netcom.com>
Date: Wed, 3 Mar 1999 08:52:20 -0500
Message-ID: <7bjere$jfe$1@paxfeed.eni.net> 





<snip>



>> then the entire table is locked.


>


>That's not true!  Oracle only locks the rows that you are updating.  It


>does not lock the whole table. The lock is released when you rollback or


>commit.






Well...............there *is* an exclusive  DDL lock on the whole table so


    that no one can drop/alter it whilst the UPDATE proceeds.....



But, that's picking nits, methinks.....



Ross Mohan



Received on Wed Mar 03 1999 - 07:52:20 CST












Original text of this message













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