Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CPU_UTILIZATION is 100%

User235837 -OracleNov 23 2011 — edited Nov 23 2011

Hi,
Iam seeing 100% cpu when ever quering the tables . can you help me how to check and clear this problem.
cpu count =1

 8185076k total,        0k used,  8185076k free,  2533012k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
30994 or11gapx  25   0  746m  41m  36m R 100.1  1.0   6:21.41 oracle
26854 or11gapx  25   0  744m  77m  72m R 98.8  1.9   4:37.08 oracle
24515 or11gapx  15   0  750m 136m 128m S  0.3  3.4   2:33.79 oracle
30619 or11gapx  15   0  748m  55m  49m S  0.3  1.4   0:03.12 oracle
31468 or11gapx  17   0  741m  20m  18m S  0.3  0.5   0:00.01 oracle
    1 root      15   0  2164  672  576 S  0.0  0.0   0:07.34 init
    2 root      RT  -5     0    0    0 S  0.0  0.0   0:26.34 migration/0
    3 root      34  19     0    0    0 S  0.0  0.0   0:00.48 ksoftirqd/0

Thank you,

Edited by: 838982 on Nov 23, 2011 2:05 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 21 2011

Added on Nov 23 2011

#general-database-discussions

7 comments

105 views