Re: NT Server very slow

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).