Kill Oracle session using Session ID


SQL> select sid,serial#,username,status,sql_hash_value from v$session where sid=153;

SID SERIAL# USERNAME STATUS SQL_HASH_VALUE
---- --------- ---------- -------- --------------
153 1885 THEUSER ACTIVE 3021386057

SQL> alter system kill session '153,1885';

System altered.

No comments: