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: Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Thu, 28 Oct 2004 15:57:27 -0400
Message-Id: <41814F27.000001.01844@DAZA-MGEJCA5J7T>


You can use wait events too,
Oracle wait interface a practical guide to performance diagnostics tuning from richmond shee has a good example  

Juan Carlos Reyes Pacheco
OCP
-------Original Message-------
 

From: ryan_gaffuri_at_comcast.net
Date: 10/28/04 11:50:11
To: cspabba_at_hotmail.com; oracle-l_at_freelists.org Cc: Chandra Pabba
Subject: 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
--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 28 2004 - 15:44:30 CDT

Original text of this message

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