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

i think this is a bit dangerous..
invalidating code can invalidate lot more things.. and create latches when trying to compile, and locks..
 Oded.

 On 11/10/05, malcolm arnold <malcolmarnold_at_gmail.com> 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?
>
> 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.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l