Re: Table Locked by Who

From: P.M. Shrote <p_shrote_at_hotmail.com>
Date: Thu, 19 Oct 2000 20:17:41 GMT
Message-ID: <01c03a09$5a0d1f60$a4bf1eac_at_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

Rayfil Cheung <rayfil_at_forward-hk.com> wrote in article <39ED88D3.208E50E7_at_forward-hk.com>...
> Hi,
>
> How can I check a table is locked or used by others. Thank you.
>
>
Received on Thu Oct 19 2000 - 22:17:41 CEST

Original text of this message