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

You could look for it in the shared pool using the V$DB_OBJECT_CACHE view. You could automate the process using a job or a system trigger (to fire whenever it is run), but if it's just a matter of it being frequently used checking a few times a day for it in V$DB_OBJECT_CACHE using a job that writes to a table would probably be enough.

Regards,
Chris Gait

2005/11/10, Maimon Oded <oded.maimon_at_gmail.com>:
> 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