Re: How to find the 10 worst performing SQL statements?

I guess a good way to start is by looking at chapter 10(Tuning Strategies and tools) of "Expert one-on-one Oracle" by Tim Kyte. He explains how to use SQL_TRACE, TKPROF and what are things to look at. Then using DBMS_PROFILE to help in pinpointing the worst SQL statement in a procedure/package/block.

ZS

Andy wrote:

> I have been asked to find out the 10 worst performing SQL statements
> on a V816 database on Solaris.
>
> The only way I can think of doing it is to turn SQL_TRACE on
> (TIMED_STATS are already on), and run tkprofs against the resulting
> trace files at the end of each day. Then grep the results to pick out
> the stat I want and filter through them.
>
> Without installing Stats pack, is this the best way?
>
> Also, what should I look for - elapsed time, CPU time, or I/O?
>
> TIA,
> Andy
Received on Tue Aug 21 2001 - 19:04:33 CDT