The syntax to kill a session in oracle database is :

ALTER SYSTEM KILL SESSION ‘SID,SERIAL#’ IMMEDIATE;

EXAMPLE:

First get the sid and serial# of the session;

Here the session is executing the query SELECT * FROM DBACLASS;

Use the below query to get the sid and serial# of this sql query.