Stored Procedure Usage?

Hello All, Is there a way to monitor the usage of stored procedures, I have got a lot of code, and want to see if any of the defined stored proc's are being used. Thanks in advance.

I don't know of any SMI queries that would give you this information. However, you could write some code that would grep your application source files to determine if there are any EXECUTE PROCEDURE statements. HTH, Clifton rico@wsx.wsex.com wrote in message <7aabie$879$1@news.xmission.com>... > >Hello All, > >Is there a way to monitor the usage of stored procedures, I have got a lot of code, and want to see if any of the defined stored proc's are being used. > >Thanks in advance.

rico@wsx.wsex.com wrote: > > Hello All, > > Is there a way to monitor the usage of stored procedures, I have got a lot of code, and want to see if any of the defined stored proc's are being used. onstat -g prc Will print out the stored procedure cache information (like -g dic) if the procedre is there it has been executed since startup. In addition, the ref_cnt column indicates the number of threads currently executing the procedure. Art S. Kagel

Hi, The 'Sql Power SniFFFer' SQL transaction monitor and service level monitor product line is about to be released for Informix. Visit www.sqlpower.com for the details on this ZERO impact SQL transaction performance monitor. Randy Reiter rreiter@sqlpower.com rico@wsx.wsex.com wrote in message <7aabie$879$1@news.xmission.com>... > >Hello All, > >Is there a way to monitor the usage of stored procedures, I have got a lot of code, and want to see if any of the defined stored proc's are being used. > >Thanks in advance.