| 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: SNP uses 60% of CPU on Windows2000 - please help
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 <ORACLE-L_at_fatcity.com>
<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 <ORACLE-L_at_fatcity.com>
<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: IBezdziecka_at_cupe.ca
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thomas Day
INET: tday6_at_csc.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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).
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thomas Day
INET: tday6_at_csc.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesto: 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 Tue Sep 17 2002 - 09:48:30 CDT
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |