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. ORA-00027 comes under "Oracle Database Server Messages".
These messages are generated by the Oracle database server when running any Oracle program. How to kill session: 1. identify which session to kill using following query: 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 2. Killing a session ALTER SYSTEM KILL SESSION 'sid,serial#'; or you can kill at OS level on linux using kill -9 spid
Related Post: - Stopping Query without killing the session
why we need to kill any session ??
ReplyDeletebecause may be some one is executing a query you need to stop
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDeleteI wwas examining some of your articles on this website and
ReplyDeleteI believe this website iis really instructive!
Retain putting up.
am using this "ALTER SYSTEM KILL SESSION 'sid,serial#';" but not get a result,
ReplyDeleteany other options .
Import Globals is one of the leading import export data provider for India, Brazil, USA, and Kenya. For more information visit our website.
ReplyDeleteIndia Import Data
Electricians can install and maintain security systems, including surveillance cameras and alarm systems. EV Charger Installation
ReplyDelete