Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Slowest running Database routine
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