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

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

RE: TOP SQL

From: Gogala, Mladen <Mladen.Gogala_at_aetn.com>
Date: Tue, 9 Nov 2004 15:56:08 -0500
Message-ID: <30462D80AA52E74698512ADCC4F7EAA317C1FD70@exchange.aetvn.com>


select user, sid, serial#,screaming,iron_maiden,misunderestimate,SQL from V$SQL_PAIN.

Databases have different tastes. Some are kinky and will take large amounts of punishment without flinching. Personally, I like my databases mauve, because they take the least RAM.

--
Mladen Gogala
A & E TV Network
Ext. 1216



> -----Original Message-----
> From: Seema Singh [mailto:oracledbam_at_hotmail.com]
> Sent: Tuesday, November 09, 2004 3:47 PM
> To: oracle-l_at_freelists.org
> Subject: TOP SQL
>
>
> Hi,
> Does any one have any good scripts to capture top 5 sql
> statement which is
> hurting to database?
-- http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 09 2004 - 14:52:00 CST

Original text of this message

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