Re: How do I get a list of most resource consuming SQL statements

From: Vitaliy Mogilevskiy <vit100gain_at_earthlink.net>
Date: Tue, 13 Apr 1999 15:31:10 -0700
Message-ID: <3713C5AE.FD314174@earthlink.net>

Check my web page, I have script that will do it

+--------------------------------------------------------------------------+

| Vitaliy Mogilevskiy
| Senior Consultant
| CORE Technology Group, Inc.
| E-mail:    vit100gain_at_earthlink.net
| Web Page:  http://home.earthlink.net/~vit100gain/index.html

|            *** Free DBA Script Library at my Web Page ***
+--------------------------------------------------------------------------+

Cor Kooij wrote:

> I'm looking for a way to find out which SQL-statements consumed the most
> resources in terms of CPU and/or memory, the last hours/day/week.
> A top 10 or whatever number of SQL-statements would enable me to focus
> on the worst cases first.

-- Received on Tue Apr 13 1999 - 17:31:10 CDT