| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Warmth of objects in DB buffer cache?
Querying v$bh I know which objects are in my default DB buffer cache at a given point in time. I want to put the most frequently-accessed objects into a new "keep" buffer cache. How can I tell which of the objects are the frequently accessed ones?
The only way I can think of is to query v$bh at regular intervals and see which objects consistently show up there, therefore are not getting aged out. However I would have thought that there would be a statistic to tell me how many times each buffer had been hit since it was originally read from disk - is there any such?
Thanks in advance,
James
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Nov 03 2000 - 09:03:35 CST
![]() |
![]() |