About O/S file system cache in any Linux OS: RHEL/OEL
From: sundar mahadevan <sundarmahadevan82_at_gmail.com>
Date: Sun, 1 Nov 2009 01:48:16 -0400
Message-ID: <7d81ec570910312248s4498b152jef8f60a9566edf9e_at_mail.gmail.com>
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
Date: Sun, 1 Nov 2009 01:48:16 -0400
Message-ID: <7d81ec570910312248s4498b152jef8f60a9566edf9e_at_mail.gmail.com>
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Nov 01 2009 - 00:48:16 CDT