RE: OEL 5.2 Oracle 10g database and swap

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Wed, 13 May 2009 19:48:15 -0400
Message-ID: <0517F139F5AD4C639A900749E53BD281_at_rsiz.com>

Let's assume that it crashes. What makes you think it has anything to do with swap? I'm just curious.  

Regards,  

mwf  

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Smith
Sent: Wednesday, May 13, 2009 5:12 PM
To: oracle-l_at_freelists.org
Subject: Fwd: OEL 5.2 Oracle 10g database and swap  

left off the list the first time.

• Forwarded message ---------- From: John Smith <john40855_at_gmail.com> Date: Wed, May 13, 2009 at 2:39 PM Subject: Re: OEL 5.2 Oracle 10g database and swap To: TESTAJ3_at_nationwide.com

I would say use the recommended number. You might try this experiment on a test server only, not production):

set the swap to 2G (when you have say, 64G RAM). Set the SGA_TARGET to 20G or so. Set lock_sga and/or pre_page_sga to true, and start the database and see what happens. I have heard it can crash the server.  

On Wed, May 13, 2009 at 2:12 PM, <TESTAJ3_at_nationwide.com> wrote:

We did in our pilot and with 64G of ram we just went with 2G of swap, now this is not production as we've not got that ironed out yet.

joe

---

Joe Testa, Oracle Certified Professional
(Work) 614-677-1668
(Cell) 614-312-6715

Interested in helping out your marriage? Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.

From:

kathy duret <katpopins21_at_yahoo.com>

To:

oracle-l_at_freelists.org

Date:

05/13/2009 03:10 PM

Subject:

OEL 5.2 Oracle 10g database and swap

Sent by:

oracle-l-bounce_at_freelists.org  

---

I had always used the rule of thumb for putting 1.5 swap to RAM on Linux Servers
We are installing OEL 5.2, 10G 3 node RAC cluster with 64G of RAM.   

When I looked at the Metalink install doc 421038.1 it says:   

Between 1024 MB and 2048 MB

1.5 times the size of RAM

Between 2049 MB and 8192 MB

Equal to the size of RAM

More than 8192 MB

0.75 times the size of RAM   

Has anyone installed this and what are you using.   

Have you also used hugepages?   

Thanks,   

Kathy         

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

Received on Wed May 13 2009 - 18:48:15 CDT