Swap/Memory/Oracle issue

[A. Clay Stephenson]

Hi Joe:

I rather doubt that Enterprise Manager locking up has anything to do with memory. Last year, one of our DBA's attended the Enterprise Manager class and had to be given a full refund because the thing kept locking-up/crashing in class. Everybody's was doing it; even those on different servers. I would check for the latest patches for OEM before doing anything else. As others have mentioned, 4GB is not a lot for what you are trying to do; if you think that memory is killing you simply add some filesystem swap at low priority
to give yourself some virtual memory headroom. It may not be fast if swapping but it shouldn't hang the program.


Regards, Clay

[Dennis J Robinson]

Your oracle database server should not be allowed to swap.

Have the Oracle dba's downsize their Oracle buffer cache so that the total memory utilization is no more than 80%.

It is OK to configure the multiple swap area's.