Kill Session Oracle

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
Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.