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