Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SNP uses 60% of CPU on Windows2000 - please help

RE: SNP uses 60% of CPU on Windows2000 - please help

From: Thomas Day <tday6_at_csc.com>
Date: Tue, 17 Sep 2002 12:38:43 -0800
Message-ID: <F001.004D1C28.20020917123843@fatcity.com> 






If the end users are not complaining about response time then ORACLE using
99% of the CPU is not an issue.  However, I can't help but think that 99%
usage indicates some problem, even if it's not having a critical impact.



I'm supporting a Win2K machine that has 7 instances on it.  We're using
1160M of 1310M of RAM.  We have 2 CPUs and CPU usage is normally at 2%.  It
currently looks as if we have 96 users logged in to one or the other of the
Oracle instances.  We have the extra CPU in order to keep the CPU usage
from pinning at 100% for extended periods of time.  If it did become pinned
for more than a few minutes at a time the users would call about the poor
response time and I'd be worried that something was wrong.



But environments and business needs vary.  We have a few high-rafter bats
among our users who want their queries answered NOW.  They are willing to
spend the extra bucks to make that happen.




                                                                                                                   
                    "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/17/2002                                                                                     
                    03:35 PM                                                                                       
                    Please                                                                                         
                    respond to                                                                                     
                    ORACLE-L                                                                                       
                                                                                                                   
                                                                                                                   








That was the starting point of entire problem. An IIS administrator came to
me complaining that Oracle.exe uses 99% of CPU. Indeed, it does.



What is actually wrong with oracle.exe using 99% of CPU? Every other
process shows 00 under CPU and small numbers under time. I am getting to
think that I was sent on a wild goose chase.



That web site is up and response time is not worse that it has always been.
The server is very slow in processing o/s management requests (starting
performance monitor or sql*plus, or something of a sort) - well ...



Thank you anyway.


inka




-----Original Message-----



Sent: Tuesday, September 17, 2002 2:33 PM
To: Multiple recipients of list ORACLE-L





Go to your Task Manager again and pick the "processes" tab.  Click on 'CPU'
to sort the processes by CPU usage or 'CPU Time" to get who has run up the
most CPU usage since you last booted the system.  All of your Oracle treads
run in one process, ORACLE.EXE.  The dllhost.exe should be there as a
separate process.  Though from what you show in your query I could be
wrong.





                    "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/17/2002
                    01:28 PM
                    Please
                    respond to
                    ORACLE-L










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 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).





--



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).


--



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-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: 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).


--



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-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: 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).


--



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-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: 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).
Received on Tue Sep 17 2002 - 15:38:43 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US