Home » Infrastructure » Windows » can't find the session of a Thread ID (ora 9.2.0.6 Windows 2003 Server)
can't find the session of a Thread ID [message #475272] Tue, 14 September 2010 02:11
pelle23
Messages: 3
Registered: June 2005
Junior Member
Hello,

on my Oracle Server there are 2 Oracle Threads using 100% of one CPU all the time.

I would like to see what session or query making that trouble on my system.

I use qslice to get the thread- Id of the 2 thread's, are d30 and 100.

So I use the query

select * from v$session a, v$process b where a.paddr=b.addr

to look to the spid to find the corresponding session.

I know, fist I need to calc the thrad- id to decimal.

So

100 = 256
d30 = 3376

But howevery I can't find any session for that threads.

I tried orakill to kill that threads, but not possible.

So my questions are:

How can I see what type of thread is using the cpu?
What could be the reason of that expensive cpu usage.


Thanks!

Previous Topic: problems with oracle 8i on my windows xp system
Next Topic: How can I test if a database is running on Windows
Goto Forum:
  


Current Time: Sun Sep 26 23:59:49 CDT 2021