Oracle : How to kill a session.

Select * from v$sessions.

or

select 'Alter System kill session ' || '''' || sid || ',' || serial# || ''':' || from v$sesion where username='NameOfUserWhoseSessionNeedsToBeKilled'