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?
enzoweb_at_hotmail.com (Andy) writes:
> I have been asked to find out the 10 worst performing SQL statements
> on a V816 database on Solaris.
I've been using this: http://www.pobox.com/~dba/oracle/orasnap and it can point out buffer, disk and cpu-intensive sql in quite readable format.
I'm still using an old version of this utility and I had to change names of a few files included in the package, obviously this package has been developed in a machine that has case insensitive filesystem.
-- Antti Järvinen, costello_at_iki.fi "concerto for two faggots and orchestra"Received on Wed Aug 22 2001 - 03:56:59 CDT