RAM Utilization in ORACAL Database server.

LINUXQueAns · 03-09-2011, 03:46 AM

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

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?