Re: Tracking/monitoring a PL/SQL procedure

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Thu, 17 Jan 2002 17:39:01 +0000
Message-ID: <3C470C35.B45A9D60@exesolutions.com>

Have you looked in v$sqlarea? v$open_cursors?

Daniel Morgan

Anamika wrote:

> Hi,
> I have a Java program calling a PL/SQL procedure in the Oracle DB.
> Dont know the name of the pl/sql procedure that the java program
> calls.
> Is there a way to find out which pl/sql procedure is executed when the
> java program executes ? Tried v$ tables not very successful. Maybe
> missing something.
> Or can I set a trigger or something else, that will kick in when the
> pl/sql proc executes ?
>
> Thanks,
> -A
Received on Thu Jan 17 2002 - 11:39:01 CST