SQL> select 'alter system kill session '||chr(39) ||sid||','||serial#||chr(39) ||';' from v$session where username='TEST';
'ALTERSYSTEMKILLSESSION'||CHR(39)||SID||','||SERIAL#||CHR(39)||';'
--------------------------------------------------------------------------------
alter system kill session '46,323';
'ALTERSYSTEMKILLSESSION'||CHR(39)||SID||','||SERIAL#||CHR(39)||';'
--------------------------------------------------------------------------------
alter system kill session '46,323';