Re: OEL 5.2 Oracle 10g database and swap

From: Karl Arao <karlarao_at_gmail.com>
Date: Thu, 14 May 2009 11:02:58 +0800
Message-ID: <12ee65600905132002k366126a4lc7fb41fd9a8d917b_at_mail.gmail.com>

My client is running PeopleSoft on single instance database on RHEL4 with 20+GB of Physical Memory with 4 dual core CPUs. When it does payroll processing it does lots of DMLs, and we can see using NMON that "there are parts" of the batch run that the SWAP is being used more than the physical memory..So I believe it is unavoidable to use SWAP.
And RedHat already defined the "recommended partitioning scheme"...

• Karl Arao karlarao.wordpress.com

On Thu, May 14, 2009 at 7:48 AM, 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 Wed May 13 2009 - 22:02:58 CDT