Kill user session

Use this procedure to find and kill a user's session:

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

SQLPLUS> alter system kill session 'SID,SERIAL#';