Re: check table lock.

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Tue, 25 Apr 2006 04:59:05 GMT
Message-Id: <pan.2006.04.25.04.59.04.550287@sbcglobal.net>

On Mon, 24 Apr 2006 21:33:41 -0700, fitzjarrell_at_cox.net wrote:

>
> robertncl_at_gmail.com wrote:

>> Hi,
>>
>> How can i check table lock in oracle database?

>
> Query the V$LOCK and V$LOCKED_OBJECT views. You'll need a join with
> DBA_OBJECTS or USER_OBJECTS to map an object name to an object number.
>
>
> David Fitzjarrell

For table locks, lock type in V$LOCK is of the type 'TM'.

-- 
http://www.mgogala.com

Received on Mon Apr 24 2006 - 23:59:05 CDT