Re: Re: How do commits release row level locks?
- From: <ryan.gaffuri@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 13 Feb 2004 8:44:23 -0500
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@xxxxxxxxxxx>
> Date: 2004/02/12 Thu PM 11:37:17 EST
> To: <oracle-l@xxxxxxxxxxxxx>
> 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@xxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> 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@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
- » Re: Re: How do commits release row level locks?
