RE: OEL 5.2 Oracle 10g database and swap
Date: Wed, 13 May 2009 19:48:15 -0400
Let's assume that it crashes. What makes you think it has anything to do with swap? I'm just curious.
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
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 Testa, Oracle Certified Professional
Interested in helping out your marriage?
Ask me about "Weekend to Remember"
Dec 11-13, 2009 here in Columbus.
kathy duret <katpopins21_at_yahoo.com>
05/13/2009 03:10 PM
OEL 5.2 Oracle 10g database and swap
I had always used the rule of thumb for putting 1.5 swap to RAM on Linux
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?
KathyReceived on Wed May 13 2009 - 18:48:15 CDT