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

Home -> Community -> Mailing Lists -> Oracle-L -> How to trace what is happening inside the stored procedure

How to trace what is happening inside the stored procedure

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Sat, 5 Feb 2005 09:30:48 -0500
Message-ID: <f09dd62805020506305e8408b3@mail.gmail.com>


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
Received on Sat Feb 05 2005 - 09:33:27 CST

Original text of this message

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