| |
GeekInterview.com > Interview Questions > Oracle > General
| Print | |
Question: Database Running Slow
Answer: 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? |
| August 08, 2008 23:35:16 |
#1 |
| kven_sat |
Member Since: June 2008 Total Comments: 1 |
RE: Database Running Slow
|
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 |
| |
Back To Question | |
