| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re: How do commits release row level locks?
great article arup. Thanks.
Which databases use lock managers? Does SQL Server? Now I know reads block writes in SQL Server, but I thought that was due to not having multi-versioning. is it also due to a lock manager?
I'd assume databases that used page level locking, would lock at the 'block' level and that was equivalent to a page? So its transaction table would just be a semaphore that would say 'this block is locked by transaction x'?
Do any other databases use similiar locking mechanisms to oracle?
>
> From: "Arup Nanda" <orarup_at_hotmail.com>
> Date: 2004/02/12 Thu PM 11:37:17 EST
> To: <oracle-l_at_freelists.org>
> Subject: Re: How do commits release row level locks?
>
> I wrote an article some time ago for DBAZine on this exact question. Pleas
> check this out at http://www.dbazine.com/nanda3.html.
>
> ----- Original Message -----
> From: "Ryan" <ryan.gaffuri_at_cox.net>
> To: <oracle-l_at_freelists.org>
> Sent: Thursday, February 12, 2004 11:13 PM
> Subject: How do commits release row level locks?
>
>
> > 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
> > -----------------------------------------------------------------
> >
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>
-- 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 Fri Feb 13 2004 - 07:44:23 CST
 |
 |