Re: How to calculate the CPU Time for a procedure

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 

1. bad query
2. 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

Other related posts: