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: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Tue, 17 Sep 2002 12:04:37 -0800
Message-ID: <F001.004D1B84.20020917120437@fatcity.com>


Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable

Could you have a "lost" thread. We have experienced, on multiple servers, = running 8.1.7.3.2. We put a patch on Oracle Applications 11i and only = during the very large patches, CPU goes to 100% and stays there. If look = at the threads, the one using cpu is not known to Oracle. Have had a tar = open for a while on this. Oracle believes it is a logon request getting = stuck. weird part is that the Oracle Apps patching program does not see = an error and continues on. =20

If we stop the database, cpu stays at 100% until we stop the service.

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204

>>> IBezdziecka_at_cupe.ca 9/17/02 3:35:05 PM >>> 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 = ...=20

Thank you anyway.=20
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.

                                                                           =

=20
"Inka =
=20
Bezdziecka" To: Multiple recipients of = list ORACLE-L <ORACLE-L_at_fatcity.com> =20 <IBezdziecka cc: =
=20
@cupe.ca> Subject: RE: SNP uses 60% of = CPU on Windows2000 - please help =20 Sent by: root =
=20
=
=20
=
=20
09/17/2002 =
=20
01:28 PM =
=20
Please =
=20
respond to =
=20
ORACLE-L =
=20
=
=20
=
=20

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 =3D 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 =3D vp.addr and
vp.addr =3D 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).



--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--=20
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).

--=_ABF71C05.F998FA1F
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1"=
>
<META content=3D"MSHTML 5.50.4919.2200" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN-TOP: 2px; FONT: 10pt Courier New; MARGIN-LEFT: 2px">
<DIV>Could you have a "lost" thread.&nbsp; We have experienced, on =
multiple=20
servers, running 8.1.7.3.2.&nbsp; We put a patch on Oracle Applications =
11i and=20
only during the very large patches, CPU goes to 100% and stays there.&nbsp;=
 If=20
look at the threads, the one using cpu is not known to Oracle.&nbsp; Have =
had a=20
tar open for a while on this.&nbsp; Oracle believes it is a logon =
request=20
getting stuck.&nbsp; weird part is that the Oracle Apps patching program =
does=20
not see an error and continues on.&nbsp; </DIV>
<DIV>&nbsp;</DIV>
<DIV>If we stop the database, cpu stays at 100% until we stop the =
service.</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>Jeffrey Beckstrom<BR>Database Administrator<BR>Greater Cleveland =
Regional=20
Transit Authority<BR>1240 W. 6th Street<BR>Cleveland, Ohio 44113<BR>(216)=
=20
781-4204<BR><BR>&gt;&gt;&gt; IBezdziecka_at_cupe.ca 9/17/02 3:35:05 PM=20
&gt;&gt;&gt;<BR>That was the starting point of entire problem. An IIS=20
administrator came to me complaining that Oracle.exe uses 99% of CPU. =
Indeed, it=20
does.<BR><BR>What is actually wrong with oracle.exe using 99% of CPU? =
Every=20
other process shows 00 under CPU and small numbers under time. I am =
getting to=20
think that I was sent on a wild goose chase.<BR><BR>That web site is up =
and=20
response time is not worse that it has always been. The server is very =
slow in=20
processing o/s management requests (starting performance monitor or =
sql*plus, or=20
something of a sort) - well ... <BR><BR>Thank you anyway.=20
<BR>inka<BR><BR><BR>-----Original Message-----<BR>Sent: Tuesday, September =
17,=20
2002 2:33 PM<BR>To: Multiple recipients of list ORACLE-L<BR><BR><BR><BR>Go =
to=20
your Task Manager again and pick the "processes" tab.&nbsp; Click on =
'CPU'<BR>to=20
sort the processes by CPU usage or 'CPU Time" to get who has run up =
the<BR>most=20
CPU usage since you last booted the system.&nbsp; All of your Oracle=20
treads<BR>run in one process, ORACLE.EXE.&nbsp; The dllhost.exe should be =
there=20
as a<BR>separate process.&nbsp; Though from what you show in your query I =
could=20
be<BR>wrong.<BR><BR><BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
"Inka&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;=20
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Bezdziecka"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
To:&nbsp;&nbsp;&nbsp;&nbsp; Multiple recipients of list ORACLE-L=20
&lt;ORACLE-L_at_fatcity.com&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
&lt;IBezdziecka&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
cc:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
@cupe.ca&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;=20
Subject:&nbsp;&nbsp;&nbsp;&nbsp; RE: SNP uses 60% of CPU on Windows2000 - =
please=20
help&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Sent by:=20
root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;=20
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;=20
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
09/17/2002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
01:28=20
PM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Please&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;=20
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
respond=20
to&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
ORACLE-L&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
=20
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;=20
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;=20
<BR><BR><BR><BR><BR>Thanks,<BR>my problem is that I hardly know how to =
spell=20
Windows. Performance monitor<BR>shows Paging file usage at zero.<BR><BR>On=
=20
Oracle side I altered system and set job_queue _process =3D 1.<BR><BR>when =
I=20
run<BR>select vb.name NOME, vp.program PROCESSNAME,<BR>vp.spid THREADID, =
vs.sid=20
SID, vs.program<BR>from v$session vs, v$process vp, v$bgprocess vb<BR>where=
=20
vb.paddr &lt;&gt; '00' and<BR>vb.paddr =3D vp.addr and<BR>vp.addr =3D=20
vs.paddr;<BR><BR>I got an output:<BR>NOME PROCESSNAME&nbsp;&nbsp;&nbsp;=20
THREADID&nbsp; SID&nbsp; PROGRAM<BR>PMON ORACLE.EXE&nbsp;&nbsp;&nbsp;&nbsp;=
 1580=20
1&nbsp;&nbsp;&nbsp; ORACLE.EXE<BR>DBW0 ORACLE.EXE&nbsp;&nbsp;&nbsp;&nbsp; =
1404=20
2&nbsp;&nbsp;&nbsp; ORACLE.EXE<BR>LGWR ORACLE.EXE&nbsp;&nbsp;&nbsp;&nbsp; =
1584=20
3&nbsp;&nbsp;&nbsp; ORACLE.EXE<BR>CKPT ORACLE.EXE&nbsp;&nbsp;&nbsp;&nbsp; =
1588=20
4&nbsp;&nbsp;&nbsp; ORACLE.EXE<BR>SMON ORACLE.EXE&nbsp;&nbsp;&nbsp;&nbsp; =
1592=20
5&nbsp;&nbsp;&nbsp; ORACLE.EXE<BR>RECO ORACLE.EXE&nbsp;&nbsp;&nbsp;&nbsp; =
1596=20
6&nbsp;&nbsp;&nbsp; ORACLE.EXE<BR>SNP0 ORACLE.EXE&nbsp;&nbsp;&nbsp;&nbsp; =
1600=20
7<BR>SNP2 ORACLE.EXE&nbsp;&nbsp;&nbsp;&nbsp; 2624 35&nbsp;&nbsp;=20
dllhost.exe<BR>SNP3 ORACLE.EXE&nbsp;&nbsp;&nbsp;&nbsp; 2532 8&nbsp;&nbsp;&n=
bsp;=20
dllhost.exe<BR>ARC0 ORACLE.EXE&nbsp;&nbsp;&nbsp;&nbsp; 1636 11&nbsp;&nbsp;=
=20
ORACLE.EXE<BR>SNP4 ORACLE.EXE&nbsp;&nbsp;&nbsp;&nbsp; 1784 18&nbsp;&nbsp;=
=20
dllhost.exe<BR>SNP5 ORACLE.EXE&nbsp;&nbsp;&nbsp;&nbsp; 644&nbsp; 23&nbsp;&n=
bsp;=20
dllhost.exe<BR><BR>As far as I know, dllhost.exe is ASP execution engine. =
So the=20
culprit may<BR>be on the application side, not Oracle.<BR><BR>Does that =
make any=20
sense?<BR><BR>inka<BR><BR><BR><BR>-----Original Message-----<BR>Sent: =
Tuesday,=20
September 17, 2002 10:49 AM<BR>To: Multiple recipients of list=20
ORACLE-L<BR><BR><BR><BR>I have had times on Win NT boxes when the CPU went =
to=20
100%.&nbsp; My experience<BR>is that this happens when the OS is thrashing =
the=20
swapfile (writing it into<BR>and out of memory on a&nbsp; continuous=20
basis).&nbsp;&nbsp; If the disk I/O is also very<BR>high then that may be =
what's=20
happening.&nbsp; However, 800M free out of 2G does<BR>not look too =
bad.&nbsp; If=20
you don't have the high disk I/O then the SGA is<BR>probably not the=20
issue.&nbsp; I don't want to push you in the wrong=20
direction<BR>either.<BR><BR>HTH<BR><BR><BR><BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;=20
"Inka<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Bezdziecka"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
To:&nbsp;&nbsp;&nbsp;&nbsp; Multiple recipients of<BR>list ORACLE-L=20
&lt;ORACLE-L_at_fatcity.com&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
&lt;IBezdziecka&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
cc:<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
@cupe.ca&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;=20
Subject:&nbsp;&nbsp;&nbsp;&nbsp; RE: SNP uses 60% of<BR>CPU on Windows2000 =
-=20
please=20
help<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Sent by:=20
root<BR><BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
09/16/2002<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
03:38=20
PM<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Please<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
respond=20
to<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
ORACLE-L<BR><BR><BR><BR><BR><BR><BR>The server has 2GB, free at the =
moment=20
800MB. Do you think that SGA size<BR>may have something to do with=20
it?<BR><BR>-----Original Message-----<BR>Sent: Monday, September 16, 2002 =
2:58=20
PM<BR>To: Multiple recipients of list ORACLE-L<BR><BR><BR><BR>How much =
physical=20
RAM do you have and how much are you using?&nbsp; Check the<BR>Task =
Manager on=20
the "performance" tab under "MEM Usage" to get that=20
figure.<BR><BR><BR><BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
"Inka<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Bezdziecka"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
To:&nbsp;&nbsp;&nbsp;&nbsp; Multiple recipients of<BR>list ORACLE-L=20
&lt;ORACLE-L_at_fatcity.com&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
&lt;IBezdziecka&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
cc:<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
@cupe.ca&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;=20
Subject:&nbsp;&nbsp;&nbsp;&nbsp; SNP uses 60% of CPU<BR>on Windows2000 - =
please=20
help<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Sent by:=20
root<BR><BR><BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
09/16/2002<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
01:13=20
PM<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Please<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
respond=20
to<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
ORACLE-L<BR><BR><BR><BR><BR><BR><BR>Hello,<BR>I run into a problem, which =
I=20
cannot solve myself and would greatly<BR>appreciate any help.<BR><BR>Oracle=
=20
8.1.7.0.0 utilises 99% of CPU on a Windows2000 server, which also<BR>has =
to run=20
MS IIS and a few applications.<BR><BR>There are 9 user connections (from =
MS=20
IISv.5, using Oracle ODBC). There are<BR>no waits, no locks, basic =
statistics=20
values are very good.<BR><BR>I found the SNP process executing queued jobs =
using=20
60% of CPU. There are<BR>no queued&nbsp; jobs (current, broken or any =
other) in=20
the neighbourhood, never<BR>mind on that server.<BR>The sql_text shows: =
BEGIN=20
sys.dbms_ijob.remove(:job); END;<BR><BR>It seems, that the high usage =
is=20
coincidental with creation of InterMedia<BR>Text indices, which seems to =
be at=20
least peculiar.<BR><BR>If anyone cares to push me in the right direction, =
I=20
shall be eternally<BR>grateful.<BR><BR>inka<BR>--<BR>Please see the =
official=20
ORACLE-L FAQ: <A=20
href=3D"http://www.orafaq.com">http://www.orafaq.com</A><BR>--<BR>Author: =
Inka=20
Bezdziecka<BR>&nbsp; INET: IBezdziecka_at_cupe.ca<BR><BR>Fat City Network=20
Services&nbsp;&nbsp;&nbsp; -- 858-538-5051 <A=20
href=3D"http://www.fatcity.com">http://www.fatcity.com</A><BR>San =
Diego,=20
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Mailing list and =
web=20
hosting=20
services<BR>---------------------------------------------------------------=
------<BR>To=20
REMOVE yourself from this mailing list, send an E-Mail message<BR>to:=20
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the =
message=20
BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing =
list=20
you want to be removed from).&nbsp; You may<BR>also send the HELP command =
for=20
other information (like subscribing).<BR><BR><BR><BR>--<BR>Please see =
the=20
official ORACLE-L FAQ: <A=20
href=3D"http://www.orafaq.com">http://www.orafaq.com</A><BR>--<BR>Author: =
Thomas=20
Day<BR>&nbsp; INET: tday6_at_csc.com<BR><BR>Fat City Network=20
Services&nbsp;&nbsp;&nbsp; -- 858-538-5051 <A=20
href=3D"http://www.fatcity.com">http://www.fatcity.com</A><BR>San =
Diego,=20
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Mailing list and =
web=20
hosting=20
services<BR>---------------------------------------------------------------=
------<BR>To=20
REMOVE yourself from this mailing list, send an E-Mail message<BR>to:=20
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the =
message=20
BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing =
list=20
you want to be removed from).&nbsp; You may<BR>also send the HELP command =
for=20
other information (like subscribing).<BR>--<BR>Please see the official =
ORACLE-L=20
FAQ: <A href=3D"http://www.orafaq.com">http://www.orafaq.com</A><BR>--<BR>A=
uthor:=20
Inka Bezdziecka<BR>&nbsp; INET: IBezdziecka_at_cupe.ca<BR><BR>Fat City =
Network=20
Services&nbsp;&nbsp;&nbsp; -- 858-538-5051 <A=20
href=3D"http://www.fatcity.com">http://www.fatcity.com</A><BR>San =
Diego,=20
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Mailing list and =
web=20
hosting=20
services<BR>---------------------------------------------------------------=
------<BR>To=20
REMOVE yourself from this mailing list, send an E-Mail message<BR>to:=20
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the =
message=20
BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing =
list=20
you want to be removed from).&nbsp; You may<BR>also send the HELP command =
for=20
other information (like subscribing).<BR><BR><BR><BR>--<BR>Please see =
the=20
official ORACLE-L FAQ: <A=20
href=3D"http://www.orafaq.com">http://www.orafaq.com</A><BR>--<BR>Author: =
Thomas=20
Day<BR>&nbsp; INET: tday6_at_csc.com<BR><BR>Fat City Network=20
Services&nbsp;&nbsp;&nbsp; -- 858-538-5051 <A=20
href=3D"http://www.fatcity.com">http://www.fatcity.com</A><BR>San =
Diego,=20
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Mailing list and =
web=20
hosting=20
services<BR>---------------------------------------------------------------=
------<BR>To=20
REMOVE yourself from this mailing list, send an E-Mail message<BR>to:=20
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the =
message=20
BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing =
list=20
you want to be removed from).&nbsp; You may<BR>also send the HELP command =
for=20
other information (like subscribing).<BR>--<BR>Please see the official =
ORACLE-L=20
FAQ: <A href=3D"http://www.orafaq.com">http://www.orafaq.com</A><BR>--<BR>A=
uthor:=20
Inka Bezdziecka<BR>&nbsp; INET: IBezdziecka_at_cupe.ca<BR><BR>Fat City =
Network=20
Services&nbsp;&nbsp;&nbsp; -- 858-538-5051 <A=20
href=3D"http://www.fatcity.com">http://www.fatcity.com</A><BR>San =
Diego,=20
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Mailing list and =
web=20
hosting=20
services<BR>---------------------------------------------------------------=
------<BR>To=20
REMOVE yourself from this mailing list, send an E-Mail message<BR>to:=20
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the =
message=20
BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing =
list=20
you want to be removed from).&nbsp; You may<BR>also send the HELP command =
for=20
other information (like subscribing).<BR><BR><BR><BR>-- <BR>Please see =
the=20
official ORACLE-L FAQ: <A=20
href=3D"http://www.orafaq.com">http://www.orafaq.com</A><BR>-- <BR>Author: =
Thomas=20
Day<BR>&nbsp; INET: tday6_at_csc.com<BR><BR>Fat City Network=20
Services&nbsp;&nbsp;&nbsp; -- 858-538-5051 <A=20
href=3D"http://www.fatcity.com">http://www.fatcity.com</A><BR>San =
Diego,=20
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Mailing list and =
web=20
hosting=20
services<BR>---------------------------------------------------------------=
------<BR>To=20
REMOVE yourself from this mailing list, send an E-Mail message<BR>to:=20
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the =
message=20
BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing =
list=20
you want to be removed from).&nbsp; You may<BR>also send the HELP command =
for=20
other information (like subscribing).<BR>--<BR>Please see the official =
ORACLE-L=20
FAQ: <A href=3D"http://www.orafaq.com">http://www.orafaq.com</A><BR>--<BR>A=
uthor:=20
Inka Bezdziecka<BR>&nbsp; INET: IBezdziecka_at_cupe.ca<BR><BR>Fat City =
Network=20
Services&nbsp;&nbsp;&nbsp; -- 858-538-5051 <A=20
href=3D"http://www.fatcity.com">http://www.fatcity.com</A><BR>San =
Diego,=20
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Mailing list and =
web=20
hosting=20
services<BR>---------------------------------------------------------------=
------<BR>To=20
REMOVE yourself from this mailing list, send an E-Mail message<BR>to:=20
ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the =
message=20
BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing =
list=20
you want to be removed from).&nbsp; You may<BR>also send the HELP command =
for=20
other information (like subscribing).<BR></DIV></BODY></HTML>

--=_ABF71C05.F998FA1F--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeffrey Beckstrom
  INET: JBECKSTROM_at_gcrta.org

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:04:37 CDT

Original text of this message

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