Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Usenet ->
c.d.o.server ->
2 Buffer Cache Questions
2 Buffer Cache Questions
- If you select * from a table, shouldn't that load the whole table
into the database buffer cache, provided it fits. I have a script that
I found that shows me what's in the cache, but I cannot seem to make
100% of a tables block fit. I could not seem to find the answer in the
concepts manual.
- What's does system put in the buffer cache. We notice that after
starting the db, system will occupy a good chunk of the buffer cache,
but that will start to decrease as various queries are run and the data
begins to fill the cache.
Received on Tue May 03 2005 - 16:19:50 CDT
Original text of this message