cancel
Showing results for 
Search instead for 
Did you mean: 

virtual memory paging

prakash singh
Occasional Contributor

virtual memory paging

hi friend,
i m using database oracle 10G with RAC running on 2 instances on hp ux 11iv2 environment. This given message i m getting on one instance. how can i solve this problem.
"Significant virtual memory paging was detected on the host operating system."

thanx
6 REPLIES
Marco A.
Esteemed Contributor

Re: virtual memory paging

Hello ,

Is that a dedicated server for oracle, or does it has another big process like ISS?

Check your sga_max_size, sga_target, and your pga_aggregate_target that could be giving that error.

Please advice,

Rgds
Just unplug and plug in again ....
Danny Petterson - DK
Trusted Contributor

Re: virtual memory paging

Hi!

Try to use top, vmstat, etc. to find what is using all the ressources on the system. Is it an error you have recieved all the time this particular instance has been running?

Greetings
Danny
Rita C Workman
Honored Contributor

Re: virtual memory paging

How much physical memory do you have onthis box ? It is quite possible, especially with Oracle 10, that you might need to increase it.

Otherwise, follow the advice above, and check what else is eating up the resources on this box.

Rgrds,
Rita
gigiz
Valued Contributor

Re: virtual memory paging

check yor system performance with:
sar -w
vmstat
swapinfo
glance
then attach your result for analize ti ...
Steven E. Protter
Exalted Contributor

Re: virtual memory paging

Shalom,

Oracle's getting pretty good at detecting these probems.

Use vmstat or http://www.hpux.ws/system.perf.sh to identify the problem.

Then buy some memory or tune oracle SGA to use a lot less memory.

Paging is never a good thing and the only fix is more RAM.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Bill Hassell
Honored Contributor

Re: virtual memory paging

The simplest verification is to run vmstat when the system is quite busy. Look at the "po" column (page out). One digit (ie, 0-9) is OK, two digits (10-99) is not too good, and 3 digits or more is horrible. If you are running two instances with 2Gb of RAM, your performance is guaranteed to be pitiful for more than a couple of users. You should have about 4-8Gb per instance, double or triple that value for high performance. But you will likely need additional processors to take advantage of the additional RAM.


Bill Hassell, sysadmin