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

Home -> Community -> Mailing Lists -> Oracle-L -> How do commits release row level locks?

How do commits release row level locks?

From: Ryan <ryan.gaffuri_at_cox.net>
Date: Thu, 12 Feb 2004 23:13:17 -0500
Message-ID: <011901c3f1e7$b51d46c0$51a36244@ryan2le36ofjce>


Now Oracle does not track which rows are locked. How processes know when a lock has been released? I can't find it in the docs. I'm assuming there is something similiar to an SCN written to the block header of each row. However, the SCN would not be sufficient, since it does not identify whether the transaction is complete.



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 Thu Feb 12 2004 - 22:13:17 CST

Original text of this message

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