RE: TOP SQL

From: "Gogala, Mladen" <Mladen.Gogala@xxxxxxxx>
To: "'oracledbam@xxxxxxxxxxx'" <oracledbam@xxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
Date: Tue, 9 Nov 2004 15:56:08 -0500

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@xxxxxxxxxxx] 
> Sent: Tuesday, November 09, 2004 3:47 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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

RE: TOP SQL

Other related posts: