phantom thread consuming cpu on windows

Hallo,
I've encountered two times on two machines a similar problem.
With Oracle 9.2.0.6 on windows 2003 there were no active sessions
(from v$session), non active transactions (from v$transaction) but
Oracle.exe from windows task manager
was using about 25-30% of CPU.
The interesting thing was when from sqlplus command line i executed
SQL>shutdown immediate
the database goes down cleanly, but on windows task manager
"oracle.exe" process still consumed 25-30% of
cpu.
Has anybody ever seen that? Was a mad thread? What was?
Stopping the service made process disappear and cpu go down.
(excuse me for poor english)


Bye
Cristian Cudizio

http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com

Greetings!

Our databases run on the HP-UX platform and I've seen something
similar on very rare occasions.

I was able to fix it by relinking (recreating) the "oracle" object
file. Never really sure what the root cause ever was. Could have been
due to an earlier patch that never mentioned that a relink was
mandatory.

Not sure what the syntax would be to "relink" in Windows. My expertise
is Unix-oriented. Certainly worth a shot.

Regards,

Eugene Pokopac (Oracle DBA - GSFA - Tucker, GA)

On May 25, 3:42 pm, epoko... (AT) excite (DOT) com wrote:

Greetings!

Our databases run on the HP-UX platform and I've seen something
similar on very rare occasions.

I was able to fix it by relinking (recreating) the "oracle" object
file. Never really sure what the root cause ever was. Could have been
due to an earlier patch that never mentioned that a relink was
mandatory.

Not sure what the syntax would be to "relink" in Windows. My expertise
is Unix-oriented. Certainly worth a shot.

Regards,

Eugene Pokopac (Oracle DBA - GSFA - Tucker, GA)

Unfortunately for what i know on window binaries are not relinkable.
It is a word apart. Only on Windows Oracle
works with threads, on Unix oracle spawns processes. on unix it is
easy see a similar situation by a "ps aux",
then v$process and V$session . On windows it is a bit more
complicated. (i think that is not possible to kill a thread).
However maybe that the problem is tha same.
Thank you, Eugene

Bye
Cristian Cudizio

http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com

On May 25, 9:57 am, Cristian Cudizio <cristian.cudi... (AT) yahoo (DOT) it>
wrote:

On May 25, 3:42 pm, epoko... (AT) excite (DOT) com wrote:



Greetings!

Our databases run on the HP-UX platform and I've seen something
similar on very rare occasions.

I was able to fix it by relinking (recreating) the "oracle" object
file. Never really sure what the root cause ever was. Could have been
due to an earlier patch that never mentioned that a relink was
mandatory.

Not sure what the syntax would be to "relink" in Windows. My expertise
is Unix-oriented. Certainly worth a shot.

Regards,

Eugene Pokopac (Oracle DBA - GSFA - Tucker, GA)

Unfortunately for what i know on window binaries are not relinkable.
It is a word apart. Only on Windows Oracle
works with threads, on Unix oracle spawns processes. on unix it is
easy see a similar situation by a "ps aux",
then v$process and V$session . On windows it is a bit more
complicated. (i think that is not possible to kill a thread).
However maybe that the problem is tha same.
Thank you, Eugene

Bye
Cristian Cudizio

http://oracledb.wordpress.comhttp://....wordpress.com

Try using this to see what is going on... They have cmd line progs
but this is very nice.
The find feature has pinpointed a lot of issues for me.
http://www.microsoft.com/technet/sys...sExplorer.mspx

On May 25, 9:42 am, epoko... (AT) excite (DOT) com wrote:

Greetings!

Our databases run on the HP-UX platform and I've seen something
similar on very rare occasions.

I was able to fix it by relinking (recreating) the "oracle" object
file. Never really sure what the root cause ever was. Could have been
due to an earlier patch that never mentioned that a relink was
mandatory.

Not sure what the syntax would be to "relink" in Windows. My expertise
is Unix-oriented. Certainly worth a shot.

Regards,

Eugene Pokopac (Oracle DBA - GSFA - Tucker, GA)

Relink in windows = reinstall.
or you could try regsrving everything, but that's not too fun...

On May 25, 4:30 pm, EscVector <J... (AT) webthere (DOT) com> wrote:

On May 25, 9:42 am, epoko... (AT) excite (DOT) com wrote:



Greetings!

Our databases run on the HP-UX platform and I've seen something
similar on very rare occasions.

I was able to fix it by relinking (recreating) the "oracle" object
file. Never really sure what the root cause ever was. Could have been
due to an earlier patch that never mentioned that a relink was
mandatory.

Not sure what the syntax would be to "relink" in Windows. My expertise
is Unix-oriented. Certainly worth a shot.

Regards,

Eugene Pokopac (Oracle DBA - GSFA - Tucker, GA)

Relink in windows = reinstall.
or you could try regsrving everything, but that's not too fun...

nice program (processExplorer), also light (only 1.5 MB)
it seems that it permits to kill a thread too.
Thanks!

Bye
Cristian Cudizio

http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com