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
dezign
Messages: 3
Registered: October 2008
Location: NJ
Junior Member
Hi
Is there any freeware tool to analyze the queries. Basically i want to check which query is taking long time and why.. kindly advise

Thanks
dezign
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
Littlefoot
Messages: 21131
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
TKPROF?
Re: Query Analyzer tool [message #356298 is a reply to message #356158] Thu, 30 October 2008 04:23 Go to previous message
ThomasG
Messages: 3202
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: Thu Jul 27 02:09:45 CDT 2017

Total time taken to generate the page: 0.12089 seconds