I have had times on Win NT boxes when the CPU went to 100%. My experience
is that this happens when the OS is thrashing the swapfile (writing it into
and out of memory on a continuous basis). If the disk I/O is also very
high then that may be what's happening. However, 800M free out of 2G does
not look too bad. If you don't have the high disk I/O then the SGA is
probably not the issue. I don't want to push you in the wrong direction
either.
HTH
"Inka
Bezdziecka" To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
<IBezdziecka cc:
@cupe.ca> Subject: RE: SNP uses 60% of CPU on
Windows2000 - please help
Sent by: root
09/16/2002
03:38 PM
Please
respond to
ORACLE-L
The server has 2GB, free at the moment 800MB. Do you think that SGA size
may have something to do with it?
-----Original Message-----
Sent: Monday, September 16, 2002 2:58 PM
To: Multiple recipients of list ORACLE-L
How much physical RAM do you have and how much are you using? Check the
Task Manager on the "performance" tab under "MEM Usage" to get that figure.
"Inka
Bezdziecka" To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
<IBezdziecka cc:
@cupe.ca> Subject: SNP uses 60% of CPU
on Windows2000 - please help
Sent by: root
09/16/2002
01:13 PM
Please
respond to
ORACLE-L
Hello,
I run into a problem, which I cannot solve myself and would greatly
appreciate any help.
Oracle 8.1.7.0.0 utilises 99% of CPU on a Windows2000 server, which also
has to run MS IIS and a few applications.
There are 9 user connections (from MS IISv.5, using Oracle ODBC). There are
no waits, no locks, basic statistics values are very good.
I found the SNP process executing queued jobs using 60% of CPU. There are
no queued jobs (current, broken or any other) in the neighbourhood, never
mind on that server.
The sql_text shows: BEGIN sys.dbms_ijob.remove(:job); END;
It seems, that the high usage is coincidental with creation of InterMedia
Text indices, which seems to be at least peculiar.
If anyone cares to push me in the right direction, I shall be eternally
grateful.
inka
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Inka Bezdziecka
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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: Thomas Day
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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: Inka Bezdziecka
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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: Thomas Day
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
