Oracle processes consuming most of the CPU cycle
Hi,
One of my M4000 machine sar o/p is unexpected . the %sys is consuming approx 80% of cpu. can any one help how to proceed.
16:26:25 %usr %sys %wio %idle
16:26:29 5 81 0 14
16:26:33 5 76 0 19
16:26:37 5 77 0 18
16:26:41 3 83 0 13
16:26:45 5 86 0 9
Average 5 81 0 15
# prstat -a
Please wait...
PID USERNAME SIZE RSS STATE PRI NICE TIME CPU PROCESS/NLWP
5780 oracle 16G 16G CPU7 0 0 0:54:42 2.7% oracle/11
6234 oracle 16G 16G CPU29 60 0 3:45:45 2.6% oracle/14
20472 root 1880K 1432K CPU11 0 0 0:00:13 1.4% sar/1
13823 oracle 16G 16G CPU6 0 0 16:43:32 1.3% oracle/1
3910 oracle 16G 16G sleep 23 0 0:15:14 1.3% oracle/258
13740 oracle 36M 16M sleep 0 0 60:53:47 1.0% tnslsnr/3
13876 oracle 16G 16G sleep 59 0 0:10:15 0.8% oracle/258
9731 oracle 16G 16G sleep 33 0 0:33:09 0.3% oracle/1
17764 oracle 16G 16G sleep 59 0 0:00:06 0.2% oracle/1
20526 oracle 16G 16G sleep 59 0 0:00:01 0.1% oracle/1
1 root 2920K 1560K sleep 49 0 39:37:18 0.1% init/1