cancel
Showing results for 
Search instead for 
Did you mean: 

threads vs session - for SAP

former_member186487
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member182114
Active Contributor
0 Kudos

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

former_member186487
Participant
0 Kudos

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