MIME-Version: 1.0
Date: Tue, 9 Sep 2014 13:23:41 -0400
Message-ID: <CAE-dsOLQuC_GAwupnUvd207GeyH0vvK7ov0x=ROCzVvVdAp9=g@mail.gmail.com>
Subject: top oracle server process not in v$process.spid
From: Dba DBA <oracledbaquestions@gmail.com>
To: ORACLE-L <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary=047d7bf0c9305e564b0502a53286
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: oracledbaquestions@gmail.com
--047d7bf0c9305e564b0502a53286
Content-Type: text/plain; charset=UTF-8

11.2.0.4 , 2 node rac
linux 6

AWR/ASH not turned on. Statspack not installed. Some people dont pay for
this.... tracking this down is tricky.

ran top, 2 oracle processes at 99% cpu. However, 0% memory. Do not show up
in gv$process.spid or setospid (for hanganalyze/system state dump)


I believe I have seen high cpu processes before that dont show up either,
but I usually just go to ASH or awr and find it easily. I don't have that.
Plus they dont appear to use connectin pooling, so
gv$session_event,gv$session_wait are not useful... so history.

Step 1:
Process So far: Top , shows two oracle session at 99% CPU

ps -ef | grep <process>

 oracle<DBNAME>1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

step 2: select count(*) from gv$process where spdi = <mypid>
no rows returned.

step 3: system statedump
 SQL >  oradebug setospid <HIGH_CPU_PID>
ORA-00075: process "Unix process pid: <HIGH_CPU_PID>, image: <none>" not
found in this instance

step 3: general system statedump 'oradebug setospid myospid'
not much here. S ee this. Read through references to library cache, but
when I check gv$session_event does not seem high. However, lots

HM: Master is instance 1. My instance is 1 - I am the master.
Hang detection is enabled.  Hang resolution scope is PROCESS.
HM: CPU load is NOT abnormally high.
HM: IO load is NOT abnormally high (1).

see references to librarcyh cache latch. However, sessions dont use
connectin pooling and vanish before I can check sessions.

step 4: doesnt appear to use conneciton pooling. Number of connetions goes
between 60 - 200. So gv$session_Event, gv$session_wait are not real
useful...

step 5: poll gv$session over and over and over again.
occassionally see vktm idle process, pmon timer, rdbms ipc message   as top
waits. but they flicker off.

--047d7bf0c9305e564b0502a53286
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">11.2.0.4 , 2 node rac<div>linux 6</div><div><br></div><div=
>AWR/ASH not turned on. Statspack not installed. Some people dont pay for t=
his.... tracking this down is tricky.=C2=A0</div><div><br></div><div>ran to=
p, 2 oracle processes at 99% cpu. However, 0% memory. Do not show up in gv$=
process.spid or setospid (for hanganalyze/system state dump)=C2=A0</div><di=
v><br></div><div><br></div><div>I believe I have seen high cpu processes be=
fore that dont show up either, but I usually just go to ASH or awr and find=
 it easily. I don&#39;t have that. Plus they dont appear to use connectin p=
ooling, so gv$session_event,gv$session_wait are not useful... so history.=
=C2=A0</div><div><br></div><div>Step 1:</div><div>Process So far: Top , sho=
ws two oracle session at 99% CPU</div><div><br></div><div>ps -ef | grep &lt=
;process&gt;</div><div><br></div><div>=C2=A0oracle&lt;DBNAME&gt;1 (DESCRIPT=
ION=3D(LOCAL=3DYES)(ADDRESS=3D(PROTOCOL=3Dbeq)))<br></div><div><br></div><d=
iv>step 2: select count(*) from gv$process where spdi =3D &lt;mypid&gt;</di=
v><div>no rows returned.=C2=A0</div><div><br></div><div>step 3: system stat=
edump</div><div><div>=C2=A0SQL &gt; =C2=A0oradebug setospid &lt;HIGH_CPU_PI=
D&gt;</div><div>ORA-00075: process &quot;Unix process pid: &lt;HIGH_CPU_PID=
&gt;, image: &lt;none&gt;&quot; not found in this instance</div></div><div>=
<br></div><div>step 3: general system statedump &#39;oradebug setospid myos=
pid&#39;</div><div>not much here. S ee this. Read through references to lib=
rary cache, but when I check gv$session_event does not seem high. However, =
lots</div><div><br></div><div><div>HM: Master is instance 1. My instance is=
 1 - I am the master.</div><div>Hang detection is enabled. =C2=A0Hang resol=
ution scope is PROCESS.</div><div>HM: CPU load is NOT abnormally high.</div=
><div>HM: IO load is NOT abnormally high (1).</div><div><br></div><div>see =
references to librarcyh cache latch. However, sessions dont use connectin p=
ooling and vanish before I can check sessions.=C2=A0</div><div><br></div><d=
iv>step 4: doesnt appear to use conneciton pooling. Number of connetions go=
es between 60 - 200. So gv$session_Event, gv$session_wait are not real usef=
ul...=C2=A0</div><div><br></div><div>step 5: poll gv$session over and over =
and over again.=C2=A0</div><div>occassionally see vktm idle process, pmon t=
imer,=C2=A0rdbms ipc message =C2=A0 as top waits. but they flicker off.=C2=
=A0</div><div><br></div><div><br></div><div><br></div></div><div><br></div>=
</div>

--047d7bf0c9305e564b0502a53286--
--
http://www.freelists.org/webpage/oracle-l