{"id":7529,"date":"2016-04-04T16:18:29","date_gmt":"2016-04-04T14:18:29","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/fixed-table-automatic-statistic-gathering-in-12c\/"},"modified":"2016-04-04T16:18:29","modified_gmt":"2016-04-04T14:18:29","slug":"fixed-table-automatic-statistic-gathering-in-12c","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/fixed-table-automatic-statistic-gathering-in-12c\/","title":{"rendered":"Fixed table automatic statistic gathering in 12c"},"content":{"rendered":"<h2>By Franck Pachot<\/h2>\n<p>.<br \/>\nBefore 12c, the fixed stats statistics were not gathered automatically. In 12c this has changed: even when you have never gathered fixed objects statistics you can see that you have statistics for X$ tables. That may be better than having no statistics at all, but it doesn&#8217;t replace manual gathering at the right time.<br \/>\n<!--more--><\/p>\n<h3>Documentation<\/h3>\n<p>First you may have a doubt because the <a href=\"http:\/\/www.oracle.com\/technetwork\/database\/bi-datawarehousing\/twp-bp-for-stats-gather-12c-1967354.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">Best Practices for Gathering Optimizer Statistics with Oracle Database 12c<\/a> white paper, which is by the way excellent, states the following: <em>The automatic statistics gathering job does not gather fixed object statistics.<\/em> <\/p>\n<p>Actually, this was probably written before the new behavior has been implemented. <a href=\"http:\/\/docs.oracle.com\/database\/121\/TGSQL\/tgsql_stats.htm#GUID-ADC86F77-3B71-4BB7-986A-2DD283F0E212\" target=\"_blank\" rel=\"noopener noreferrer\">12c Documentation<\/a> is clear about that: <i>Oracle Database automatically gathers fixed object statistics as part of automated statistics gathering if they have not been previously collected.<\/i><\/p>\n<p>When a table has no statistics, the optimizer usually do dynamic sampling. It&#8217;s not the case with fixed tables. Without statistics it uses pre-defined values. Note that SQL Plan Directives generated for predicates on fixed tables seem to be only of reason &#8216;JOIN CARDINALITY MISESTIMATE&#8217; or &#8216;GROUP BY CARDINALITY MISESTIMATE&#8217; and I&#8217;ve not seen any &#8216;SINGLE TABLE CARDINALITY MISESTIMATE&#8217; for them yet.<\/p>\n<p>I&#8217;ve checked statistics on fixed objects with the following query on multiple databases in 11g and 12c:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureFixedStats20301.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureFixedStats20301.png\" alt=\"CaptureFixedStats20301\" width=\"644\" height=\"319\" class=\"alignnone size-full wp-image-7894\" \/><\/a><br \/>\nHere is the code:<\/p>\n<pre><code>\ncolumn database_creation format a18\ncolumn last_analyzed format a18\nselect dbid,to_char(created,'dd.mm.yyyy hh24:mi') database_creation,version,(select to_char(max(last_analyzed),'dd.mm.yyyy hh24:mi') last_analyzed from dba_tab_statistics where object_type='FIXED TABLE') last_analyzed from v$database,v$instance;\n<\/code><\/pre>\n<p>I know that dbms_stats.gather_fixed_objects_stats has never been run manually on those databases. Here is the result:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureFixedStats20302.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureFixedStats20302.png\" alt=\"CaptureFixedStats20302\" width=\"608\" height=\"508\" class=\"alignnone size-full wp-image-7895\" \/><\/a><\/p>\n<p>The 11g databases have no statistics for fixed objects. The 12c have statistics seem to have been collected on the first maintenance window that came after the database creation.<\/p>\n<p>Here is a full sample on many databases:<\/p>\n<pre><code>\n      DBID DATABASE_CREATION  VERSION           LAST_ANALYZED\t\n3512849711 04.03.2015 14:27   12.1.0.2.0        04.03.2015 22:02\t\n2742730342 27.02.2015 16:25   12.1.0.2.0        27.02.2015 22:01\t\n 947204019 04.03.2015 10:38   11.2.0.4.0\t\n3119262236 23.04.2015 08:45   11.2.0.4.0\t\n3086459761 07.09.2015 10:29   11.2.0.4.0\t\n3834994345 05.05.2015 16:58   11.2.0.4.0\t\n2416611527 23.11.2015 15:09   11.2.0.4.0\t\n1308353219 02.06.2015 08:48   12.1.0.2.0        02.06.2015 22:02\t\n2748602325 02.03.2016 10:56   12.1.0.2.0\t\n2100385935 29.03.2016 10:08   12.1.0.2.0\t\n2693495113 29.07.2015 16:41   12.1.0.2.0        29.07.2015 22:03\t\n1838239625 02.05.2013 10:40   12.1.0.2.0        11.08.2015 11:01\t\n2459965412 06.02.2015 12:36   12.1.0.2.0        06.02.2015 22:01\t\n1973550543 25.09.2015 10:05   12.1.0.2.0        25.09.2015 22:03\t\n2777782141 15.09.2015 10:05   12.1.0.2.0        15.09.2015 22:03\t\n1972863322 20.03.2015 09:33   12.1.0.2.0        07.05.2015 12:14\t\n2598026599 30.04.2015 13:38   12.1.0.2.0        30.04.2015 22:02\t\n 392835176 02.12.2014 09:12   12.1.0.2.0        21.10.2015 22:05\t\n3648145067 26.11.2014 12:38   12.1.0.2.0        18.12.2014 22:00\t\n1427432880 08.01.2015 16:52   12.1.0.2.0        10.03.2015 11:16\t\n3916227032 10.12.2014 10:47   12.1.0.2.0        10.12.2014 22:01\t\n3410982685 13.05.2015 15:00   12.1.0.2.0        13.05.2015 22:03\t\n3818933859 02.12.2015 07:50   11.2.0.4.0\t\n4043114408 20.04.2015 12:06   12.1.0.2.0        20.04.2015 22:01\t\n1021147402 04.01.2016 15:04   12.1.0.2.0\t\n3248561100 05.05.2015 16:31   12.1.0.2.0        12.06.2015 22:02\n<\/code><\/pre>\n<p>Only few exceptions because some databases have the automatic job disabled.<\/p>\n<h3>Conclusion<\/h3>\n<p>We know it for a long time, CBO needs statistics. And it&#8217;s a good idea to gather them when they are not present. However, this is not a reason to do nothing manually. When run at 22:00 (the default beginning of the maintenance window) it&#8217;s probable that many X$ tables do not have the same number of rows than during high activity. Especially when it&#8217;s just after the database has been created and nothing has run yet. Session and processes structures have probably few rows. Memory structures are probably small. Our recommendation is to run dbms_stats.gather_fixed_objects_stats at a time where you have significant activity. Then no need to run it again frequently. If you scaled-up some resource configuration (mode memory, more CPU, higher connection pool) then you may run it again. And don&#8217;t worry, there are some critical tables that are skipped by the gathering process and still use some default.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Franck Pachot . Before 12c, the fixed stats statistics were not gathered automatically. In 12c this has changed: even when you have never gathered fixed objects statistics you can see that you have statistics for X$ tables. That may be better than having no statistics at all, but it doesn&#8217;t replace manual gathering at [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":7532,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[60,96],"type_dbi":[],"class_list":["post-7529","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-12c","tag-oracle"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Fixed table automatic statistic gathering in 12c - dbi Blog<\/title>\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\/fixed-table-automatic-statistic-gathering-in-12c\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fixed table automatic statistic gathering in 12c\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . Before 12c, the fixed stats statistics were not gathered automatically. In 12c this has changed: even when you have never gathered fixed objects statistics you can see that you have statistics for X$ tables. That may be better than having no statistics at all, but it doesn&#8217;t replace manual gathering at [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/fixed-table-automatic-statistic-gathering-in-12c\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-04-04T14:18:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureFixedStats20301-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"644\" \/>\n\t<meta property=\"og:image:height\" content=\"319\" \/>\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\\\/fixed-table-automatic-statistic-gathering-in-12c\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/fixed-table-automatic-statistic-gathering-in-12c\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Fixed table automatic statistic gathering in 12c\",\"datePublished\":\"2016-04-04T14:18:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/fixed-table-automatic-statistic-gathering-in-12c\\\/\"},\"wordCount\":459,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/fixed-table-automatic-statistic-gathering-in-12c\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/CaptureFixedStats20301-1.png\",\"keywords\":[\"12c\",\"Oracle\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/fixed-table-automatic-statistic-gathering-in-12c\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/fixed-table-automatic-statistic-gathering-in-12c\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/fixed-table-automatic-statistic-gathering-in-12c\\\/\",\"name\":\"Fixed table automatic statistic gathering in 12c - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/fixed-table-automatic-statistic-gathering-in-12c\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/fixed-table-automatic-statistic-gathering-in-12c\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/CaptureFixedStats20301-1.png\",\"datePublished\":\"2016-04-04T14:18:29+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/fixed-table-automatic-statistic-gathering-in-12c\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/fixed-table-automatic-statistic-gathering-in-12c\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/fixed-table-automatic-statistic-gathering-in-12c\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/CaptureFixedStats20301-1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/CaptureFixedStats20301-1.png\",\"width\":644,\"height\":319},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/fixed-table-automatic-statistic-gathering-in-12c\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fixed table automatic statistic gathering in 12c\"}]},{\"@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":"Fixed table automatic statistic gathering in 12c - dbi Blog","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\/fixed-table-automatic-statistic-gathering-in-12c\/","og_locale":"en_US","og_type":"article","og_title":"Fixed table automatic statistic gathering in 12c","og_description":"By Franck Pachot . Before 12c, the fixed stats statistics were not gathered automatically. In 12c this has changed: even when you have never gathered fixed objects statistics you can see that you have statistics for X$ tables. That may be better than having no statistics at all, but it doesn&#8217;t replace manual gathering at [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/fixed-table-automatic-statistic-gathering-in-12c\/","og_site_name":"dbi Blog","article_published_time":"2016-04-04T14:18:29+00:00","og_image":[{"width":644,"height":319,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureFixedStats20301-1.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\/fixed-table-automatic-statistic-gathering-in-12c\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/fixed-table-automatic-statistic-gathering-in-12c\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Fixed table automatic statistic gathering in 12c","datePublished":"2016-04-04T14:18:29+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/fixed-table-automatic-statistic-gathering-in-12c\/"},"wordCount":459,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/fixed-table-automatic-statistic-gathering-in-12c\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureFixedStats20301-1.png","keywords":["12c","Oracle"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/fixed-table-automatic-statistic-gathering-in-12c\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/fixed-table-automatic-statistic-gathering-in-12c\/","url":"https:\/\/www.dbi-services.com\/blog\/fixed-table-automatic-statistic-gathering-in-12c\/","name":"Fixed table automatic statistic gathering in 12c - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/fixed-table-automatic-statistic-gathering-in-12c\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/fixed-table-automatic-statistic-gathering-in-12c\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureFixedStats20301-1.png","datePublished":"2016-04-04T14:18:29+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/fixed-table-automatic-statistic-gathering-in-12c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/fixed-table-automatic-statistic-gathering-in-12c\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/fixed-table-automatic-statistic-gathering-in-12c\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureFixedStats20301-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureFixedStats20301-1.png","width":644,"height":319},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/fixed-table-automatic-statistic-gathering-in-12c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Fixed table automatic statistic gathering in 12c"}]},{"@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\/7529","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=7529"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7529\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/7532"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=7529"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=7529"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=7529"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=7529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}