We are member of DB Team, and are investigating some performance issues on Database Server.
My current question is regarding Virtual Memory Paging, how can i determine what is in RAM, how to calculate what is composed of total RAM utilization and what is composed of total SWAP utilization?
Can i see what was the status of RAM/SWAP in some particular point in time?
What tools/techniques are available for Diagnosing SWAP Space?
Our System Config
SWAP 32G (Previously was 16G 2 Months before)
HDD Direct Attached and 50% usage
Let me add, 2 months back, our Database started crashing, that time we had 16G SWAP, but when we created File based SWAP of 16G, it Database started working Normally without any issues.
Recommendations we got from Oracle Perspective.
Significant virtual memory paging was detected on the host operating system.
RECOMMENDATION 1: Host Configuration, 100% benefit (38349 seconds)
ACTION: Host operating system was experiencing significant paging but no particular root cause could be detected. Investigate processes that do not belong to this instance running on the host that are consuming significant amount of virtual memory. Also consider adding more physical memory to the host.