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 
<[EMAIL PROTECTED]>       
                    <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 <[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).
--
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).

Reply via email to