| 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
Thanks,
my problem is that I hardly know how to spell Windows. Performance monitor shows Paging file usage at zero.
On Oracle side I altered system and set job_queue _process = 1.
when I run
select vb.name NOME, vp.program PROCESSNAME,
vp.spid THREADID, vs.sid SID, vs.program
from v$session vs, v$process vp, v$bgprocess vb
where vb.paddr <> '00' and
vb.paddr = vp.addr and
vp.addr = vs.paddr;
I got an output:
NOME PROCESSNAME THREADID SID PROGRAM PMON ORACLE.EXE 1580 1 ORACLE.EXE DBW0 ORACLE.EXE 1404 2 ORACLE.EXE LGWR ORACLE.EXE 1584 3 ORACLE.EXE CKPT ORACLE.EXE 1588 4 ORACLE.EXE SMON ORACLE.EXE 1592 5 ORACLE.EXE RECO ORACLE.EXE 1596 6 ORACLE.EXE SNP0 ORACLE.EXE 1600 7 SNP2 ORACLE.EXE 2624 35 dllhost.exe SNP3 ORACLE.EXE 2532 8 dllhost.exe ARC0 ORACLE.EXE 1636 11 ORACLE.EXE SNP4 ORACLE.EXE 1784 18 dllhost.exe SNP5 ORACLE.EXE 644 23 dllhost.exe
As far as I know, dllhost.exe is ASP execution engine. So the culprit may be on the application side, not Oracle.
Does that make any sense?
inka
-----Original Message-----
Sent: Tuesday, September 17, 2002 10:49 AM
To: Multiple recipients of list ORACLE-L
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).
---------------------------------------------------------------------
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). Received on Tue Sep 17 2002 - 12:28:33 CDT
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |