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


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

Other related posts: