Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Auditing Stored Procedures
i am using oracle 9i release 2
gazzag wrote:
> 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 - 09:17:09 CST