ORA-00027: cannot kill current session

This forum is for Database developer ( PostgreSQL, MySQL, SQL Server, Oracle etc...) and database Administrator
forum_admin
Site Admin
Posts: 185
Joined: Wed Jul 16, 2014 9:22 pm
Contact:

ORA-00027: cannot kill current session

Postby forum_admin » Fri Aug 15, 2014 9:18 pm

error code: ORA-00027
getting ORA-00027: cannot kill current session error in oracle DB. how to resolve it?


Guest

Re: ORA-00027: cannot kill current session

Postby Guest » Fri Aug 15, 2014 9:23 pm

Cause: Attempted to use ALTER SYSTEM KILL SESSION to kill the current session.
Action: you can't kill own session.

So, If you want to kill the current session, you will need to open another session and use the sql from the other session.

Code: Select all

SQL> select sid, serial#, process, type from v$session where sid=437;

       SID      SERIAL#     PROCESS                  TYPE
----------   ----------      ------------------------ ----------
       437        420       6124:3196                USER


SQL> alter system kill session '437, 420';
alter system kill session '437, 420'

*
ERROR at line 1:
ORA-00027: cannot kill current session


Return to “PostgreSQL, MySQL, SQL Server, SQL,PL/SQL, TeraData Developer and DataBase Administration”

Who is online

Users browsing this forum: No registered users and 1 guest