dbms_profiler should help with your requirement. you may not be able to get the kind of granularity you want unless you fire the procedures one at a time and look at trace files.
this sounds like something coming down from management....
95% of performance problems with stored code is either due to
- bad query
- running a query 100,000 times when it should be run once.
you can probably use dbms_profiler to figure out was is taking the longest and tune from there.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 28 2004 - 10:41:41 CDT
