On May 15, 2:03 pm, Maxim Demenko <mdeme..._at_gmail.com> wrote:
> ame..._at_iwc.net schrieb:
>
> > 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!
>
> Enable auditing would yield this information among others.
>
> Best regards
>
> Maxim
But, how much overhead would auditing put on the database? I do not
want to generate tons of log files, or tons of any unnecessary I/
O......
Received on Tue May 15 2007 - 14:56:48 CDT
