KILL UNNECESSARY SESSION

You want to kill unnecessary session in oracle.
check this



SQL> ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;


You will get sid,serial# from v$session view.

Cheers!!!