先强行杀掉连接的会话.DECLARE
TYPE V_CURSOR IS REF CURSOR;
MYCUR V_CURSOR;
V_DDL VARCHAR2(2000);
BEGIN
OPEN MYCUR FOR
SELECT 'alter system kill session ''' || SID || ',' || SERIAL# || ''';'
FROM V$SESSION
WHERE USERNAME IS NOT NULL
AND STATUS = 'INACTIVE'
AND LAST_CALL_ET / 60 / 60 >= 6;
LOOP
FETCH MYCUR
INTO V_DDL;
EXIT WHEN MYCUR%NOTFOUND;
EXECUTE IMMEDIATE V_DDL;
END LOOP;
CLOSE MYCUR;
END;
TYPE V_CURSOR IS REF CURSOR;
MYCUR V_CURSOR;
V_DDL VARCHAR2(2000);
BEGIN
OPEN MYCUR FOR
SELECT 'alter system kill session ''' || SID || ',' || SERIAL# || ''';'
FROM V$SESSION
WHERE USERNAME IS NOT NULL
AND STATUS = 'INACTIVE'
AND LAST_CALL_ET / 60 / 60 >= 6;
LOOP
FETCH MYCUR
INTO V_DDL;
EXIT WHEN MYCUR%NOTFOUND;
EXECUTE IMMEDIATE V_DDL;
END LOOP;
CLOSE MYCUR;
END;
select sid,serial# from v$session where username='user_name'
alter system kill session 'sid,serial#'
drop user user_name
否则只有想楼上那样了.
不过,我已找到解决的方法了,先不说,看大家能否想到一块去.
怎么着,就随意啦,哈哈!
操作如下:
SQL>alter user username account lock;
SQL>alter system kill 'sid,serial#'