LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 03-09-2011, 04:46 AM   #1
LINUXQueAns
Member
 
Registered: Oct 2010
Posts: 36

Rep: Reputation: 0
RAM Utilization in ORACAL Database server.


Hi,

Oracle is installed in RHEL5.
In server RAM Utilization is more even though swap space is free.

Find the output of top command.

Cpu(s): 0.2%us, 0.1%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 4051496k total, 3903996k used, 147500k free, 276624k buffers
Swap: 8191992k total, 466996k used, 7724996k free, 2564156k cached

To Use swap space do i have to set any kernal parameter.

Plz suggest.
 
Old 03-09-2011, 05:26 AM   #2
mesiol
Member
 
Registered: Nov 2008
Location: Lower Saxony, Germany
Distribution: CentOS, RHEL, Solaris 10, AIX, HP-UX
Posts: 731

Rep: Reputation: 137Reputation: 137
Hi,

not sure what you are looking for. But swap will be used, if swap is required. So if your database server doesn't do anything (99.7% IDLE), it will not going to swap anything. Why do you want to use swap?

On the otherside, check out that your database server does NOT use swap, this will slow down all response dramaticaly.
 
Old 03-09-2011, 05:34 AM   #3
LINUXQueAns
Member
 
Registered: Oct 2010
Posts: 36

Original Poster
Rep: Reputation: 0
as top command showing 96% of RAM utilization. i want to dicrease the RAM utilization.
 
Old 03-09-2011, 05:53 AM   #4
mesiol
Member
 
Registered: Nov 2008
Location: Lower Saxony, Germany
Distribution: CentOS, RHEL, Solaris 10, AIX, HP-UX
Posts: 731

Rep: Reputation: 137Reputation: 137
Hi,

you should use forum search function and read about how Linux uses RAM, did you recognize that your system uses 2.5 GB RAM for filesystem cache?

Also you should check your Oracle shared memory configuration and the init file settings for SGA, PGA, shared pool and buffer cache.

If you are unsure about Oracle configuration you should read Oracle concept guide available for free on Oracle website.
 
Old 03-09-2011, 03:44 PM   #5
salasi
Senior Member
 
Registered: Jul 2007
Location: Directly above centre of the earth, UK
Distribution: SuSE, plus some hopping
Posts: 4,070

Rep: Reputation: 897Reputation: 897Reputation: 897Reputation: 897Reputation: 897Reputation: 897Reputation: 897
Quote:
Originally Posted by LINUXQueAns View Post
as top command showing 96% of RAM utilization. i want to dicrease the RAM utilization.
Unused ram is wasted ram....how much did you want to waste?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
finding rx and tx utilization of aix server manoj.linux AIX 2 09-19-2008 05:08 AM
Sending alert if CPU or RAM or Disk reaches 90% utilization dhanju Linux - Server 2 08-18-2008 11:07 AM
Swap size for a 16Gb RAM database/application server Reginald0 Linux - Server 2 04-30-2008 02:56 PM
Linux desktop GUI tool for CPU utilization and bandwidth utilization karimasif Linux - Software 4 03-03-2008 02:09 PM
Server Utilization - Slowness sijojoseph07 Linux - General 4 11-27-2006 09:22 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 08:01 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration