Mailing List
Home
Forum Home
Linux - General Red Hat Linux discussion list
Installation - Getting started with Red Hat Linux
Enterprise Linux 3 - Discussion of Red Hat Enterprise Linux 3 (Taroon)
Red Hat Linux 9 - Discussion of Red Hat Linux 9 (Shrike)
Red Hat Linux 7.2 - Discussion of Red Hat Linux 7.2 (Enigma)
Red Hat Linux 7.3 - Discussion of Red Hat Linux 7.3 (Valhalla)
Apache Web Server
Oracle database, Microsoft SQL server ...
Subjects
• application/x mplayer2 plugin
• RPM error: db4 error(16) from dbenv >remove: Device or resource
   busy
• Command stream end of file while reading
• X Windows problem (xauth)
• Upgrading openoffice 1 1 rpm
• FTP: connection refused
• FTP: connection refused
• mount: /dev/cdrom: is not a valid block device
• Dell Precision 650, RedHat 9, no sound
• how to trace the cause resulting in the crash of bind server
• Virus on the list
• UNINSTALL RPM MYSQL
• usb pen drives: mounting as a user
• broadcom network interface
• make mrproper
• sendmail configuration on redhat
• Couldn 't open PID file /var/run/named/named pid Permission denied
• Promise 378 controller
• kernel 2 6 and /dev/sound/mixer not found
• Problem using up2date
• mrtg step by step howto/configuration for a newbie?
• Compiling and Installing Kernel 2 6
• Can 't locate module ppp0, can 't locate module ppp compress 21
• HOW I CAN MAKE BOOTABLE FLOPPY DISKET
• Lotus Notes under Wine
• /etc/security/limits conf question
• Intel E/1000 driver
• Command stream end of file while reading
• rpm database corrupt
• qla2300 modules
 
swap size recommendation for large DB server

swap size recommendation for large DB server

2006-08-11       - By Clark, Patricia

 Back
Reply:     1     2     3  


-- --Original Message-- --
From: taroon-list-bounces@(protected)
[mailto:taroon-list-bounces@(protected)] On Behalf Of Stanley, Jon
Sent: Friday, August 11, 2006 7:51 AM
To: taroon-list@(protected)
Subject: swap size recommendation for large DB server

I have a relatively large database server (quad Opteron with 32GB RAM).
Oracle is having some type of performance issue on this host.

Oracle support is saying that we need swap that's 2x physical RAM.  With
todays systems that have huge amounts of memory, that's just not
feasible, practical, or desirable from a SA's standpoint.

What I'm looking for is some BCP about how to size swap with large
amounts of RAM.  I know that it doesn't make sense, but I need something
to throw in Oracle's face to say their recommendation is bogus.

BTW, the system isn't even touching swap.

--
Typical answer from a first line support person and it's incorrect.
Recommendations are 2X RAM upto 2 GB of real memory + 1X RAM after that.
It is also recommended that there are multiple SWAP files (partitions)
when they get fairly large...I've seen 2 GB size recommendations.  

That being said, swap is not the issue with oracle.  The amount of
shared memory that is set up in /etc/sysctl.conf in addition to the
parameters that your DBA(s) use in their instances are more important.
The oracle installation doco for linux has the recommendations for
/etc/sysctl.conf .  The rest is up to your DBAs. Unfortunately, our
linux installs are rather small DBs so I don't have more specifics.  I
do know that our big production DB on Sun ran into these types of issues
because Sun defaults to 8 GB of process memory allocation which required
OS parameter tweaks, followed by DBA parameter tweaks.


Patti Clark
Unix System Administrator - RHCT
Office of Scientific and Technical Information


--
Taroon-list mailing list
Taroon-list@(protected)
https://www.redhat.com/mailman/listinfo/taroon-list