Home » Other » 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

Report message to a moderator

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: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
TKPROF?

Report message to a moderator

Re: Query Analyzer tool [message #356298 is a reply to message #356158] Thu, 30 October 2008 04:23 Go to previous message
ThomasG
Messages: 3212
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.

Report message to a moderator

Previous Topic: Column Names truncated in SQL Plus
Next Topic: Is iSQL*Plus part of 10g XE distribution?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 06 19:39:02 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.