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_at_american.edu> 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

--
http://www.freelists.org/webpage/oracle-l