{"id":502,"date":"2024-12-21T04:02:15","date_gmt":"2024-12-21T04:02:15","guid":{"rendered":"https:\/\/w3buddy.com\/?p=502"},"modified":"2026-01-15T13:12:08","modified_gmt":"2026-01-15T07:42:08","slug":"kill-or-disconnect-oracle-session-single-instance-rac","status":"publish","type":"post","link":"https:\/\/w3buddy.com\/blog\/kill-or-disconnect-oracle-session-single-instance-rac\/","title":{"rendered":"Kill or Disconnect Oracle Session in Single Instance &amp; RAC"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Managing sessions in Oracle databases is essential for database administrators. This guide provides concise commands for both single-instance and RAC (Real Application Clusters) environments to kill or disconnect sessions forcefully or gracefully.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Single-Instance Oracle<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To kill a session immediately:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-sql\">ALTER SYSTEM KILL SESSION 'SID,SERIAL#' IMMEDIATE;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">To disconnect a session gracefully (waiting for transactions to complete):<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-sql\">ALTER SYSTEM DISCONNECT SESSION 'SID,SERIAL#' POST_TRANSACTION;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">To disconnect a session immediately:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-sql\">ALTER SYSTEM DISCONNECT SESSION 'SID,SERIAL#' IMMEDIATE;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Oracle RAC<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To kill a session in RAC, include the INST_ID for the target instance:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-sql\">SELECT 'ALTER SYSTEM KILL SESSION ''' || sid || ',' || serial# || ',@' || inst_id || ''' IMMEDIATE;'\nFROM gv$session\nWHERE sid = &amp;sid AND serial# = &serial;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">For active sessions only:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-sql\">SELECT 'ALTER SYSTEM KILL SESSION ''' || sid || ',' || serial# || ',@' || inst_id || ''' IMMEDIATE;'\nFROM gv$session\nWHERE sid = &amp;sid AND serial# = &amp;serial AND status = 'ACTIVE';<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">To disconnect a session in RAC:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">ALTER SYSTEM DISCONNECT SESSION &#8216;SID,SERIAL#,@INST_ID&#8217; IMMEDIATE;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Key Notes<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>IMMEDIATE<\/strong>: Use for forceful termination or disconnection.<\/li>\n\n\n\n<li><strong>POST_TRANSACTION<\/strong>: Use for graceful disconnection.<\/li>\n\n\n\n<li><strong>RAC<\/strong>: Always include INST_ID to specify the instance in multi-instance environments.<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">These commands enable efficient management of sessions across both single-instance and RAC Oracle environments.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Managing sessions in Oracle databases is essential for database administrators. This guide provides concise commands for both single-instance and RAC (Real Application Clusters) environments to kill or disconnect sessions forcefully or gracefully. Single-Instance Oracle To kill a session immediately: To disconnect a session gracefully (waiting for transactions to complete): To disconnect a session immediately: Oracle [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"googlesitekit_rrm_CAowu461DA:productID":"","footnotes":""},"categories":[1225],"tags":[],"class_list":["post-502","post","type-post","status-publish","format-standard","hentry","category-database"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/502","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/comments?post=502"}],"version-history":[{"count":3,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/502\/revisions"}],"predecessor-version":[{"id":1505,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/502\/revisions\/1505"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=502"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=502"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/tags?post=502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}