![]() ![]() ![]() Then kill the process(in Linux) / thread(in Windows) Spid is process ID on Linux, and thread ID on Windows. In addition, the syntax diagram suggests both clauses are optional, but in reality, one or both must be specified or you receive an error. The POST_TRANSACTION and IMMEDIATE clauses can be used together, but the documentation states that in this case the IMMEDIATE clause is ignored. IMMEDIATE clause disconnects the session and ongoing transactions are rolled back immediately. POST_TRANSACTION clause waits for ongoing transactions to complete before disconnecting the session. The basic syntax is similar to the KILL SESSION command with the addition of the POST_TRANSACTION clause. Unlike the KILL SESSION command which asks the session to kill itself, the DISCONNECT SESSION command kills the dedicated server process, which is equivalent to killing the server process from the operating system. The ALTER SYSTEM DISCONNECT SESSION syntax is an alternative method for killing Oracle sessions. 'kill -9 '||PROCESSES.spid AS "Linux Kill"ĪLTER SYSTEM DISCONNECT SESSION 'sid,serial#' IMMEDIATE Įither POST_TRANSACTION or IMMEDIATE must be used. 'ALTER SYSTEM KILL SESSION '''||SESSIONS.sid||','||rial#||''' IMMEDIATE ' AS "DB Kill", ORA-01940: cannot drop a user that is currently connected 'orakill '||INSTANCE_NAME||' '||v_process.spid AS "orakill command", 'kill -9 '||v_process.spid AS "LINUX Kill", ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |