-- 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
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;