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_at_exesolutions.com>
Date: Thu, 17 Jan 2002 17:39:01 +0000
Message-ID: <3C470C35.B45A9D60_at_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 - 18:39:01 CET