Re: Locks

From: Scott A Baxter <sbaxter_at_c031.aone.net.au>
Date: Mon, 14 Sep 1998 14:42:17 +1000
Message-ID: <6ti713$1gh$1@news.mel.aone.net.au>

Try using the utllockt.sql script provided by Oracle usually found in the $ORACLE_HOME/rdbms/admin directory this gives you a tree structured graph of all locks causing other users to wait

regards,
Heidi

calberto_at_my-dejanews.com wrote in message <6tesov$ira$1_at_nnrp1.dejanews.com>...
>Hi all!
>
>How can I identify which user is holding(locking) resources that another
user
>wants to use? I have queried V$LOCKED_OBJECT but it shows all the tables
some
>user is locking, regardless if another is trying to access it at the same
>time or not. I only want to know if some user is waiting (being blocked)
for
>another user. Is there any status in any of these dictionary tables, like
>V$LOCKED_OBJECT, V$LOCK and V$SESSION.
>
>Thanks in advanced,
>
>Carlos
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Sun Sep 13 1998 - 23:42:17 CDT