Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> TOP SQL

TOP SQL

From: Seema Singh <oracledbam_at_hotmail.com>
Date: Tue, 09 Nov 2004 15:46:55 -0500
Message-ID: <BAY19-F12CGp7KPKqF700001f28@hotmail.com>


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
Received on Tue Nov 09 2004 - 14:42:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US