Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Tracking Procedures

Re: Tracking Procedures

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Tue, 15 May 2007 21:03:36 +0200
Message-ID: <464A0408.1000103@gmail.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US