on 02-20-2013 3:51 PM
Hi,
I am thinking that connections and sessions are same as displayed in Studio's performance tab.
Is it true that one connection will have mutiple threads as displayed in Studio.
Sometimes I cannot go to studio to kill the thread so can i use M_CONNECTIONS to kill the thread at os level using SQL command.?
Please clarify.
Regards
SS
Hi SS,
Connection and session is similar and you can have many threads running on it.
You use M_CONNECTIONS to find the session to kill and use what command?
There's no option to kill a thread directly, the options are to kill entire session/connection or the running process (may have nothing, but when we want kill something for sure will).
ALTER SYSTEM CANCEL SESSION '<connection_id>'
ALTER SYSTEM DISCONNECT SESSION '<connection_id>'
Regards, Fernando Da Rós
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for the clarification that threads canot be killed at LINUX using SQL.
There must be some method to view the threads at OS level using SQL command or something.
My point is that how one will connect the Threads and M_CONNECTIONS. This is the only to find that which one is the culprit.
Yoru help will greately appreciated.
Best Regards
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.