Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: TOP SQL
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. 1216Received on Tue Nov 09 2004 - 14:52:00 CST
> -----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
![]() |
![]() |