Re: Procedure Execution Status
- From: rjamya <rjamya@xxxxxxxxx>
- To: gracelinp@xxxxxxxxxxx
- Date: Mon, 25 Oct 2004 06:50:09 -0400
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@xxxxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
--
------------------------------
--
//www.freelists.org/webpage/oracle-l
Other related posts:
