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
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 services --------------------------------------------------------------------- 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-LReceived on Mon Sep 16 2002 - 13:58:21 CDT
(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: tday6_at_csc.com 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: 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).
![]() |
![]() |