RE: Question on tracking usage of packages
- From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
- To: <achoto@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 16 Mar 2006 15:31:27 -0500
The solution that strikes me is to include code in the package to write
to a logging table.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ana Choto
Sent: Thursday, March 16, 2006 3:10 PM
To: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
