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 determine if a stored procedure is used (executed) in the database?

How to determine if a stored procedure is used (executed) in the database?

From: San Sridharan <san_oracle_dba_at_yahoo.com>
Date: Wed, 9 Nov 2005 15:51:56 -0800 (PST)
Message-ID: <20051109235156.33496.qmail@web36310.mail.mud.yahoo.com>


For index we can monitor the index and find out if it's been used.  

Other than adding custom code to the stored procedure to track it's execution, is there any other way to do it without modifying it?  

Thanks,
San



Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 09 2005 - 18:29:55 CST

Original text of this message

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