Kill Session in Oracle

Retrieve session identifiers and session serial number (which uniquely identifies a session's objects):

select sid, serial# from v$session where username = 'USER'

kill the session:

alter system kill session 'sid,serial#'

Disconnect the session:

alter system disconnect session 'sid,serial#' post_transaction;

alter system disconnect session 'sid,serial#' immediate;

Posted in: Oracle Advanced Concepts,Oracle Notebook,Technical