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" <[EMAIL PROTECTED]>
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" <[EMAIL PROTECTED]>
> 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 <[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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Kostyszyn
> 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).