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

Home -> Community -> Mailing Lists -> Oracle-L -> please, locks are at block or row level.?

please, locks are at block or row level.?

From: Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Mon, 4 Oct 2004 11:50:14 -0400
Message-Id: <41617136.000003.02504@DAZA-MGEJCA5J7T>


Hi 3 questions please, if you can lend me your time one moment, 1. I have a confusion, locks are at block level or row level 2. Where is the overhead if they are in the same block, and I lock at the same time all rows in the same block?
3. how can I know in which block is a row?

Thanks :)    

Juan Carlos Reyes Pacheco
OCP

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 04 2004 - 10:45:49 CDT

Original text of this message

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