RE: Question on tracking usage of packages

From: Freeman, Donald <dofreeman_at_state.pa.us>
Date: Thu, 16 Mar 2006 15:31:27 -0500
Message-ID: <51327ABA927BEF4B96590554CEA7832C01930B40@enhbgpri05.backup>

The solution that strikes me is to include code in the package to write to a logging table.

	-----Original Message-----
	From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ana Choto
	Sent: Thursday, March 16, 2006 3: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

Received on Thu Mar 16 2006 - 14:31:27 CST