OraFAQ Forum: Windows » can't find the session of a Thread ID

Home » Infrastructure » Windows » can't find the session of a Thread ID (ora 9.2.0.6 Windows 2003 Server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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!

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 03:50:23 CDT 2024