Re: Question on tracking usage of packages

Ana,

I've done limited auditing in my time, so I'm not certain it will get you what 
you need, but it is a good place to start.

The other option is to include code in the package/procedure/function to update 
a home-grown audit table. 

I don't think oracle has an 'on execute' trigger yet...

Regards,
Dan Fink

Ana Choto <achoto@xxxxxxxxxxxx> wrote:  I have received a request to track the 
usage of a package and its individual functions since the package was created 
back in December 2005.  We use Quest software and even though we can keep 
historic information using StealthCollect what we see is the actual sql being 
executed but not the package itself.  
 
 I have been looking in Metalink but I can't find anything I can use to 
accomplish this.  The person making this request wants me to track the usage of 
this package from now on.  
 
 If anyone can please point me to some documentation I can look at I will 
appreciate it.
 
 Thanks
 
 Ana E. Choto
 American University
 e-Operations - Information Technology
 Phone (202) 885-2275
 Fax      (202) 885-2224

Other related posts: