I got a #1 performance issue in EM adviser as following:
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.
The machine that Oracle server is running on has more than 2GB of RAM and SGA related parameters are: sga_max_size = 900 MB and sga_target = 800 MB.
I went to windows taskmanager and found these properties for oracle.exe process:
- current memory usage = 883 MB
- peak memory usage = 942 MB
- VM size = 904 MB
- paged pool = 116 KB
- number of page faults = 23,821,676 !!!
OK, I guess I should give more VM space for oracle at first place. Am I right?
Is there any other meaningful fact you can extract from these data?
Your help will be so appreciated friends.