Re: TOP SQL

From: Steve Rospo <srospo_at_watchmark.com>
Date: Wed, 10 Nov 2004 11:41:45 -0800 (PST)
Message-ID: <Pine.GSO.4.44.0411101140160.19068-100000@sapphire.wa.watchmark.com>

Look for expensive_sql.sql (most disk reads) and suspicious_sql.sql (most buffer gets) on Steve Adams' ixora.com.au.

S-

On Tue, 9 Nov 2004, Seema Singh wrote:

> Hi,
> Does any one have any good scripts to capture top 5 sql statement which is
> hurting to database?
>
> The selection of those top 5 sql would be either more IO/more CPU
> usgae/spining sql etc.
> thanks
>
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today - it's FREE!
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 10 2004 - 13:39:24 CST