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: Steve Howard <stevedhoward_at_gmail.com>
Date: 11 May 2006 10:32:18 -0700
Message-ID: <1147368738.679642.19910@j73g2000cwa.googlegroups.com>

Mladen Gogala wrote:
> 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

Fair enough. I just think starting at v$sql will point you pretty quickly to the low hanging fruit, without the additional overhead of a 10046 trace. Once he finds something slow, then he can turn on trace for the sessions that run that SQL.

Regards,

Steve Received on Thu May 11 2006 - 12:32:18 CDT

Original text of this message

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