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? -- //www.freelists.org/webpage/oracle-l