Re: Obtain stats on packages and functions within packages
- From: Gaja Krishna Vaidyanatha <gajav@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 26 Jan 2011 14:00:45 -0800 (PST)
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:
