How to trace what is happening inside the stored procedure

  • From: Sami Seerangan <dba.orcl@xxxxxxxxx>
  • To: "Oracle L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 5 Feb 2005 09:30:48 -0500

Hi:

I am running a stored procedure(say P1 with 5000 lines)  using a
particular session (say sid=135).

By joining gv$session and gv$sql, I can identify whether the stored
procedure is running or not.
But  is there a way to indentify, what is the current operation
(within the stored procedure, what particular statement being
executed) OR where we are in the stored procedure

Thanks in advance,
-- 
Sami Seerangan
Oracle DBA
--
http://www.freelists.org/webpage/oracle-l

Other related posts: