{"id":4359,"date":"2022-10-09T12:00:18","date_gmt":"2022-10-09T10:00:18","guid":{"rendered":"http:\/\/rootfan.com\/?p=4359"},"modified":"2022-10-09T12:00:56","modified_gmt":"2022-10-09T10:00:56","slug":"obtenir-le-sql_id-dune-requete-dans-oracle","status":"publish","type":"post","link":"https:\/\/rootfan.com\/fr\/get-the-sql_id-of-a-query-in-oracle\/","title":{"rendered":"Comment obtenir le sql_id d'une requ\u00eate dans Oracle ?"},"content":{"rendered":"<p>Vous pouvez avoir besoin d'obtenir le sql_id d'une requ\u00eate dans Oracle pour r\u00e9soudre un probl\u00e8me de performance ou simplement pour v\u00e9rifier certaines statistiques.<\/p>\n\n\n\n<p>C'est la fa\u00e7on la plus simple de proc\u00e9der.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>Vous interrogez v$sql avec un texte dont vous savez qu'il est contenu dans votre requ\u00eate.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT sql_id, plan_hash_value, SUBSTR(sql_text,1,40) Text\nFROM v$sql\nWHERE sql_text LIKE &#039;%&An_Identifiable_String%&#039;;\n<\/pre><\/div>\n\n\n<p>Si vous ne le trouvez pas dans la requ\u00eate ci-dessus, vous pouvez utiliser cette autre requ\u00eate qui va encore plus loin dans le pass\u00e9.<\/p>\n\n\n\n<p>Il s'agit d'une requ\u00eate qui associe dba_hist_sqlstat et dba_hist_sqltext.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT\n    s.sql_id,\n    s.plan_hash_value,\n    t.sql_text,\n    s.snap_id\nFROM\n    dba_hist_sqlstat   s,\n    dba_hist_sqltext   t\nWHERE s.dbid = t.dbid\nAND   s.sql_id = t.sql_id\nAND   sql_text LIKE &#039;SELECT \/* TARGET SQL *\/%&#039;\nORDER BY\n    s.sql_id;\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Vous pouvez avoir besoin d'obtenir le sql_id d'une requ\u00eate dans Oracle pour r\u00e9soudre un probl\u00e8me de performance ou simplement pour v\u00e9rifier quelques statistiques. Voici la mani\u00e8re la plus simple de le faire.<\/p>","protected":false},"author":1,"featured_media":4368,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"","rank_math_title":"","rank_math_description":"Retrieve the sql_id of a query in Oracle and gain insights into query performance for optimization.","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":[18],"class_list":["post-4359","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-tuning"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-747964.jpeg?fit=1880%2C1187&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/4359","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=4359"}],"version-history":[{"count":5,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/4359\/revisions"}],"predecessor-version":[{"id":4371,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/4359\/revisions\/4371"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media\/4368"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media?parent=4359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/categories?post=4359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/tags?post=4359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}