| 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 message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Even I had faced similar situation(on NT), when by mistake
I forgot to terminate a loop in a test SQL script. It was=20
running in infinite loop and CPU used was 100%.=A0
=A0
=A0=A0 I did the the same thing to UNIX BOX but nothing happened
like that on UNIX. That's exactly the reason the LOVE NT so=20
much...=A0 :--((((
=A0 =A0=A0 Just Check out, similar problem might be there...... =A0
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Koivu, =
Lisa
Sent: Saturday, July 22, 2000 12:49 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: database server CPU is 100%
Mike, if that's what you suspect,=A0wouldn't this be evident in your
Library cache hit ratio?=A0 I don't think=A0a super spendy tool is =
always
necessary to see what's going on.
=A0
Lisa
Ft. Lauderdale, FL, USA
=A0
-----Original Message-----
From: Mike & Martha [mailto:mmrose_at_home.com]
Sent: Friday, July 21, 2000 2:50 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: database server CPU is 100%
Hi,
=A0
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.
=A0
Michael Rose
=A0
mmrose_at_home.com
=A0
We have a v7.3.4 production OLTP database on 4 CPU=A0 NT 4.0 server.=A0 =
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).=A0 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
=A0
Has anyone encountered this? Are they any=A0specific things should I be
looking=A0for.=A0 Any pointers would be appreciated.
=A0
Thx
Gautam=20
=A0
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20
class=3D553383504-22072000>Even I had faced similar situation(on NT), =
when by=20
mistake</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20
class=3D553383504-22072000>I forgot to terminate a loop in a test SQL =
script. It=20
was </SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20
class=3D553383504-22072000>running in infinite loop and CPU used was=20
100%. </SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20
class=3D553383504-22072000></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN=20
class=3D553383504-22072000> I did the </SPAN></FONT><FONT=20 color=3D#0000ff face=3D"Lucida Console" size=3D2><SPAN = class=3D553383504-22072000>the=20
[mailto:mmrose_at_home.com]<BR><B>Sent:</B> Friday, July 21, 2000 2:50=20
PM<BR><B>To:</B> Multiple recipients of list =
ORACLE-L<BR><B>Subject:</B> Re:=20
database server CPU is 100%<BR><BR></DIV></FONT>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<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=20
different applications and/or dynamic queries using SQL statements = that are=20
just slightly different from each other. This prevents code re-use =
(SQL=20
Statements), causes the database to have to reparse the 'new' =
(different)=20
SQL Statements, and most of all causes the contents of the =
<STRONG>SQL=20
Cache</STRONG> to 'thrash'. There is good reason to have ALL of the =
'Production Code' for each <STRONG>Instance</STRONG> = analyzed/approved by a=20
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>
<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=20
href=3D"mailto:ORACLE-L_at_fatcity.com" =
title=3DORACLE-L_at_fatcity.com>Multiple=20
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=20
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%=20
at least 80% of the time. Nothing has changed in the last two =
weeks. We=20
don't have any long running jobs. We have taken system state =
dumps and=20
found nothing there too(done this with the help of oracle =
support). =20
We have flushed the share pool couple of times to see if it was =
related to=20
parsing problems. The minute we flush the CPU usage comes down to =
50-60%=20
but goes back up to 100% within 15min. Our NT admins don't see =
any=20
problems with the server. </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" =
Received on Fri Jul 21 2000 - 23:37:22 CDT
 |
 |