Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Tracking Procedures
amerar_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 Received on Tue May 15 2007 - 14:03:36 CDT