Sunday, 27 September 2015

Get all connected user session list in oracle and kill oracle session

Get list of session active in oracle

you can get the list of active session from v$session table;

select 'alter system kill session '''|| sid ||',', serial#||'''' from v$session;

Kill the active session in oracle 

below statement will kill the live session.

alter system kill session '325,250';