hi everyone,
i have a question i was asked in an interview and i didnt know how to answer it. here is the question:
<pre>
assuming that today users are running query in oracle and everything is running fast. the user goes home and next day they ran same or similar query and the queires are taking long to execute.
what can the problem be?
</pre>
i tried answering by data volume may have change, stats are out of date, change in on one of the parameter in init file and so on. the interviewer told me that nothing has changed at all.
the database is the same as of yesterday and nobody touch it. he then follow
<pre>
assume everyone in the company went of vacation and before they log off all their queries were running fast. when they all log off, noone touch the database. when they came back and reran queries,
they were running slow. what could be the problem?
</pre>
i couldnt answer. anybody wants to give any ideas on this?