Re: lock ?

From: <Kenneth>
Date: Tue, 21 Oct 2003 19:24:10 GMT
Message-ID: <3f9585f4.1532613@news.inet.tele.dk>

On Tue, 21 Oct 2003 16:00:17 +0200, "search" <gerry_at_village.uunet.be> wrote:

>The guys from our database provider told us that there was a lock on one of
>our tables.
>It was fixed in 2 minutes.
>
>They won't provide us the information how you can see how a table is locked
>and how to unlock them ?
>Can some-one of you provide me more information.
>
>We use oracle 8.1.7 database.
>
>
>many thx
>
>Gerry
>
>

Hi Gerry,

The following query will list all locked objects together with the lock modes and the users holding the locks :

select oracle_username
os_user_name,

locked_mode,
object_name,
object_type

from v$locked_object a,dba_objects b
where a.object_id = b.object_id

• Kenneth Koenraadt

Received on Tue Oct 21 2003 - 14:24:10 CDT