Re: Obtain stats on packages and functions within packages
- From: Gus Spier <gus.spier@xxxxxxxxx>
- To: gajav@xxxxxxxxx
- Date: Wed, 26 Jan 2011 20:02:50 -0500
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
On Wed, Jan 26, 2011 at 5:00 PM, Gaja Krishna Vaidyanatha
<gajav@xxxxxxxxx>wrote:
> Hi Sandra,
>
> AWR has a wealth of information with everything that you are trying to get.
> I would look into that first before investing time in scripts. If you look
> at a sample AWR report it has what you are looking for and you can get the
> information based on the relevant snap_ids.
>
> Cheers,
>
> Gaja
>
> Gaja Krishna Vaidyanatha,
> Founder/Principal, DBPerfMan Inc.,
> http://www.dbperfman.com
> Phone - 001-(650)-743-6060
> Co-author:Oracle Insights:Tales of the Oak Table -
> http://www.apress.com/book/bookDisplay.html?bID=314
> Co-author:Oracle Performance Tuning 101 -
> http://www.amazon.com/gp/reader/0072131454/ref=sib_dp_pt/102-6130796-4625766
>
>
> ------------------------------
> *From:* Sandra Becker <sbecker6925@xxxxxxxxx>
> *To:* oracle-l <oracle-l@xxxxxxxxxxxxx>
> *Sent:* Wed, January 26, 2011 1:29:40 PM
> *Subject:* Obtain stats on packages and functions within packages
>
> Platform - IBM z9, SUSE 10 in virtual machine
> Oracle - EE 10.2.0.4
>
> My VP and the CEO came in today and wanted to know if I could pull stats on
> the number of reads and writes for tables and how many times a package and a
> function in a package is called by day. The tables weren't a problem; I've
> already written that script and given my VP the results. What I need to
> know:
>
> 1) Is it possible to get stats on how many times a package is used? If
> yes, is it possible to break it down by day?
> 2) Is it possible to get stats on how many times a function within a
> package is used? If yes, is it possible to break it down by day?
>
> Thanks for any help you can give me, even if the answer is "it isn't
> possible".
>
> --
> Sandy
> Transzap, Inc.
>
Other related posts:
