Re: Detecting executed PL/SQL procedure

Hi Anamika,

look in v$open_cursor and join with v$session and maybe v$sql

Stefan

Anamika wrote:

> Hi,
> I have Oracle 8.0.5 database with lots of third party PL/SQL procedures
> installed. I also have applications that invoke these PL/SQL procs.
> Recently encountered problems with these PL/SQL procs and I need to find
> out which one of them is being executed. i.e., when a function is called
> in the application, it eventually makes a db connection and executes a
> PL/SQL procedure. Is there a way to find out which PL/SQL procedure is
> executed ? There is no documentation with the application which explains
> this.
>
> Thanks,
> -A
Received on Sat Jan 05 2002 - 00:08:52 CST