[Oracle DBA] Kill all sessions for a specific user/application

Select them like:

collumn TOT format A60

COLUMN USERNAME FORMAT A10

select 'Alter system kill session '||CHR(39)||SID||','||SERIAL#||CHR(39) TOT, username, osuser, machine from v$session where username='PMSEEADMIN';

Then

run all the resulting commands

Alter system kill session '55,558' ;

Alter system kill session '66,3003' ;

Alter system kill session '68,3822' ;

Alter system kill session '69,1648' ;

Alter system kill session '73,1320' ;

Alter system kill session '97,3689' ;

Alter system kill session '120,2671';

This blog is public but use at your own risk.