Re: How to determine if a stored procedure is used (executed) in the database?
- From: Maimon Oded <oded.maimon@xxxxxxxxx>
- To: san_oracle_dba@xxxxxxxxx
- Date: Thu, 10 Nov 2005 10:00:17 +0200
monitor dba_ddl_locks view
or the x$ tables that the view is based on
On 11/10/05, San Sridharan <san_oracle_dba@xxxxxxxxx> wrote:
>
> 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
>
Other related posts:
