The command to kill Oracle is simple:
ALTER SYSTEM KILL SESSION ‘&sid,&serial’;
sid – session ID serial – session serial number
If the version 11g and this is RAC, additional syntax is possible:
ALTER SYSTEM KILL SESSION ‘&sid,&serial,@&inst_id’;
inst_id – instance id number (1, 2, 3 …)
Script to find the […]