ORA-00027 cannot kill current session
Cause: An attempt was made to use ALTER SYSTEM KILL SESSION to kill the
current session.
Action: If it is necessary to kill the current session, do so from another session.
Identify which session to kill using following query :-
SQL> select s.sid, s.serial#, spid, trim(s.machine) machine, trim(s.module) module, status from v$session s, v$process p where paddr=addr and module is not null order by 1,2
Kill that session :-
ALTER SYSTEM KILL SESSION 'sid,serial#';
Or Kill at OS level on linux using
kill -9 spid
No comments:
Post a Comment