![]() In addition to the syntax described above, you can add the IMMEDIATE clause. It will then be killed as soon as possible. In these cases the session will have a status of "marked for kill". In some situations, like waiting for a reply from a remote database or rolling back transactions, the session will not kill itself immediately and will wait for the current operation to complete. It merely asks the session to kill itself. SQL> ALTER SYSTEM KILL SESSION KILL SESSION command doesn't actually kill the session. This allows you to kill a session on different RAC node. In a RAC environment, you optionally specify the INST_ID, shown when querying the GV$SESSION view. SQL> ALTER SYSTEM KILL SESSION 'sid,serial#' The basic syntax for killing a session is shown below. Multithreaded Model using THREADED_EXECUTION in Oracle Database 12c Release 1 (12.1). ![]()
0 Comments
Leave a Reply. |