Home -> Usenet -> comp.databases.oracle -> Do you ever really get row level locking?

Do you ever really get row level locking?

From: Susan Richards <lnuscsi.sricha01_at_eds.com>
Date: 1996/06/06
Message-ID: <31B72D8D.173_at_eds.com>#1/1 







All,	


   I have been a DBA for several years but am new to Oracle.  
When ever I hear a discussion of the advantages of Oracle "row 
level locking" is always brought up.  I am unable to see how 
true row level locking can be achieved.  Isn't row level locking 
determined by the INITRANS parameter set in the table.  If I 
have an initrans of 1 then only 1 transaction can update rows in 
a page.  This is the default.  You lose 27 bytes per data block 
for each increase of the initrans parameter.  For example if I 
had 100 rows per data block(page) and I wanted true row level 
locking I would lose 2700 bytes of my data block just for 
locking.  If I am wrong please enlighten me. 



Susan Richards
Received on Thu Jun 06 1996 - 00:00:00 CEST












Original text of this message