| |
GeekInterview.com > Interview Questions > Oracle > Database Administration
| Print | |
Question: Changed Performance
Answer: When yesterday developer gives the following command:
select count(*) from [table name]
it gives the output within minutes, today the same command takes hours? What will you check? |
| August 08, 2008 02:35:52 |
#2 |
| baala |
Member Since: August 2008 Total Comments: 4 |
RE: Changed Performance
|
| Probably there occured a plan flip, look for changes in the plan using the AWR views. |
| |
Back To Question | |
