-- Sessions that are running for long period of time have to be stopped or
-- killed in order to analyze the long running process or to re-design the 
-- query.  It is also necessary when new code needs to be implemented, 
-- typically long executing scheduled BI reports may have to be stopped 
-- that users cannot stop.

SELECT inst_id, sid, serial#, username
FROM gv$session 
WHERE username is not null;

-- Using output from the above query, use values for sid, serial# and 
-- inst_id in the alter system command shown below.

ALTER SYSTEM KILL SESSION  'sid,serial#,@inst_id';



ALTER SYSTEM KILL SESSION  '9,329,@1';

-- Check to see if the session is active by getting sysdate from dual.

SELECT SYSDATE FROM DUAL;