RE: NT Server very slow

cant find it????

> -----Original Message-----
> From: Jerry C [mailto:usidba_at_yahoo.com]
> Sent: Friday, March 23, 2001 4:31 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: NT Server very slow
>
>
> check out Doc ID 941798 at Metalink...
>
>
> ----- Original Message -----
> To: <ORACLE-L_at_fatcity.com>
> Sent: Friday, March 23, 2001 3:36 PM
>
>
> > 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 -----
> > From: "Jim Walski" <jwalski3_at_classicplan.com>
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Friday, March 23, 2001 12:17 PM
> > Subject: Re: NT Server very slow
> >
> >
> > > 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: Mandar Ghosalkar
  INET: MandarG_at_gsr-inc.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).