Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Locks modes
Rick Hanks <hanksr_at_logica.com> wrote in article
<01bd832c$273ab340$8011ea9e_at_ukp01221.logica.co.uk>...
> While investigating a locking problem the following info was retrieved
from
> dba_locks
>
> session_id 8
> lock_type DML
> mode_held Row-X (SX)
> mode requested None
> lock_id1 1161
> lock_id2 0
> last_convert 4480
> Blocking_others Blocking
>
> Coluld anyone explain why this is flagged as Blocking when mode_requested
> is None (v$lock.lmode = 0)., or have i mis-interpreted something?
>
The process is marked as blocking because it has the lock and someone else
wants it. It's mode requested is none, because it has the lock so mode
held has a value equal to the type of lock held. The wanting process has
mode held of none while their mode requested has a value equal to the lock
mode they want.
Received on Tue May 19 1998 - 13:46:09 CDT