check out Doc ID 941798 at Metalink...
----- Original Message -----
To: <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> 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 <[EMAIL PROTECTED]>
> > 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
> > >[EMAIL PROTECTED]
> > >
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Smith, Ron L.
> > > INET: [EMAIL PROTECTED]
> > >
> > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
