The Oracle DBA wants to kill a session that is consuming abnormally too many resources.
alter system kill session SID, SERIAL# [MyRACInstance]' [immediate];
SID, SERIAL# are provided by gV$SESSION
select Sid, Serial#, machine, program, inst_id
from gv$session
The third and optional parameter is for RAC environment
You can also kill the process directly with the operating system command:
$ ps-ef # and
$ kill -9 myPID