Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Tracking/monitoring a PL/SQL procedure

Tracking/monitoring a PL/SQL procedure

From: Anamika <hemanir_at_yahoo.com>
Date: 16 Jan 2002 05:43:05 -0800
Message-ID: <5130f039.0201160543.29c39fc0@posting.google.com> 





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 Wed Jan 16 2002 - 07:43:05 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US