Message-Id: <10565.112651@fatcity.com>
From: Gautam_Reddy@Dell.com
Date: Fri, 21 Jul 2000 09:58:22 -0500
Subject: database server CPU is 100%
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"
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