Database Running Slow

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?

Questions by sanjayocp

Showing Answers 1 - 6 of 6 Answers

kven_sat

  • Aug 7th, 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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions