How to kill your hung oracle session

Use v$session to find the logged in users and their sessions.

SQL> SELECT s.sid,
2 s.serial#,
3 s.osuser,
4 s.program
5 FROM v$session s;

Then kill the session using the alter system command 

SQL> alter system kill session '34,3464'; [sid, serial#]