LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (https://www.linuxquestions.org/questions/linux-software-2/)
-   -   RAM Utilization in ORACAL Database server. (https://www.linuxquestions.org/questions/linux-software-2/ram-utilization-in-oracal-database-server-867406/)

LINUXQueAns 03-09-2011 03:46 AM

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.

mesiol 03-09-2011 04:26 AM

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.

LINUXQueAns 03-09-2011 04:34 AM

as top command showing 96% of RAM utilization. i want to dicrease the RAM utilization.

mesiol 03-09-2011 04:53 AM

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.

salasi 03-09-2011 02:44 PM

Quote:

Originally Posted by LINUXQueAns (Post 4283942)
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?


All times are GMT -5. The time now is 04:02 PM.