Hi MadeInGermany,
During the performance degradation, below was the status from top o/p
195 processes: 175 sleeping, 13 running, 1 zombie, 6 on cpu
CPU states: 0.0% idle, 78.4% user, 21.6% kernel, 0.0% iowait, 0.0% swap
Memory: 32G phys mem, 16G free mem, 70G total swap, 70G free swap
PID USERNAME LWP PRI NICE SIZE RES STATE TIME CPU COMMAND
18964 oracle 39 41 0 6389M 5488M cpu/1 2:50 15.04% oracle
19638 oracle 26 59 0 6390M 5490M run 0:27 8.58% oracle
19648 oracle 36 31 0 6418M 5516M run 0:21 5.92% oracle
19023 oracle 34 30 0 6398M 5498M run 0:37 5.88% oracle
7229 oracle 38 30 0 6427M 5514M run 234:24 5.69% oracle
6912 oracle 45 31 0 6395M 5483M cpu/16 218:04 5.31% oracle
7216 oracle 28 31 0 6430M 5517M run 232:40 5.04% oracle
19644 oracle 35 40 0 6390M 5490M cpu/17 0:24 4.74% oracle
6897 oracle 112 30 0 6392M 5479M run 236:38 4.52% oracle
3813 oracle 106 31 0 6428M 5528M run 100:11 4.43% oracle
18970 oracle 234 31 0 6398M 5499M cpu/0 1:45 4.15% oracle
19749 oracle 1 32 0 6386M 5486M run 0:00 4.05% oracle
19646 oracle 23 31 0 6405M 5505M run 0:25 3.61% oracle
18972 oracle 11 32 0 6398M 5497M run 2:18 3.61% oracle
7220 oracle 258 32 0 6468M 5555M cpu/3 113:13 3.56% oracle
So approximately, there was an 80 - 20 ratio between user% and system% of cpu utilisation. Same thing i confirmed from vmstat as well.
Thanks in advance for your suggestions based on above log.
---------- Post updated at 01:21 PM ---------- Previous update was at 12:45 PM ----------
Hi All,
In addition to this, i just wanted to know whether any of you have ever faced a performance problem in oracle DB after solaris patching ? I find this highly improbable, Just let me know your response on this .
