Re: pinning objects in cache

chris b wrote:
> 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

If it is runnning that often the blocks are likely already in memory. Have you checked?

But perhaps what should be asked is why is it running an FTE? Is it required? Why? Is there a workaround? Can the result set be staged?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)