Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to calculate the CPU Time for a procedure

Re: How to calculate the CPU Time for a procedure

From: <ryan_gaffuri_at_comcast.net>
Date: Thu, 28 Oct 2004 15:41:16 +0000
Message-Id: <102820041541.24203.4181131C0009809300005E8B2200751150079D9A00000E09A1020E979D@comcast.net>


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
Received on Thu Oct 28 2004 - 10:41:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US