{"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":"obtener-sql_id-de-una-consulta-en-oracle","status":"publish","type":"post","link":"https:\/\/rootfan.com\/es\/get-the-sql_id-of-a-query-in-oracle\/","title":{"rendered":"C\u00f3mo Obtener el sql_id de una Consulta en Oracle"},"content":{"rendered":"<p>Es posible que necesite obtener el sql_id de una consulta en Oracle para solucionar alg\u00fan problema de rendimiento o simplemente para comprobar algunas estad\u00edsticas.<\/p>\n\n\n\n<p>Esta es la forma m\u00e1s sencilla de hacerlo.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>Usted consulta v$sql con alg\u00fan texto que sabe que contiene su consulta.<\/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 no lo encuentras en la consulta anterior, puedes utilizar esta otra consulta que va a\u00fan m\u00e1s al pasado.<\/p>\n\n\n\n<p>Es una consulta que une dba_hist_sqlstat y 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>Es posible que necesite obtener el sql_id de una consulta en Oracle para solucionar alg\u00fan problema de rendimiento o simplemente para comprobar algunas estad\u00edsticas. Esta es la forma m\u00e1s sencilla de hacerlo.<\/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\/es\/wp-json\/wp\/v2\/posts\/4359","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=4359"}],"version-history":[{"count":5,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/4359\/revisions"}],"predecessor-version":[{"id":4371,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/4359\/revisions\/4371"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media\/4368"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media?parent=4359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/categories?post=4359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/tags?post=4359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}