If your database is running slow from last 2 hrs.you can't wait for Statspack report generation. What will be your first step to handle the problem? Where can be the problem?

ramavenky

 Profile Answers by ramavenky Questions by ramavenky

• Feb 19th, 2010

Check for Buffer Cache SizeCheck For Poor SQL Query

kven_sat

 Profile Answers by kven_sat Questions by kven_sat

• Aug 8th, 2008

Remove unnecessary joins,  too much normalization can effect query to perform slow, excess use of cursors, indexes, procedures or temporary tables may effect on query to perform slow. If my answer is wrong please correct me

Answer Question  Select Best Answer