Sent: Friday, July 21, 2000 12:03 PM Subject: database server CPU is 100% 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_01BFF34C.C03FA9C8 Content-Type: text/html; charset="iso-8859-1"

Mike, if that's what you suspect, wouldn't this be evident in your Library cache hit ratio? I don't think a super spendy tool is always necessary to see what's going on.

Lisa

Ft. Lauderdale, FL, USA

-----Original Message-----
From: Mike & Martha [mailto:mmrose@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,

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@home.com

----- Original Message -----

From: Gautam_Reddy@Dell.com

To: Multiple recipients of list ORACLE-L

Sent: Friday, July 21, 2000 12:03 PM

Subject: database server CPU is 100%

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