Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> database server CPU is 100%

database server CPU is 100%

From: <Gautam_Reddy_at_Dell.com>
Date: Fri, 21 Jul 2000 09:58:22 -0500
Message-Id: <10565.112651@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFF324.1F8C0CEC
Content-Type: text/plain;

        charset="iso-8859-1"

We have a v7.3.4 production OLTP database on 4 CPU NT 4.0 server. The last 2 weeks the CPU is pegged to 100% at least 80% of the time. Nothing has changed in the last two weeks. We don't have any long running jobs. We have taken system state dumps and found nothing there too(done this with the help of oracle support). We have flushed the share pool couple of times to see if it was related to parsing problems. The minute we flush the CPU usage comes down to 50-60% but goes back up to 100% within 15min. Our NT admins don't see any problems with the server.  

Has anyone encountered this? Are they any specific things should I be looking for. Any pointers would be appreciated.  

Thx
Gautam  

------_=_NextPart_001_01BFF324.1F8C0CEC
Content-Type: text/html;

        charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.00.2919.6307" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=177033714-21072000>We have a v7.3.4 production OLTP database on 4 CPU&nbsp; NT 4.0 server.&nbsp; The last 2 weeks the CPU is pegged to 100% at least 80% of the time. Nothing has changed in the last two weeks. We don't have any long running jobs. We have taken system state dumps and found nothing there too(done this with the help of oracle support).&nbsp; We have flushed the share pool couple of times to see if it was related to parsing problems. The minute we flush the CPU usage comes down to 50-60% but goes back up to 100% within 15min. Our NT admins don't see any problems with the server. </SPAN></FONT></DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=177033714-21072000></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2><SPAN
class=177033714-21072000>Has anyone encountered this? Are they any&nbsp;specific things should I be looking&nbsp;for.&nbsp; Any pointers would be appreciated.</SPAN></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT color=#800000 face="Comic Sans MS" size=2>Thx</FONT></DIV>
<DIV><FONT face="Comic Sans MS" size=2><STRONG>Gautam </STRONG></FONT></DIV>
<DIV>&nbsp;</DIV></BODY></HTML>
Received on Fri Jul 21 2000 - 09:58:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US