Detect Oracle Memory Hunger ProcessDetect Oracle Memory Hunger Process
How to detect what is the Oracle memory hunger process? Previously I did share a script on how to check the top 10 memory consumption process in Unix.
It is recommended to check the growth memory usage of your Oracle Application Server from time to time.
Top Memory Usage Checking
$ UNIX95= ps -eo vsz,ruser,pid,args | sort -rn | head -10 85796 applprod 21020 f60webmx webfile=5,1425,apps_oracle 80228 applprod 5803 f60webmx webfile=5,2443,apps_oracle 68388 applprod 27304 f60webmx webfile=5,1619,apps_oracle 65828 applprod 15211 f60webmx webfile=5,1741,apps_oracle 65444 applprod 11075 f60webmx webfile=5,264,apps_oracle 64676 applprod 20696 f60webmx webfile=5,2163,apps_oracle 62948 applprod 885 f60webmx webfile=5,2303,apps_oracle 56996 applprod 24789 f60webmx webfile=5,2458,apps_oracle 54884 applprod 18172 f60webmx webfile=5,2405,apps_oracle 54756 applprod 18077 f60webmx webfile=5,61,apps_oracle
From the output above, it seems that the Oracle form process f60webmx utilize a high amount of server memory.
Quite abnormal because the f60webmx form process should be terminated after certain time of inactivity.
Use the script as below to check on the status of f60webmx session by using the Unix PID.
Oracle Forms Session Checking
SELECT s.STATUS "Status", s.TYPE "Type", s.username "DB_User", s.osuser "Client_User", s.server "Server", s.machine "Machine", s.module "Module", s.logon_time "Connect Time", s.process "Process", p.spid, p.pid, s.SID, s.audsid, SYSDATE - (s.last_call_et / 86400) "Last_Call" FROM v$session s, v$process p WHERE s.paddr = p.addr(+) AND s.process = <replace WITH Unix PID>;
2 Comments
Leave a Comment- #2
Chandran
January 20, 2010 12:45 amNo wonder I found my f60webmx consume high memory and the session does not terminate upon exit. Thanks for the advice.
Leave a Comment
January 15, 2010 1:03 am
Use the command – adrelink.sh force=y “fnd f60webmx”
This adrelink command will rebuild the f60webmx executable, hope it can resolve your memory hunger issue.