Re: Auditing Stored Procedures

From: gazzag <gareth_at_jamms.org>
Date: 31 Oct 2006 04:22:19 -0800
Message-ID: <1162297339.134579.13230@e64g2000cwd.googlegroups.com>

raju wrote:
> Hi I want to list all the stored procedures that are being used, when,
> how many times, who uses etc(kind of monitoring/auditing). All of these
> stored packages are declared in packages.
>
> Does anyone knows how to do it??
>
> regards
>
> --raju

I ask again, Oracle version?

The above can be achieved using database triggers or Oracle Auditing, depending on your answer to the above.

HTH -g Received on Tue Oct 31 2006 - 06:22:19 CST