Re: TOP SQL
- From: Steve Rospo <srospo@xxxxxxxxxxxxx>
- To: Seema Singh <oracledbam@xxxxxxxxxxx>
- Date: Wed, 10 Nov 2004 11:41:45 -0800 (PST)
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/
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
