{"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":"kill-session-oracle-rac","status":"publish","type":"post","link":"https:\/\/rootfan.com\/fr\/kill-session-oracle-rac\/","title":{"rendered":"Comment tuer une session dans une base de donn\u00e9es Oracle RAC ?"},"content":{"rendered":"<p>Si vous avez besoin de tuer une session dans la base de donn\u00e9es Oracle RAC, vous devez d'abord conna\u00eetre le SID, Serial# et l'instance dans laquelle la session s'ex\u00e9cute.<\/p>\n\n\n\n<p>Vous pouvez obtenir ces informations en fonction de ce que l'on vous donne, voyons quelques options.<\/p>\n\n\n\n<p>Si vous connaissez le SID, vous pouvez obtenir les autres valeurs \u00e0 l'aide de la requ\u00eate suivante<\/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>Supposons que vous ayez le num\u00e9ro de s\u00e9rie # et que vous utilisiez la requ\u00eate suivante<\/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>Si vous avez le nom d'utilisateur, utilisez cette requ\u00eate, vous pouvez ajouter l'heure de connexion \u00e0 la requ\u00eate.<\/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>Ou alors, si l'on vous donne l'identifiant SQL_ID, vous pouvez obtenir les d\u00e9tails \u00e0 l'aide de cette requ\u00eate<\/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>Une fois que vous connaissez le SID, serial# et l'ID de l'instance, voici la commande pour tuer la session<\/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>Remplacer en cons\u00e9quence<\/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>Vous pouvez ensuite v\u00e9rifier \u00e0 nouveau si la session est toujours affich\u00e9e dans gv$session.<\/p>","protected":false},"excerpt":{"rendered":"<p>Si vous avez besoin de tuer une session dans la base de donn\u00e9es Oracle RAC, vous devez d'abord conna\u00eetre le SID, Serial# et l'instance o\u00f9 la session est en cours d'ex\u00e9cution. Vous pouvez obtenir ces informations en fonction de ce qui vous est donn\u00e9, voyons quelques options. Si vous connaissez le SID, vous pouvez obtenir les autres valeurs ... <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/rootfan.com\/fr\/kill-session-oracle-rac\/\" class=\"more-link\">Continuer la lecture<span class=\"screen-reader-text\"> de \" Comment tuer une session dans une base de donn\u00e9es 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\/fr\/wp-json\/wp\/v2\/posts\/1030","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/comments?post=1030"}],"version-history":[{"count":8,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/1030\/revisions"}],"predecessor-version":[{"id":1088,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/1030\/revisions\/1088"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media\/2920"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media?parent=1030"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/categories?post=1030"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/tags?post=1030"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}