| 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: NT Server very slow
check out Doc ID 941798 at Metalink...
> 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).
>
-- 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 Fri Mar 23 2001 - 18:44:05 CST
 |
 |