2 Replies Latest reply on Sep 20, 2016 12:57 AM by 953361

    Runaway frmweb processes

    2893577

      Hi,

       

      We noticed below process in our PROD environment:

       

       

      [applprod@amrdc1ebsapp02 ~]$ ps -ef|grep 16382

      applprod 16382 17372 85 Sep08 ?        6-05:45:15 frmweb server webfile=HTTP-0,0,1,default,10.160.200.185

      applprod 20449  7159  0 13:15 pts/0    00:00:00 grep 16382

      [applprod@amrdc1ebsapp02 ~]$ ps -ef|grep 30462

      applprod 20451  7159  0 13:15 pts/0    00:00:00 grep 30462

      applprod 30462 17372 99 Sep14 ?        1-11:38:28 frmweb server webfile=HTTP-0,0,1,default,10.200.230.67

       

       

      [applprod@amrdc1ebsapp02 ~]$ top

      top - 13:15:05 up 11 days,  8:32,  2 users,  load average: 2.86, 2.93, 2.95

      Tasks: 200 total,   3 running, 197 sleeping,   0 stopped,   0 zombie

      Cpu(s): 40.3%us,  0.1%sy,  0.0%ni, 59.5%id,  0.0%wa,  0.0%hi,  0.0%si,  0.1%st

      Mem:  65776404k total, 21415528k used, 44360876k free,   371548k buffers

      Swap: 67103468k total,        0k used, 67103468k free, 11166148k cached

       

        PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND

      16382 applprod  20   0  139m 102m  36m R 100.0  0.2   8985:07 frmweb

      30462 applprod  20   0  125m  88m  34m R 100.0  0.1   2138:13 frmweb

       

       

      SQL> select * from gv$session where process in ('16382','30462');

       

      no rows selected

       

      SQL>  select * from gv$process where pid in ('16382','30462');

       

      no rows selected

       

      SQL>  select instance_name from gv$instance;

       

      INSTANCE_NAME

      ----------------

      PROD1

      PROD2

       

       

       

      We do not see any Unix process with that pid in gv$process and gv$session o/p.

      How to find out the details of top frmweb sessions?

      We are suspecting those to be runaway processes and those look old also (8th sep, 14th sep).

      Kindly suggest.

       

       

       

       

      Regards,

      Purnima Johari