SELECT s.inst_id,
s.sid,
s.serial#,
p.spid,
S.Username,
S.Program,
'exec rdsadmin.rdsadmin_util.kill('||s.sid||','||s.serial#||');' as Execute_command
FROM gv$session s
Join Gv$process P On P.Addr = S.Paddr And P.Inst_Id = S.Inst_Id
Where S.Type != 'BACKGROUND'
AND s.username = UPPER('&Username');
Example Output:
Execute the output in EXECUTE_COMMAND column as script to kill all session from the user.