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: TABEL LOCKING!!

Re: TABEL LOCKING!!

From: Tomasz Gołebiowski <tgolebiowski_at_digest.com.pl>
Date: Wed, 03 Nov 1999 15:25:02 +0100
Message-ID: <382045BE.DAF5AECF@digest.com.pl> 





Hi,



    I don't get your problem. Oracle automatically handles tables
locking. If one user inserts, updates or delets row from the table
Oracle creates shared lock on the table and exclusive lock on the row
that is currently performed. The only


thing that you should take into consideration is the right growth of
rollback segments.



Tomek

Received on Wed Nov 03 1999 - 08:25:02 CST












Original text of this message













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