Re: Procedure Execution Status

Use the script provided by Steve Adams at http://www.ixora.com.au/scripts/sql/executing_packages.sql, you should be able to select more (and appropriate) columns from x_$ksuse(basis for v$session).

for some reason I haven't been able to make this across all nodes, it works perfect for the single node. Does anyone know how to make this work across all nodes in a RAC environment? Trust me I have tried, it dodn't work.

Raj

On Mon, 25 Oct 2004 10:19:29 +0530, Gracelin Priya S. <gracelinp_at_quark.co.in> wrote:
> Hi,
>
> Is there any data dictionary which will help to find the procedures or
> functions that are getting executed currently and from which node(IP address
> or machine name) had invoked the execution??
>
> Thanks
> Gracelin
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
------------------------------
--
http://www.freelists.org/webpage/oracle-l