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

Home -> Community -> Usenet -> c.d.o.server -> Re: Auditing Stored Procedures

Re: Auditing Stored Procedures

From: raju <raju1105_at_gmail.com>
Date: 31 Oct 2006 07:17:09 -0800
Message-ID: <1162307829.750323.159470@i42g2000cwa.googlegroups.com>


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

Original text of this message

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