Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> How to trace what is happening inside the stored procedure
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-lReceived on Sat Feb 05 2005 - 09:33:27 CST
![]() |
![]() |