Home » RDBMS Server » Performance Tuning » application performance
application performance [message #520813] Wed, 24 August 2011 17:26 Go to next message
matthew00
Messages: 7
Registered: October 2005
Junior Member
I have a third party application that had some functions running very slow and I am pretty sure it was due to SQL query.

My question is what is the best way to trace SQL had performance while running the app.

Thanks all

Report message to a moderator

Re: application performance [message #520815 is a reply to message #520813] Wed, 24 August 2011 17:51 Go to previous message
cookiemonster
Messages: 13958
Registered: September 2008
Location: Rainy Manchester
Senior Member
Use statspack or awr to find problem queries

Report message to a moderator

Previous Topic: Speed up this SQL
Next Topic: how expensive is unique versus primary key in large table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 01:45:41 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.