RE: Question on tracking usage of packages

Hi Ana,  

you can try with auditing: audit execute on....  

Cheers,
L.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ana Choto Sent: Thursday, March 16, 2006 9:10 PM
To: oracle-l_at_freelists.org
Subject: Question on tracking usage of packages

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