RE: How much RAM is to much

From: CRISLER, JON A (ATTCORP) <"CRISLER,>
Date: Fri, 11 Feb 2011 18:30:19 -0500
Message-ID: <B8CFC366C968D84FB8241B6E6B0EA19A058BB521_at_misout7msgusr82.ITServices.sbc.com>

Also agree- putting aside ASM and only talking about filesystems, you need to make sure the filesystem supports direct_io. You can set it on the database and I think no error is returned if the filesystem does not support direct io.

On linux, filesystem cache behavior and swappiness can be controlled via the /etc/sysctl.conf file or sysctl commands. But I am not sure you can set an upper limit to cache size- if you can then I don't know how.  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Thursday, February 10, 2011 4:26 PM To: gajav_at_yahoo.com
Cc: Andrew Kerber; RStorey_at_dcso.nashville.org; oracle-l-freelists Subject: Re: How much RAM is to much  

On Thu, Feb 10, 2011 at 11:58 AM, Gaja Krishna Vaidyanatha <gajav_at_yahoo.com> wrote:

Andrew,  

There is nothing "off the wall" about what I said. Everyone SHOULD be using direct I/O but you will be surprised how many we encounter that still don't.  

Agreed.  

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com    

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

Received on Fri Feb 11 2011 - 17:30:19 CST