Re: NT Server very slow

From: Jerry C <usidba_at_yahoo.com>
Date: Mon, 26 Mar 2001 12:39:30 -0800
Message-ID: <F001.002D800B.20010326110053@fatcity.com>
Hi Kevin -
The bug doc mentions a certain processor, so it could be hardware dependant. I'm not sure if our affected machine had the mentioned processors or not (I stopped investigating after the patch fixed our problem - I'm lazy that way!).
Even though the doc says 8.1.5, we had the problem w/ 8.1.6.0 - it was fixed in 8.1.6.3
Here's an excerpt from the doc for those who are interested.
Jerry
---

Bug No. 941798
Filed 21-JUL-1999
Updated 28-APR-2000
Product Oracle Server - Enterprise Edition V7
Product Version 8.1.5.0.0
Platform Intel Windows NT Platform Version 4.0
RDBMS Version 8.1.5.0.0
Affects Platforms Port-Specific
Priority Severe Loss of Service
Status Closed, Could Not Reproduce
Base Bug 879133
Fixed in Product Version No Data

Problem statement:

ORACLE.EXE MEMORY LEAK, 100% UTILIZATION WITH INTEL P-3 XEON 450 PROCESSORS

Hdr: 941798 8.1.5.0.0 RDBMS 8.1.5.0.0 PERFORMANCE PRODID-5 PORTID-912
ORA-12500 879133 Abstract: ORACLE.EXE MEMORY LEAK, 100% UTILIZATION WITH
INTEL P-3 XEON 450 PROCESSORS *** 07/21/99 05:49 am *** .

=========================

PROBLEM: .
1. Clear description of the problem encountered:
Oracle.exe appears to have a memory leak when running on xeon processors. Ct
has several instalations running on plain p-2's ok, though instalation on
intel MB, 2 p-3 xeon processors, 1G mem, fails after 2-3 days running This
is with 0-1 users connecting to db fr this period of time. .

2. Pertinent configuration information (MTS/OPS/distributed/etc)
Ct had originally configured MTS, though disabled thinking this may have
been an issue. Still has same issue. .

3. Indication of the frequency and predictability of the problem
This occurs between 2-3 days after starting instance. After occurance of
error, reboot is solution. This is fairly consistent on ct's installation .

4. Sequence of events leading to the problem nothing special, start oracle
service and ionstance, after 2-3 days gets eeror ora-12500 'can not create
dedicated process' when trying to connect. .

5. Technical impact on the customer. Include persistent after effects. This
is a test machine, ct is planning on rolling out production utilizing xeon
processors for performance gain. They are on a time constraint and are leary
of hardware/software purchases utill this is resolved

=========================
DIAGNOSTIC ANALYSIS:
NT Performance monitor statistics

system resources;
start, 447,240M used
end, 562,008 M used .

oracle.exe
start 77,352 M used
end 93,200 M used .

racle.exe cpu utilization;
start 0%
end 100% . .

=========================
WORKAROUND: None .

=========================
RELATED BUGS: 879133 .

----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Saturday, March 24, 2001 12:40 PM




> Hey Jerry,

>     Is this hardware dependant in any way?   I have several instances of

> 8.1.6.0 and none of them have ever done anything like that. Then again, we

> are not a 24/7 shop and I am running cold backups every night, maybe that

is


> why.

> Kev

> ----- Original Message -----

> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

> Sent: Friday, March 23, 2001 5:30 PM

>

>

> > Hi Kevin,

> >

> > Yes, it will suck down the whole processor. We had a new implementation,

> > with ZERO users, that had the problem.

> >

> > It is a memory leak of some sort. 8163 fixed it.

> >

> >

> > - Jerry

> >

> >

> > ----- Original Message -----

> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>

> > Sent: Friday, March 23, 2001 3:59 PM

> >

> >

> > > Interesting, i have never heard of this bug.  What do you mean, all of

> the

> > > sudden it will suck down the whole processor?  How many users?

> > >

> > > -----Original Message-----

> > > Sent: Friday, March 23, 2001 3:37 PM

> > > To: Multiple recipients of list ORACLE-L

> > >

> > >

> > > There is a bug with some version of Oracle (I believe it was

8.1.6.0.0,


> > but

> > > don't quote me on that), where even with NO users, oracle.exe would

> > > eventually consume your whole CPU. The CPU utilization ramps up after

a


> db

> > > restart until it gets to 99 or 100.

> > >

> > > Open Task Manager and check the oracle.exe process.

> > >

> > > I belive 8.1.6.3 fixes it, but call Oracle "Support" to be sure.

> > >

> > >

> > > Good luck!

> > >

> > > - Jerry

> > >

> > >

> > > ----- Original Message -----

> > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>

> > > Sent: Friday, March 23, 2001 12:17 PM

> > >

> > >

> > > > Since you mention there are only a few users, I would take a look at

> the

> > > > jobs these users are running.  Maybe one of these users is firing

off


> a

> > > > poorly tuned job that brings the database to a grinding halt.

> > > >

> > > > Is the database the only product on the Server?  Or are there other

> > > > applications ( email server, web server...)

> > > >

> > > > Jim

> > > >

> > > >

> > > >

> > > > -----Original Message-----

> > > > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

> > > > Date: Friday, March 23, 2001 7:50 AM

> > > >

> > > >

> > > > >I have an Oracle 8.1.6 instance on an NT Server.  The application

has


> > > only

> > > > a

> > > > >few users.  Very often throughout the day it seems response time

> drops

> > to

> > > > >about 20 seconds.  By the time I log on to look at the problem

> > everything

> > > > is

> > > > >back to normal.  If I do a simple query the result is returned

> > > immediately.

> > > > >I have looked at SQL through Quest's SQLAB and there is nothing

that


> > > stand

> > > > >out.  The hit ratio averages between 88% and 92%.  Is there a good

> way

> > to

> > > > >diagnose this type of problem?

> > > > >

> > > > >Ron Smith

> > > > >Database Administration

> > > > >rlsmith_at_kmg.com

> > > > >

> > > > >--

> > > > >Please see the official ORACLE-L FAQ: http://www.orafaq.com

> > > > >--

> > > > >Author: Smith, Ron L.

> > > > >  INET: rlsmith_at_kmg.com

> > > > >

> > > > >Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> > > > >San Diego, California        -- Public Internet access / Mailing

> Lists

> > > >

>--------------------------------------------------------------------

> > > > >To REMOVE yourself from this mailing list, send an E-Mail message

> > > > >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> > > > >the message BODY, include a line containing: UNSUB ORACLE-L

> > > > >(or the name of mailing list you want to be removed from).  You may

> > > > >also send the HELP command for other information (like

subscribing).


> > > >

> > > > --

> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com

> > > > --

> > > > Author: Jim Walski

> > > >   INET: jwalski3_at_classicplan.com

> > > >

> > > > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> > > > San Diego, California        -- Public Internet access / Mailing

Lists


> > > > --------------------------------------------------------------------

> > > > To REMOVE yourself from this mailing list, send an E-Mail message

> > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> > > > the message BODY, include a line containing: UNSUB ORACLE-L

> > > > (or the name of mailing list you want to be removed from).  You may

> > > > also send the HELP command for other information (like subscribing).

> > >

> > >

> > > _________________________________________________________

> > > Do You Yahoo!?

> > > Get your free @yahoo.com address at http://mail.yahoo.com

> > >

> > > --

> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com

> > > --

> > > Author: Jerry C

> > >   INET: usidba_at_yahoo.com

> > >

> > > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> > > San Diego, California        -- Public Internet access / Mailing Lists

> > > --------------------------------------------------------------------

> > > To REMOVE yourself from this mailing list, send an E-Mail message

> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> > > the message BODY, include a line containing: UNSUB ORACLE-L

> > > (or the name of mailing list you want to be removed from).  You may

> > > also send the HELP command for other information (like subscribing).

> > >

> > > --

> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com

> > > --

> > > Author: Kevin Kostyszyn

> > >   INET: kevin_at_dulcian.com

> > >

> > > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> > > San Diego, California        -- Public Internet access / Mailing Lists

> > > --------------------------------------------------------------------

> > > To REMOVE yourself from this mailing list, send an E-Mail message

> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> > > the message BODY, include a line containing: UNSUB ORACLE-L

> > > (or the name of mailing list you want to be removed from).  You may

> > > also send the HELP command for other information (like subscribing).

> >

> >

> > _________________________________________________________

> > Do You Yahoo!?

> > Get your free @yahoo.com address at http://mail.yahoo.com

> >

> > --

> > Please see the official ORACLE-L FAQ: http://www.orafaq.com

> > --

> > Author: Jerry C

> >   INET: usidba_at_yahoo.com

> >

> > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> > San Diego, California        -- Public Internet access / Mailing Lists

> > --------------------------------------------------------------------

> > To REMOVE yourself from this mailing list, send an E-Mail message

> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> > the message BODY, include a line containing: UNSUB ORACLE-L

> > (or the name of mailing list you want to be removed from).  You may

> > also send the HELP command for other information (like subscribing).

>

> --

> Please see the official ORACLE-L FAQ: http://www.orafaq.com

> --

> Author: Kevin Kostyszyn

>   INET: kevin_at_dulcian.com

>

> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing Lists

> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message

> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> the message BODY, include a line containing: UNSUB ORACLE-L

> (or the name of mailing list you want to be removed from).  You may

> also send the HELP command for other information (like subscribing).



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jerry C
  INET: usidba_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon Mar 26 2001 - 14:39:30 CST