Re: Tracking Procedures

On May 15, 10:37 am, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:
> Hi,
>
> We have a database with over 2000 stored procedures. We're pretty
> sure not all of them are used. Short of turning on tracing for a few
> weeks, or trying to use TOAD or something to piecemeal everything
> together, does Oracle have any way of storing the last time a
> procedure was executed??
>
> Thanks!

Don't forget, some things might only be used once a year... or less...

jg

--
@home.com is bogus.  http://searchdatacenter.techtarget.com/originalContent/0,289142,sid80_gci1244661,00.html