{"id":347,"date":"2024-07-21T15:38:58","date_gmt":"2024-07-21T15:38:58","guid":{"rendered":"https:\/\/humtechno.com\/intro\/?p=347"},"modified":"2024-07-21T15:39:47","modified_gmt":"2024-07-21T15:39:47","slug":"oracle-session-kill","status":"publish","type":"post","link":"https:\/\/humtechno.com\/intro\/2024\/07\/21\/oracle-session-kill\/","title":{"rendered":"Oracle Session Kill"},"content":{"rendered":"\n\n\n\n<p><strong><span style=\"text-decoration: underline;\">Kill Sessions of using Objects From Linux Operating System<\/span><\/strong><\/p>\n\n<p>select \/<em>+rule+<\/em>\/ &#8216;kill -9 &#8216; || c.spid from v$access a , v$session b ,v$process c<br>where a.sid=b.sid<br>and c.addr=b.paddr<br>and a.object like &#8216;%MVTRANSACTIONLOG%&#8217;;<\/p>\n\n<p><strong><span style=\"text-decoration: underline;\">Kill Sessions of Specific Users from Database<\/span><\/strong><\/p>\n\n<p>select &#8216;alter system kill session&#8217; || &#8221;&#8221; || sid || &#8216;,&#8217; || serial# || &#8221;&#8221; || &#8216;immediate;&#8217; , username, sid,serial# from v$session where username =&#8217;NAGIOS&#8217;;<\/p>\n\n<p><strong><span style=\"text-decoration: underline;\">Kill Session Bloking at Database Level<\/span><\/strong><\/p>\n\n<p>select &#8216;alter system kill session&#8217; || &#8221;&#8221; || sid || &#8216;,&#8217; || serial# || &#8221;&#8221; || &#8216;immediate;&#8217;, username, sid,serial#,sql_id , wait_time from v$session where (sid ) in<br>(<br>select blocking_session from v$session<br>);<\/p>\n\n<p>select &#8216;alter system kill session&#8217; || &#8221;&#8221; || sid || &#8216;,&#8217; || serial# || &#8221;&#8221; || &#8216;immediate;&#8217; , username, sid,serial#,sql_id , wait_time from v$session where sid in<br>(select holding_session from dba_blockers);<\/p>\n\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":333,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[3],"tags":[],"class_list":["post-347","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/347","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/comments?post=347"}],"version-history":[{"count":2,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/347\/revisions"}],"predecessor-version":[{"id":349,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/347\/revisions\/349"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media\/333"}],"wp:attachment":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media?parent=347"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/categories?post=347"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/tags?post=347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}