Kayshav.com
About Developer Oracle 11g Technology Information Sitemap

Manage Session - Kill
-- 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';

Oracle 11g Sessions Seen in system Login

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

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

SELECT SYSDATE FROM DUAL;

Oracle 11g Sessions Seen in sys Login


Long Operations - Query

Oracle 11gXEr2 - Index

Oracle registered trademark of Oracle Corporation.

Last Revised On: May 31, 2015

  39899