Re: Table Locked by Who

From: P.M. Shrote <p_shrote_at_hotmail.com>
Date: Thu, 19 Oct 2000 20:10:47 GMT
Message-ID: <01c03a08$633d8760$a4bf1eac@501091PHX10549>

Hi guys,
Just run this from sqlplus connected as DBA. This will give the locked objects and who is locking.
SET PAGES 1000
SELECT V.OBJECT_ID,T.OBJECT_NAME,
V.SESSION_ID,V.ORACLE_USERNAME,V.OS_USER_NAME,V.LOCKED_MODE FROM V$LOCKED_OBJECT V, DBA_OBJECTS T
WHERE V.OBJECT_ID=T.OBJECT_ID
/

Hope this will help
Thanks
Pramod M. Shrote

Paul Sellars <sello_at_my-deja.com> wrote in article <8skcaj$rh8$1_at_nnrp1.deja.com>...
> Sorry forgot to add: if you are trying to find hangs due to locks
> try the oracle utility utllockt.sql
> it is in $oracle_home/rdbms/admin.
>
> Paul
> > Hi,
> >
> > How can I check a table is locked or used by others. Thank you.
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Thu Oct 19 2000 - 15:10:47 CDT