Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Warmth of objects in DB buffer cache?

Warmth of objects in DB buffer cache?

From: <jamesdickson_at_my-deja.com>
Date: Fri, 03 Nov 2000 15:03:35 GMT
Message-ID: <8tuk40$c45$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US