Re: OEL 5.2 Oracle 10g database and swap

From: John Smith <john40855_at_gmail.com>
Date: Thu, 14 May 2009 07:36:09 -0500
Message-ID: <a4c7620905140536l88cf9bei46718aef517d65d4_at_mail.gmail.com>

Well, in this case the error was unable to fork a process, which implies a memory problem. Then I found this blog:

http://dbakerber.wordpress.com/2008/04/18/swap-space-in-linux-and-unix/

Then I added swap space and I no longer had the problem. Might be specific to my hardware, might be another setting, but it sure looks like a problem with the swap setting to me.

On Wed, May 13, 2009 at 6:48 PM, Mark W. Farnham <mwf_at_rsiz.com> wrote:

> 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 Thu May 14 2009 - 07:36:09 CDT