{"id":1030,"date":"2020-10-24T15:58:22","date_gmt":"2020-10-24T13:58:22","guid":{"rendered":"http:\/\/rootfan.com\/?p=1030"},"modified":"2022-04-04T00:10:50","modified_gmt":"2022-04-03T22:10:50","slug":"matar-sesion-oracle-rac","status":"publish","type":"post","link":"https:\/\/rootfan.com\/es\/kill-session-oracle-rac\/","title":{"rendered":"C\u00f3mo Matar una Sesi\u00f3n en una Base de Datos Oracle RAC"},"content":{"rendered":"<p>Si necesitas matar una sesi\u00f3n en una base de datos Oracle RAC, primero necesitas saber el SID, Serial# y la instancia donde se est\u00e1 ejecutando la sesi\u00f3n.<\/p>\n\n\n\n<p>Puedes obtener esa informaci\u00f3n dependiendo de lo que te den, veamos algunas opciones.<\/p>\n\n\n\n<p>Si conoce el SID, puede obtener los dem\u00e1s valores con esta consulta<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect sid,serial#,inst_id \nfrom gv$session \nwhere sid=&#039;1195&#039;;\n<\/pre><\/div>\n\n\n<p>Ahora supongamos que usted tiene el serial# entonces utilice esta consulta<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect sid,serial#,inst_id, sql_id \nfrom gv$session \nwhere serial#=&#039;15148&#039;;\n<\/pre><\/div>\n\n\n<p>En caso de que tengas el nombre de usuario, utiliza esta consulta, podr\u00edas a\u00f1adir el logon_time a la consulta<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect sid,serial#,inst_id \nfrom gv$session \nwhere USERNAME=&#039;username&#039;;\n<\/pre><\/div>\n\n\n<!--more-->\n\n\n\n<p>O tal vez se le da el SQL_ID, entonces usted puede obtener los detalles con esta consulta<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nselect sid,serial#,inst_id \nfrom gv$session \nwhere SQL_ID=&#039;gryb9nc9udsgu&#039;;\n<\/pre><\/div>\n\n\n<p>Una vez que conozca el SID, serial# y el ID de instancia, este es el comando para cerrar la sesi\u00f3n<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nalter system kill session &#039;SID,serial#,@instance&#039; IMMEDIATE;\n<\/pre><\/div>\n\n\n<p>Sustituir en consecuencia<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nalter system kill session &#039;325,24996,@2&#039; IMMEDIATE;\n<\/pre><\/div>\n\n\n<p>A continuaci\u00f3n, puede comprobar de nuevo si la sesi\u00f3n sigue apareciendo en gv$session.<\/p>","protected":false},"excerpt":{"rendered":"<p>Si necesitas matar una sesi\u00f3n en una base de datos Oracle RAC primero necesitas saber el SID, Serial# y la instancia donde se est\u00e1 ejecutando la sesi\u00f3n. Puedes obtener esa informaci\u00f3n dependiendo de lo que te den, veamos algunas opciones. Si conoces el SID, entonces puedes obtener los otros valores ... <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/rootfan.com\/es\/kill-session-oracle-rac\/\" class=\"more-link\">Seguir leyendo<span class=\"screen-reader-text\"> \"C\u00f3mo Matar una Sesi\u00f3n en Base de Datos Oracle RAC\"<\/span><\/a><\/p>","protected":false},"author":1,"featured_media":2920,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"","rank_math_title":"","rank_math_description":"Kill a session in Oracle RAC database with ease. Follow this guide to terminate unwanted sessions and improve database performance.","rank_math_robots":"","rank_math_og_title":"","rank_math_og_description":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[31],"tags":[59,54,60],"class_list":["post-1030","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-kill","tag-rac","tag-session"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-270815.jpeg?fit=1880%2C1259&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/1030","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/comments?post=1030"}],"version-history":[{"count":8,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/1030\/revisions"}],"predecessor-version":[{"id":1088,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/1030\/revisions\/1088"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media\/2920"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media?parent=1030"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/categories?post=1030"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/tags?post=1030"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}