Re: Monitor pl/sql execution

From: Dmitriy B. Agafonov <dagafono_at_rgti.com>
Date: 1997/09/16
Message-ID: <341F170E.2456BCDB@rgti.com>#1/1

Try
select owner, name, type, locks

from V$DB_OBJECT_CACHE
where type in ('PROCEDURE', 'FUNCTION', 'PACKAGE', 'PACKAGE BODY')

and locks > 0;

Not exactly what you were asking for, but it's all I can suggest.

Best regards,

Dmitriy Agafonov.

Vidar Mikkelsen wrote:

> Hi !!
>
> I want to list executing pl/sql programs and get information about
> pid and serial# , pl/sql name ...
> I have tried to make select from the view's
> v$session and v$process without any succee....
> Is it possible to get this information ??
>
> Vidar.
Received on Tue Sep 16 1997 - 00:00:00 CDT