Solved

Oracle Enterprise Linux swap size

Posted on 2010-09-23
9
1,180 Views
Last Modified: 2012-05-10
Guys

I need some clarification I have been given a brand new server to install OEL 5.5 this server will hold a DR solution for the oracle 10g rac databases.

The system which is 64bit  has 128gb of RAM with a local harddisk = 146gb

From what I understand to determine the swap size if there is more than 8gb of ram which there is you use the formual 0.75 times the size of ram this = 96gb

Is this right am I to allocate 96gb of my 146gb harddisk to swap space

Any Ideas on this

Regards
0
Comment
Question by:DarrenJackson
  • 4
  • 3
  • 2
9 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33745380
Strange config you have...  Never seen a setup where ram almost equaled disk space...

In the old days, you wanted swap to equal ram.  Take a look at the following link.  Oracle Linux is based on RedHat (at least it used to be):

http://www.walkernews.net/2010/05/02/red-hat-enterprise-linux-swap-size-recommendation/
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 33745390
ohh.... missed 'local disk'. saw it as soon as I clicked 'submit'.
0
 
LVL 2

Expert Comment

by:ashwin42
ID: 33747567
As this is a DR site, there "might" be a lot more DB instances on the server than on a normal installation. Since people try to cram backups for all db servers into one.

Which would rapidly use up physical memory in case the primary site does go down.

I would go with the 96GB virtual memory recommendation.

0
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 

Author Comment

by:DarrenJackson
ID: 33748991
ashwin42

You are spot on with your diagnosis this would in the event of a dr run all our DB for the entire company

just thought 96gb was exessive
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 250 total points
ID: 33749172
Then I would get bigger/more internal disk.  You'll likely fill up 146G pretty quick...  These days, it's also pretty small.

For example:  Are all the DBs ALL on the same version of Oracle?  If not, you'll likely need a couple Gig per Oracle version.
0
 

Author Comment

by:DarrenJackson
ID: 33749193
local disk space is not my concern as all db are on the SAN. so its just the local installs im just thinking jesus thats a big swap space lol
0
 
LVL 2

Accepted Solution

by:
ashwin42 earned 250 total points
ID: 33749280
I would be worried about swap space that big too. The server might just lock up due to disk I/O

The only reason I recommend that you go for 97 GB now is that it is way easier to reduce swap space than increase it later.
0
 

Author Comment

by:DarrenJackson
ID: 33749303
Im actually hoping that the OS never uses any where near that size of swap space. But if it is easier to reduce then im good with that

Thanks for the advice
0
 

Author Closing Comment

by:DarrenJackson
ID: 33749318
Thankyou
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question