Java process takes 100% CPU usage in Oracle Form server

[Deepu Chakravarty]

We are running oracle applications 11i (11.5.9) version in dual node setup. Database node is in rp5430 server(5Gb RAM) and forms server is in rp2470 server (4Gb RAM). Top process in Forms server is showing 100% CPU usage all the time. Like following:
System: testdev Mon Nov 1 11:12:04 2004
Load averages: 1.20, 1.34, 1.30
243 processes: 215 sleeping, 28 running
Cpu states:
CPU LOAD USER NICE SYS IDLE BLOCK SWAIT INTR SSYS
0 1.70 46.3% 0.0% 26.5% 27.1% 0.0% 0.0% 0.0% 0.0%
1 0.70 39.7% 0.0% 14.9% 45.4% 0.0% 0.0% 0.0% 0.0%
--- ---- ----- ----- ----- ----- ----- ----- ----- -----
avg 1.20 43.0% 0.0% 20.8% 36.2% 0.0% 0.0% 0.0% 0.0%

Memory: 2235164K (1068492K) real, 4232004K (2784880K) virtual, 457328K free Page# 1/23

CPU TTY PID USERNAME PRI NI SIZE RES STATE TIME %WCPU %CPU COMMAND
1 ? 9173 applprod 152 20 528M 149M run 339:07 103.11 102.93 java

How to overcome this high CPU usage ? Is this high CPU usage is anything do with the performance issue ?

[Steven E. Protter]

That is commonm in oracle forms/reports servers that are swapping a lot.

swapinfo -tam

or use vmstat, tool of choice.

If you are actively paging, you need memory to solve this problem.

SEP

[Deepu Chakravarty]

# vmstat 5 5
procs memory page faults cpu
r b w avm free re at pi po fr de sr in sy cs us sy id
8 0 0 798869 32948 27 7 1 0 0 0 2 3371 42102 2205 43 16 41
8 0 0 798869 32825 19 3 1 0 0 0 0 584 45806 2098 47 16 38
6 0 0 782290 32371 20 8 0 0 0 0 0 538 47097 2560 42 18 40
6 0 0 782290 29836 23 44 109 0 0 0 0 712 45238 2694 57 19 25
8 0 0 747072 28980 37 22 36 0 0 0 0 685 41696 2240 53 16 32

[RAC_1]

This happened to me. Happens with Java.
First thing to check.

1. Java patches. (www.hp.com.java)
Check which version you are using, do you have all required patches or not.

2. With Java, you can control few options - initiail heap size, max heap size etc java -x options. Set them accordingly.

Hope this helps.