InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Why Server Process Will Not Start Searching From Mru End? |
|
Answer» If SERVER PROCESS starts searching at MRU end, there is a CHANCE that data MAY get flush from buffer cache by the IME it reaches LRU end. In that case again to fetch data, we need to do an I/O which is costly. So oracle designed its architecture that server process will search only from LRU end. If server process starts searching at MRU end, there is a chance that data may get flush from buffer cache by the ime it reaches LRU end. In that case again to fetch data, we need to do an I/O which is costly. So oracle designed its architecture that server process will search only from LRU end. |
|