| > |
|
Oracle will read in parts of what it needs into the buffer cache to satisfy the query, then clear out those buffers to read in more of what it needs. The process may repeat until the query is done processing. The smaller the buffer cache, the more this has to happen, and your queries may run noticeably slower.
|
|