Home » RDBMS Server » Performance Tuning » Urgent:How to find long running query in Oracle
Urgent:How to find long running query in Oracle [message #65977] Mon, 14 February 2005 21:08 Go to next message
Mounesh S.P.
Messages: 1
Registered: February 2005
Junior Member
How to Find long Running query in Oracle

Thanks in advance,

Mounesh S.P.
DBA

Report message to a moderator

Re: Urgent:How to find long running query in Oracle [message #65987 is a reply to message #65977] Wed, 16 February 2005 05:33 Go to previous message
Frank Naude
Messages: 4596
Registered: April 1998
Senior Member
Use something like this:

SELECT *
  FROM (SELECT sql_text, elapsed_time AS "Elapsed time (in microseconds)"
          FROM sys.v_$sqlarea
         ORDER BY elapsed_time DESC)
 WHERE rownum < 11
/


Best regards.

Frank

Report message to a moderator

Previous Topic: Performance Tuning.very critical
Next Topic: get proc and package names
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jul 20 13:45:53 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.