Killing Hana Sessions

You use the command below to obtain the session IDs of idle sessions.

SELECT CONNECTION_ID, IDLE_TIME FROM M_CONNECTIONS WHERE CONNECTION_STATUS = 'IDLE' AND CONNECTION_TYPE = 'Remote'  ORDER BY IDLE_TIME DESC

You disconnect a session. In the statement below you replace with a connection ID from the query above.

ALTER SYSTEM DISCONNECT SESSION   '{connection_id}'

------------------OR----------------

SELECT CURRENT_OPERATOR_NAME FROM M_CONNECTIONS WHERE CONNECTION_STATUS = 'RUNNING'

SELECT CONNECTION_ID FROM "SYS"."M_CONNECTIONS" WHERE CREATOR_THREAD_ID=25529

ALTER SYSTEM CANCEL SESSION '200012'
---OR----
alter system disconnect session '400210'
---OR----
ALTER SYSTEM CANCEL WORK IN SESSION '200012'