Re: Damned ! Something lock my record. But what the hell is it ?

From: Mark G <mgumbs_at_nospam.hotmail.com>
Date: Thu, 1 Jul 1999 15:09:34 +0100
Message-ID: <377b7478.0@145.227.194.253>

IF you have the releant DBA rights, throw this bit of code in your sql*plus instance

---

select distinct sh.username || '(' || sh.sid || ')' "Lock holder", ao.object_name "Object",
l.type,
decode(lmode, 1, 'NULL', 2, 'ROW SHARE', 3, 'ROW EXCLUSIVE', 4, 'SHARE', 5, 'SHARE ROW EXCLUSIVE', 6, 'EXCLUSIVE', '?') "Lock mode", sr.username || '(' || sr.sid || ')' "Object requester" from v$session sh, all_objects ao, v$lock l, v$session sr where l.id1 = ao.object_id

and sh.sid = l.sid
and sh.lockwait is null
and sr.lockwait is not null

and l.type = 'TM'
order by 1, 2, 3;

---

M

Christophe CAUCHOIS wrote in message <7lfs8g$119$1_at_wanadoo.fr>...
>Hello everybody !
>
>I have a small problem that probably have a small solution.
>I have an application based on a Oracle 8.0 DB.
>I want to update a record, but it's locked (since 35 minutes !). I find it
a
>little big long...
>Is there a way to know what makes it locked ? (what user, or what
>instance...)
>
>Thank you in advance.
>
>Christophe.
>
>
Received on Thu Jul 01 1999 - 09:09:34 CDT