Re: Obtain stats on packages and functions within packages
From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Thu, 27 Jan 2011 08:13:31 -0700
Message-ID: <AANLkTi=RK8Jfzm12t5tshSSUaqPYGPygY57-VCcMVLhp_at_mail.gmail.com>
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 to 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. Sandy
Date: Thu, 27 Jan 2011 08:13:31 -0700
Message-ID: <AANLkTi=RK8Jfzm12t5tshSSUaqPYGPygY57-VCcMVLhp_at_mail.gmail.com>
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 to 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. Sandy
On Wed, Jan 26, 2011 at 6:02 PM, Gus Spier <gus.spier_at_gmail.com> 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.
>
> Gus
>
>
> Sandy
> Transzap, Inc.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 27 2011 - 09:13:31 CST