Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Re: Question on tracking usage of packages

Daniel Fink

2006-03-16

Replies:

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@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 o f 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

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.