Re: How to determine if a stored procedure is used (executed) in the database?
- From: malcolm arnold <malcolmarnold@xxxxxxxxx>
- To: san_oracle_dba@xxxxxxxxx
- Date: Thu, 10 Nov 2005 09:42:19 +0000
> 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?
You can make it invalid. If someone executes it, Oracle will
automatically recompile it, turning it valid. If it stays invalid,
no-one has executed it...
Malcolm.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
