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

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Wed, 22 Aug 2001 10:27:17 GMT
Message-ID: <3b8386a8.2937834@news>

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