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