| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: database server CPU is 100%
This is a multi-part message in MIME format.
------=_NextPart_000_002F_01BFF319.F25A0120 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
I'd try using a tool like Quest Software's SQL Lab and see if you aren't = having problems with many different applications and/or dynamic queries = using SQL statements that are just slightly different from each other. =
This prevents code re-use (SQL Statements), causes the database to have = to reparse the 'new' (different) SQL Statements, and most of all causes = the contents of the SQL Cache to 'thrash'. There is good reason to have =ALL of the 'Production Code' for each Instance analyzed/approved by a = DBA. Michael Rose
mmrose_at_home.com
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.=20
=20
Has anyone encountered this? Are they any specific things should I be =
looking for. Any pointers would be appreciated.
Thx
Gautam=20
------=_NextPart_000_002F_01BFF319.F25A0120 Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I'd try using a tool like Quest =
Software's=20
<STRONG>SQL Lab </STRONG>and see if you aren't having problems with many =
different applications and/or dynamic queries using SQL statements that =
are just=20
slightly different from each other. This prevents code re-use (SQL =
Statements),=20
causes the database to have to reparse the 'new' (different) SQL =
Statements, and=20
most of all causes the contents of the <STRONG>SQL Cache</STRONG> to =
'thrash'.=20
There is good reason to have ALL of the 'Production Code' for each=20
<STRONG>Instance</STRONG> analyzed/approved by a DBA.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Michael Rose</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2><A=20
href=3D"mailto:mmrose_at_home.com">mmrose_at_home.com</A></FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A href=3D"mailto:Gautam_Reddy_at_Dell.com"=20
title=3DGautam_Reddy_at_Dell.com>Gautam_Reddy_at_Dell.com</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
href=3D"mailto:ORACLE-L_at_fatcity.com"=20
title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> =
</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Friday, July 21, 2000 =
12:03=20
PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> database server CPU is =
100%</DIV>
<DIV><BR></DIV>
<DIV><FONT color=3D#800000 face=3D"Comic Sans MS" size=3D2><SPAN=20
class=3D177033714-21072000>We have a v7.3.4 production OLTP database =
on 4=20
CPU NT 4.0 server. The last 2 weeks the CPU is pegged to =
100% at=20
least 80% of the time. Nothing has changed in the last two weeks. We =
don't=20
have any long running jobs. We have taken system state dumps and found =
nothing=20
there too(done this with the help of oracle support). We have =
flushed=20
the share pool couple of times to see if it was related to parsing =
problems.=20
The minute we flush the CPU usage comes down to 50-60% but goes back =
up to=20
100% within 15min. Our NT admins don't see any problems with the =
server.=20
</SPAN></FONT></DIV>
<DIV><FONT color=3D#800000 face=3D"Comic Sans MS" size=3D2><SPAN=20
class=3D177033714-21072000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#800000 face=3D"Comic Sans MS" size=3D2><SPAN=20
class=3D177033714-21072000>Has anyone encountered this? Are they=20
any specific things should I be looking for. Any =
pointers=20
would be appreciated.</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=3D#800000 face=3D"Comic Sans MS" =
size=3D2>Thx</FONT></DIV>
<DIV><FONT face=3D"Comic Sans MS" size=3D2><STRONG>Gautam =
Received on Fri Jul 21 2000 - 12:45:35 CDT
 |
 |