Re: About O/S file system cache in any Linux OS: RHEL/OEL
Date: Mon, 2 Nov 2009 01:00:09 +0100
By default you dont have to do any special configuration to use Linux file system buffer cache, Linux tries to cache everything.
But filesystem buffer read is not very good idea, if you are using Linux 32 bit it is ok but if you are using 64 bit you should give more memory to db_cache_size and cache in Oracle's own cache and avoid double buffering (file system buffer and oracle data block buffer).
-- LSC On Sun, Nov 1, 2009 at 6:48 AM, sundar mahadevan < sundarmahadevan82_at_gmail.com> wrote:Received on Sun Nov 01 2009 - 18:00:09 CST
> Hi Gurus,
> I was reading through metalink to know more about db file scattered
> read on Note 223117.1 which further provided link to Note 34558.1
> One of the solutions to decreasing wait times was using O/S file
> system cache : "It can help to place files which incur frequent
> table/index scans on disks which have are buffered by an O/S file
> system cache. Often this will allow some of Oracles read requests to
> be satisfied from the OS cache rather than from a real disk IO."
> I know about the table CACHE feature that can be used to help cache
> tables that are frequently scanned within oracle.
> But how does one setup O/S file system cache. I googled about O/S file
> system cache but not with much help. Any links or thoughts are much
> appreciated. Thanks in advance.