{"id":2125,"date":"2014-07-25T18:23:01","date_gmt":"2014-07-25T16:23:01","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/"},"modified":"2023-10-06T09:32:09","modified_gmt":"2023-10-06T07:32:09","slug":"sql-monitoring-12102-shows-adaptive-plans","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/","title":{"rendered":"SQL monitoring 12.1.0.2 shows adaptive plans"},"content":{"rendered":"<h2>By Franck Pachot<\/h2>\n<p>.<br \/>\nIn a previous <a href=\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-adaptive-plan-inflexion-point\/\">post<\/a>, I have described Adaptive Plans. Even if I prefer to show plans with the SQL Monitor active html format, I had to stick with the dbms_xplan for that because SQL Monitoring did not show all information about adaptive plans.<\/p>\n<p>This has been fixed in the Patchset 1 and I have run the same query to show the new feature.<\/p>\n<p>First, an adaptive plan can be in two states: &#8216;resolving&#8217; where all alternatives are possible and &#8216;resolved&#8217; then the final plan has been choosen. It is resolved once the first execution statistics collector has made the decision about the inflection point. We can see the state in the SQL Monitor header:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"CaptureSqlmonAPStatus.PNG\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSqlmonAPStatus.png\"><img decoding=\"async\" title=\"CaptureSqlmonAPStatus.PNG\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSqlmonAPStatus.png\" alt=\"CaptureSqlmonAPStatus.PNG\" \/><\/a><\/p>\n<p>Here my plan is resolved because the first execution is finished.<\/p>\n<p>The plan with rowsource statistics show only the current plan, but the &#8216;Plan Note&#8217; shows that it is an adaptive plan:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"CaptureSqlmonAP.PNG\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSqlmonAP.png\"><img decoding=\"async\" title=\"CaptureSqlmonAP.PNG\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSqlmonAP.png\" alt=\"CaptureSqlmonAP.PNG\" \/><\/a><\/p>\n<p>Now we have to go to the &#8216;Plan&#8217; tab which show the equivalent of dbms_xplan.display_cursor:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"CaptureSqlmonAPFull.PNG\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSqlmonAPFull.png\"><img decoding=\"async\" title=\"CaptureSqlmonAPFull.PNG\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSqlmonAPFull.png\" alt=\"CaptureSqlmonAPFull.PNG\" \/><\/a><\/p>\n<p>Here the format is equivalent to format=&gt;&#8217;adaptive&#8217;. It&#8217;s the &#8216;Full&#8217; plan where all branches are shown but inactive part is grayed. We have here the Statistics Collector after reading DEPARTMENTS, and we have the inactive full table scan hash join of EMPLOYEES.<\/p>\n<p>Just choose the &#8216;Final&#8217; Plan (or &#8216;Current&#8217; if it is not yet resolved) to get only the active part:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"CaptureSqlmonAPFinal.PNG\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSqlmonAPFinal.png\"><img decoding=\"async\" title=\"CaptureSqlmonAPFinal.PNG\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSqlmonAPFinal.png\" alt=\"CaptureSqlmonAPFinal.PNG\" \/><\/a><\/p>\n<p>I often prefer the tabular format to the graphical one:<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"CaptureSqlmonAPTabular.PNG\" href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSqlmonAPTabular.png\"><img decoding=\"async\" title=\"CaptureSqlmonAPTabular.PNG\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSqlmonAPTabular.png\" alt=\"CaptureSqlmonAPTabular.PNG\" \/><\/a><\/p>\n<p>We have all information: the 7 rows from DEPARTMENTS have gone through STATISTICS COLLECTOR and NESTED LOOP with index access has been choosen. Note that it is different from the previous post where HASH JOIN with full table scan was choosen because the 7 rows were higher than the inflection point.<\/p>\n<p>In my current example, because I have system statistics that costs full table scan higher:<\/p>\n<p><samp>DP: Found point of inflection for NLJ vs. HJ: card = 8.35<\/samp><\/p>\n<p>This is higher than ny 7 rows from DEPARTMENTS.<br \/>\nHere is the whole sqlmon report:\u00a0<a title=\"title\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/139\/sqlmon.zip\" target=\"_self\" rel=\"noopener noreferrer\">sqlmon.zip<\/a>\u00a0and how I got it:<\/p>\n<pre><code>alter session set current_schema=HR;\n select \/*+ monitor *\/ distinct DEPARTMENT_NAME from DEPARTMENTS\n join EMPLOYEES using(DEPARTMENT_ID)\n where DEPARTMENT_NAME like '%ing' and SALARY&gt;20000;\nalter session set events='emx_control compress_xml=none';set pagesize 0 linesize 10000 trimspool on serveroutput off long 100000000 longc 100000000 echo off feedback off\n spool sqlmon.htm\n select dbms_sqltune.report_sql_monitor(report_level=&gt;'all',type=&gt;'html') from dual;\n spool off<\/code><\/pre>\n<pre><code><\/code><\/pre>\n<p>Note that I used the script exposed <a href=\"\/best-practice-to-send-an-oracle-execution-plan\">here<\/a> and I used the emx_event\u00a0to get the uncompressed xml, which I got from Tyler Muth:<\/p>\n<blockquote lang=\"en\"><p><a href=\"https:\/\/twitter.com\/FranckPachot\">@FranckPachot<\/a> well, I asked <a href=\"https:\/\/twitter.com\/DBAKevlar\">@DBAKevlar<\/a>, she asked the developer that owns it \ud83d\ude09<\/p>\n<p>\u2014 tmuth (@tmuth) <a href=\"https:\/\/twitter.com\/tmuth\/statuses\/492759150997168128\">July 25, 2014<\/a><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>By Franck Pachot . In a previous post, I have described Adaptive Plans. Even if I prefer to show plans with the SQL Monitor active html format, I had to stick with the dbms_xplan for that because SQL Monitoring did not show all information about adaptive plans. This has been fixed in the Patchset 1 [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":2126,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198,59],"tags":[209],"type_dbi":[],"class_list":["post-2125","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","category-oracle","tag-oracle-12c"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL monitoring 12.1.0.2 shows adaptive plans - dbi Blog<\/title>\n<meta name=\"description\" content=\"Oracle 12c Patchset 1 shows Adaptive Plans in SQL Monitor\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL monitoring 12.1.0.2 shows adaptive plans\" \/>\n<meta property=\"og:description\" content=\"Oracle 12c Patchset 1 shows Adaptive Plans in SQL Monitor\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2014-07-25T16:23:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-06T07:32:09+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSqlmonAPStatus.png\" \/>\n\t<meta property=\"og:image:width\" content=\"462\" \/>\n\t<meta property=\"og:image:height\" content=\"137\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"SQL monitoring 12.1.0.2 shows adaptive plans\",\"datePublished\":\"2014-07-25T16:23:01+00:00\",\"dateModified\":\"2023-10-06T07:32:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/\"},\"wordCount\":381,\"commentCount\":2,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSqlmonAPStatus.png\",\"keywords\":[\"Oracle 12c\"],\"articleSection\":[\"Database management\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/\",\"name\":\"SQL monitoring 12.1.0.2 shows adaptive plans - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSqlmonAPStatus.png\",\"datePublished\":\"2014-07-25T16:23:01+00:00\",\"dateModified\":\"2023-10-06T07:32:09+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"Oracle 12c Patchset 1 shows Adaptive Plans in SQL Monitor\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSqlmonAPStatus.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSqlmonAPStatus.png\",\"width\":462,\"height\":137},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL monitoring 12.1.0.2 shows adaptive plans\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL monitoring 12.1.0.2 shows adaptive plans - dbi Blog","description":"Oracle 12c Patchset 1 shows Adaptive Plans in SQL Monitor","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/","og_locale":"en_US","og_type":"article","og_title":"SQL monitoring 12.1.0.2 shows adaptive plans","og_description":"Oracle 12c Patchset 1 shows Adaptive Plans in SQL Monitor","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/","og_site_name":"dbi Blog","article_published_time":"2014-07-25T16:23:01+00:00","article_modified_time":"2023-10-06T07:32:09+00:00","og_image":[{"width":462,"height":137,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSqlmonAPStatus.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"SQL monitoring 12.1.0.2 shows adaptive plans","datePublished":"2014-07-25T16:23:01+00:00","dateModified":"2023-10-06T07:32:09+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/"},"wordCount":381,"commentCount":2,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSqlmonAPStatus.png","keywords":["Oracle 12c"],"articleSection":["Database management","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/","name":"SQL monitoring 12.1.0.2 shows adaptive plans - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSqlmonAPStatus.png","datePublished":"2014-07-25T16:23:01+00:00","dateModified":"2023-10-06T07:32:09+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"Oracle 12c Patchset 1 shows Adaptive Plans in SQL Monitor","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSqlmonAPStatus.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureSqlmonAPStatus.png","width":462,"height":137},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-monitoring-12102-shows-adaptive-plans\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL monitoring 12.1.0.2 shows adaptive plans"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2125","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2125"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2125\/revisions"}],"predecessor-version":[{"id":28454,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2125\/revisions\/28454"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2126"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2125"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2125"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2125"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2125"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}