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

Home -> Community -> Usenet -> c.d.o.server -> Re: Slowest running Database routine

Re: Slowest running Database routine

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Wed, 10 May 2006 23:01:21 GMT
Message-Id: <pan.2006.05.10.23.01.21.719909@sbcglobal.net>


On Wed, 10 May 2006 09:51:10 -0700, stevedhoward wrote:

> Look at elapsed_time in v$sql. This will only point out sql, which you
> could tie back to procedures.

How would he do that? In my opinion, 10046 trace is much more practical.

-- 
http://www.mgogala.com
Received on Wed May 10 2006 - 18:01:21 CDT

Original text of this message

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