Hi ,
We are getting alert from OEM when memory is utilized more than 94%, on check found that oracle processes are using more memory .
Need help to debug the issue , why oracle processes are utilizing more memory and is really required or tuning is required .
Please find the memory output below .
# ps aux | head -1; ps aux | sort -rn +3 | head
USER PID %CPU %MEM SZ RSS TTY STAT STIME TIME COMMAND
grid 12321220 0.0 2.0 173780 509600 - A Feb 09 14:45 /u01/app/grid/
grid 6226422 0.0 2.0 197376 533344 - A Feb 09 105:08 /u01/app/grid/
oracle 66781482 0.0 1.0 262188 204728 - A 01:24:57 0:00 ora_p01z_madev
oracle 66715916 0.0 1.0 262124 198264 - A 01:24:51 0:00 ora_p01x_madev
oracle 65339892 0.0 1.0 262828 198968 - A 23:47:58 0:00 ora_o002_madev
oracle 65208786 0.0 1.0 262124 198264 - A 01:24:51 0:00 ora_p01t_madev
oracle 64880938 0.0 1.0 262124 198264 - A 01:24:51 0:00 ora_p01u_madev
oracle 64553274 0.0 1.0 262188 204728 - A 01:24:57 0:00 ora_p01v_madev
oracle 64356824 0.0 1.0 266348 208888 - A Feb 13 0:03 ora_w00p_madev
oracle 64160146 0.0 1.0 265388 207928 - A Feb 18 0:01 ora_w00v_madev
Memory ────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────│
│ Physical PageSpace | pages/sec In Out | FileSystemCache │
│% Used 94.4% 0.4% | to Paging Space 0.0 0.0 | (numperm) 5.9% │
│% Free 5.6% 99.6% | to File System 0.0 0.5 | Process 74.3% │
│MB Used 30939.1MB 122.1MB | Page Scans 0.0 | System 14.2% │
│MB Free 1828.9MB 33669.9MB | Page Cycles 0.0 | Free 5.6% │
│Total(MB) 32768.0MB 33792.0MB | Page Steals 0.0 | ------ │
│ | Page Faults 1260.0 | Total 100.0% │
│------------------------------------------------------------ | numclient 5.9% │
│Min/Maxperm 938MB( 3%) 28144MB( 90%) <--% of RAM | maxclient 90.0% │
│Min/Maxfree 960 1088 Total Virtual 65.0GB | User 75.8% │
│Min/Maxpgahead 2 8 Accessed Virtual 25.0GB 38.5%| Pinned 19.6% │
│ | lruable pages 8005456.0
Thanks
Oracle DBA