Re: Obtain stats on packages and functions within packages

From: rjamya <rjamya_at_gmail.com>
Date: Tue, 1 Feb 2011 10:08:55 -0500
Message-ID: <AANLkTikGeipMD4x9F2eBFFDtq+UqHry0rwF88dVNDsc3_at_mail.gmail.com>



How about just turning on dbms_profiler for all user sessions for few days (can be done via login trigger on specific schemas). Then you can scan through those profiler tables and mine data you your (management's) hearts content? this would capture all plsql code calls (you probably should sys/system etc) and one time you may need to recompile plsql objects if needed.

Just a thought, btw you will encounter some slowness and will need to keep an eye on the tablespace where profiler tables are kept but it should work and might be a bit more convenient than some of the other mechanisms suggested.

Raj

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 01 2011 - 09:08:55 CST

Original text of this message