Re: Obtain stats on packages and functions within packages

  • From: Slim Dave <slimdave@xxxxxxxxx>
  • To: sbecker6925@xxxxxxxxx
  • Date: Tue, 1 Feb 2011 05:58:37 -0800 (PST)

To the VP and CEO ...

"Boy, this would be really easy if the developers would instrument their code 
with DBMS_Application_Info, just like so many other companies do .. it's a real 
shame we have to jump through these expensive, time-consuming hoops to do what 
ought to be so straightforward if only they would ... etc"



>From: Sandra Becker <sbecker6925@xxxxxxxxx>
>To: gus.spier@xxxxxxxxx
>Cc: gajav@xxxxxxxxx; oracle-l <oracle-l@xxxxxxxxxxxxx>
>Sent: Thu, 27 January, 2011 15:13:31
>Subject: Re: Obtain stats on packages and functions within packages
>Unfortunately, no.  Although I have mentioned it more than once, development 
>refuses to even consider it.  I've got meetings all day today but tomorrow I 
>want to start looking into the DBA_HIST views to see if I can figure out how 
>pull out the package/function information.  I was hoping someone had already 
>written a script so I don't have to re-invent the wheel.  Never hurts to learn 
>things on your own of course.
>On Wed, Jan 26, 2011 at 6:02 PM, Gus Spier <gus.spier@xxxxxxxxx> wrote:
>Sandra, is there any chance that the packages and functions have been 
>"instrumented"? That is, has anybody taken advantage of DBMS_APPLICATION_INFO? 
>that would certainly make your task easier.
>>Transzap, Inc.


Other related posts: