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

Home -> Community -> Usenet -> c.d.o.server -> Re: DML_LOCKS

Re: DML_LOCKS

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 14 Jan 2004 19:18:20 +0100
Message-ID: <ru1b00hk2pg2h1jld2akga8on41cmftqdi@4ax.com>


On 14 Jan 2004 17:35:57 GMT, Chuck <chuckh_nospam_at_softhome.net> wrote:

>If one session is holding a lock on a row, and two other sessions are
>requesting a lock on the same row, how many DML_LOCKS does that count as?
>One, or three?

One. The other locks are not granted

--
Sybrand Bakker, Senior Oracle DBA
Received on Wed Jan 14 2004 - 12:18:20 CST

Original text of this message

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