Identify locked resources?

From: Chris Sarnowski <csarnows_at_see.sig.below>
Date: Fri, 24 Jul 1998 16:48:34 -0400
Message-ID: <35B8F322.121C@see.sig.below>

I use the following query to identify locked tables:

column s_id format 99999
column process format A7
column xidsqn format 999999

select substr(uo.object_name,1,30) object,

       lo.session_id s_id, substr(lo.oracle_username,1,8) o_user,
       substr(lo.os_user_name,1,8) os_user, lo.process, lo.xidsqn

from v$locked_object lo, user_objects uo where lo.object_id = uo.object_id;

If a package is running, and someone tries to recompile it, the recompilation waits until the package is done, and the query above returns no rows. Is there a v$ table I can query to try to identify more specifically the cause of a very slow (or timed out) package compilation? (Oracle 7.3.3.4, running on Solaris 2.6).

--
Chris Sarnowski csarnows @ curagen com CuraGen Corporation
(203)401-3330, ext 227 Received on Fri Jul 24 1998 - 15:48:34 CDT