Re: os cache vs. db cache

Chris,

I suspect we've got a mix; some of the processes may be (accidentally) well served by the current settings, while others are not. Plus we've got some odd schema combinations sharing instances so I may need to move a few things around before I can test, much less make any changes. Typical stuff I imagine for systems that have been hanging around for a while.

We're getting ready to go through another round of database and application upgrades and new servers are coming in, so if I can figure out what I want to try, I have a reasonable chance of getting to at least test it while we've got extra environments running.

cheers ... Robyn

On 7/10/07, Chris Dunscombe <chris_at_thedunscombes.f2s.com> wrote:
>
> Hi,
>
> One situation I've experienced was a smallish (< 250GB) third-party online
> operational database on Solaris where the OS cache acted as a cache for
> Full
> Table scans of tables around the 100-300 MB size. This worked well
> although it
> was more by accident than design.
>
> Cheers,
>
> Chris
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l