Re: Warmth of objects in DB buffer cache?

jamesdickson_at_my-deja.com wrote:
>
> 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.

Column TCH on the newer versions of Oracle will assist with this..

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Early to bed and early to rise, 
 makes a man healthy, wealthy and wise." - some dead guy