Logo Background

Detect Oracle Memory Hunger Process

  • By on January 7, 2010 | 2 Comments

    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>;
    Previous
    Next
    » ProxyPass And ProxyPassReverse Configuration
  1. #1 Apps Monitor
    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.

    Post ReplyPost Reply
  1. #2 Chandran
    January 20, 2010 12:45 am

    No wonder I found my f60webmx consume high memory and the session does not terminate upon exit. Thanks for the advice.

    Post ReplyPost Reply
Leave a Comment