Re: pinning objects in cache

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Sun, 20 Nov 2005 02:19:02 +0100
Message-ID: <437fcf07$0$23621$ba620e4c@news.skynet.be>

"chris b" <chris.brown_at_providenthims.co.uk> wrote in message news:1132244832.176913.24050_at_o13g2000cwo.googlegroups.com...
> Thanks for the comments
> oracle version is 8.1.7.4
> table is 570m
>
> My initial interest in pinning was because there is a full table scan
> query running a couple of thousand times
> / causing 5 million disk reads ...I just thought it might be a solution
>
> regards
> Chris B
>
> ps the code is caused by oledb interpreting our insert commands
>

Have you tried ALTER TABLE <...> CACHE ?

This should leave the blocks longer in the "hot" part of the buffer cache.

Matthias Received on Sat Nov 19 2005 - 19:19:02 CST