Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to find the 10 worst performing SQL statements?
On 21 Aug 2001 15:51:33 -0700, enzoweb_at_hotmail.com (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.
>
I'd think V$SQLAREA would be the first place to look? Jonathan will certainly provide some input here.
Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam
Received on Wed Aug 22 2001 - 05:27:17 CDT