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.