| |
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:43:02 |
#3 |
| baala |
Member Since: August 2008 Total Comments: 4 |
RE: Changed Performance
|
Have a look into the following tables :
DBA_HIST_SQLSTAT
dba_hist_snapshot
by doing natural joins on these views for the SQL_ID, you will know about any plan changes happened.
Do corrective actions as per the findings. |
| |
Back To Question | |
