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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
