Home » SQL & PL/SQL » Client Tools » Query Analyzer tool (Oracle 10g, Win Xp)
Query Analyzer tool [message #356104] Wed, 29 October 2008 09:18 Go to next message
Messages: 3
Registered: October 2008
Location: NJ
Junior Member
Is there any freeware tool to analyze the queries. Basically i want to check which query is taking long time and why.. kindly advise

Re: Query Analyzer tool [message #356158 is a reply to message #356104] Wed, 29 October 2008 15:20 Go to previous messageGo to next message
Messages: 20847
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Re: Query Analyzer tool [message #356298 is a reply to message #356158] Thu, 30 October 2008 04:23 Go to previous message
Messages: 3186
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
The v$sqlarea view is also nice, to see what has kept the database busy the most since the last restart.
Previous Topic: Column Names truncated in SQL Plus
Next Topic: Is iSQL*Plus part of 10g XE distribution?
Goto Forum:

Current Time: Wed Oct 26 04:45:01 CDT 2016

Total time taken to generate the page: 0.13532 seconds