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!
|
|
|