{"id":14156,"date":"2020-05-13T17:00:50","date_gmt":"2020-05-13T15:00:50","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/20c-awr-now-stores-explain-plan-predicates\/"},"modified":"2020-05-13T17:00:50","modified_gmt":"2020-05-13T15:00:50","slug":"20c-awr-now-stores-explain-plan-predicates","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/20c-awr-now-stores-explain-plan-predicates\/","title":{"rendered":"20c: AWR now stores explain plan predicates"},"content":{"rendered":"<h2>By Franck Pachot<\/h2>\n<p>.<br \/>\nIn a previous post <a href=\"https:\/\/www.dbi-services.com\/blog\/awr-dont-store-explain-plan-predicates\/\" rel=\"noopener noreferrer\" target=\"_blank\">https:\/\/www.dbi-services.com\/blog\/awr-dont-store-explain-plan-predicates\/<\/a> I explained this limitation in gathering filter and access predicates by Statspack and then AWR because of old bugs about reverse parsing of predicates. Oracle listens to its customers through support (enhancement requests), though the community (votes on database ideas), and through the product managers who participate in User Groups and ACE program. And here it is: in 20c the predicates are collected by AWS and visible with DBMS_XPLAN and AWRSQRPT reports.<\/p>\n<p>I&#8217;ll test with a very simple query on the 20c preview available in the Oracle Cloud DBaaS:<\/p>\n<pre><code>\nset feedback on sql_id echo on pagesize 1000\n\nSQL&gt; select * from dual where ascii(dummy)=42;\n\nno rows selected\n\nSQL_ID: g4gx2zqbkjwh1\n<\/code><\/pre>\n<p>I used the &#8220;FEEDBACK ON SQL&#8221; feature to get the SQL_ID.<\/p>\n<p>Because this query is fast, it will not be gathered by AWR except if I &#8216;color&#8217; it:<\/p>\n<pre><code>\nSQL&gt; exec dbms_workload_repository.add_colored_sql('g4gx2zqbkjwh1');\n\nPL\/SQL procedure successfully completed.\n<\/code><\/pre>\n<p>Coloring a statement is the AWR feature to use when you want to get a statement always gathered, for example when you have optimized it and want compare the statistics.<\/p>\n<p>Now running the statement between two snapshots:<\/p>\n<pre><code>\nSQL&gt; exec dbms_workload_repository.create_snapshot;\n\nPL\/SQL procedure successfully completed.\n\nSQL&gt; select * from dual where ascii(dummy)=42;\n\nno rows selected\n\nSQL&gt; exec dbms_workload_repository.create_snapshot;\n\nPL\/SQL procedure successfully completed.\n<\/code><\/pre>\n<p>Here, I&#8217;m sure it has been gathered.<\/p>\n<p>Now checking the execution plan:<\/p>\n<pre><code>\nSQL&gt; select * from dbms_xplan.display_awr('g4gx2zqbkjwh1');\n\nPLAN_TABLE_OUTPUT\n--------------------------------------------------------------------------------\nSQL_ID g4gx2zqbkjwh1\n--------------------\nselect * from dual where ascii(dummy)=42\n\nPlan hash value: 272002086\n\n--------------------------------------------------------------------------\n| Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |\n--------------------------------------------------------------------------\n|   0 | SELECT STATEMENT  |      |       |       |     2 (100)|          |\n|*  1 |  TABLE ACCESS FULL| DUAL |     1 |     2 |     2   (0)| 00:00:01 |\n--------------------------------------------------------------------------\n\nPredicate Information (identified by operation id):\n---------------------------------------------------\n\n   1 - filter(ASCII(\"DUMMY\")=42)\n\n\n18 rows selected.\n<\/code><\/pre>\n<p>Here I have the predicate. This is a silly example but the predicate information is very important when looking at a large execution plan trying to understand the cardinality estimation or the reason why an index is not used.<\/p>\n<p>Of course, this is also visible from the ?\/rdbms\/admin\/awrsqrpt report:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Annotation-2020-05-12-205338.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Annotation-2020-05-12-205338.jpg\" alt=\"\" width=\"1024\" height=\"720\" class=\"aligncenter size-large wp-image-39666\" \/><\/a><\/p>\n<h3>What if you upgrade?<\/h3>\n<p>AWR gathers the SQL Plan only when it is not already there. Then, when we will update to 20c only the new plans will get the predicates. Here is an example where I simulate the pre-20c behaviour with &#8220;_cursor_plan_unparse_enabled&#8221;=false:<\/p>\n<pre><code>\nSQL&gt; alter session set \"_cursor_plan_unparse_enabled\"=false;\n\nSession altered.\n\nSQL&gt; exec dbms_workload_repository.add_colored_sql('g4gx2zqbkjwh1');\n\nPL\/SQL procedure successfully completed.\n\nSQL&gt; exec dbms_workload_repository.create_snapshot;\n\nPL\/SQL procedure successfully completed.\n\nSQL&gt; select * from dual where ascii(dummy)=42;\n\nno rows selected\n\nSQL&gt; exec dbms_workload_repository.create_snapshot;\n\nPL\/SQL procedure successfully completed.\n\nSQL&gt; select * from dbms_xplan.display_awr('g4gx2zqbkjwh1');\n\nPLAN_TABLE_OUTPUT\n--------------------------------------------------------------------------------\nSQL_ID g4gx2zqbkjwh1\n--------------------\nselect * from dual where ascii(dummy)=42\n\nPlan hash value: 272002086\n\n--------------------------------------------------------------------------\n| Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |\n--------------------------------------------------------------------------\n|   0 | SELECT STATEMENT  |      |       |       |     2 (100)|          |\n|   1 |  TABLE ACCESS FULL| DUAL |     1 |     2 |     2   (0)| 00:00:01 |\n--------------------------------------------------------------------------\n\n13 rows selected.\n<\/code><\/pre>\n<p>No predicate here. Even If I re-connect to reset the &#8220;_cursor_plan_unparse_enabled&#8221;:<\/p>\n<pre><code>\nSQL&gt; connect \/ as sysdba\nConnected.\nSQL&gt; exec dbms_workload_repository.create_snapshot;\n\nPL\/SQL procedure successfully completed.\n\nSQL&gt; select * from dual where ascii(dummy)=42;\n\nno rows selected\n\nSQL&gt; exec dbms_workload_repository.create_snapshot;\n\nPL\/SQL procedure successfully completed.\n\nSQL&gt; select * from dbms_xplan.display_awr('g4gx2zqbkjwh1');\n\nPLAN_TABLE_OUTPUT\n--------------------------------------------------------------------------------\nSQL_ID g4gx2zqbkjwh1\n--------------------\nselect * from dual where ascii(dummy)=42\n\nPlan hash value: 272002086\n\n--------------------------------------------------------------------------\n| Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |\n--------------------------------------------------------------------------\n|   0 | SELECT STATEMENT  |      |       |       |     2 (100)|          |\n|   1 |  TABLE ACCESS FULL| DUAL |     1 |     2 |     2   (0)| 00:00:01 |\n--------------------------------------------------------------------------\n\n13 rows selected.\n<\/code><\/pre>\n<p>This will be the situation after upgrade.<\/p>\n<p>If you want to re-gather all sql_plans, you need to purge the AWR repository:<\/p>\n<pre><code>\nSQL&gt; execute dbms_workload_repository.drop_snapshot_range(1,1e22);\n\nPL\/SQL procedure successfully completed.\n\nSQL&gt; execute dbms_workload_repository.purge_sql_details();\n\nPL\/SQL procedure successfully completed.\n\nSQL&gt; commit;\n\n<\/code><\/pre>\n<p>This clears everything, so I do not recommend to do that at the same time as the upgrade as you may like to compare some performance with the past. Anyway, we have time and maybe this fix will be backported in 19c.<\/p>\n<p>There are very small chances that fix is ported to Statspack, but you can do it yourself as I mentioned in <a href=\"http:\/\/viewer.zmags.com\/publication\/dd9ed62b#\/dd9ed62b\/36\" rel=\"noopener noreferrer\" target=\"_blank\">http:\/\/viewer.zmags.com\/publication\/dd9ed62b#\/dd9ed62b\/36<\/a> (&#8220;on Improving Statspack Experience&#8221;) with something like:<\/p>\n<pre><code>\nsed -i -e 's\/ 0 -- should be\/\/' -e 's\/[(]2254299[)]\/--&amp;\/' $ORACLE_HOME\/rdbms\/admin\/spcpkg.sql\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>By Franck Pachot . In a previous post https:\/\/www.dbi-services.com\/blog\/awr-dont-store-explain-plan-predicates\/ I explained this limitation in gathering filter and access predicates by Statspack and then AWR because of old bugs about reverse parsing of predicates. Oracle listens to its customers through support (enhancement requests), though the community (votes on database ideas), and through the product managers who [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":14157,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[1763,422,451,96,1171,458],"type_dbi":[],"class_list":["post-14156","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-20c","tag-awr","tag-dbms_xplan","tag-oracle","tag-oracle-19c","tag-oracle-20c"],"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>20c: AWR now stores explain plan predicates - 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\/20c-awr-now-stores-explain-plan-predicates\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"20c: AWR now stores explain plan predicates\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . In a previous post https:\/\/www.dbi-services.com\/blog\/awr-dont-store-explain-plan-predicates\/ I explained this limitation in gathering filter and access predicates by Statspack and then AWR because of old bugs about reverse parsing of predicates. Oracle listens to its customers through support (enhancement requests), though the community (votes on database ideas), and through the product managers who [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/20c-awr-now-stores-explain-plan-predicates\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-05-13T15:00:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Annotation-2020-05-12-205338.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1957\" \/>\n\t<meta property=\"og:image:height\" content=\"1376\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"4 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\\\/20c-awr-now-stores-explain-plan-predicates\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/20c-awr-now-stores-explain-plan-predicates\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"20c: AWR now stores explain plan predicates\",\"datePublished\":\"2020-05-13T15:00:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/20c-awr-now-stores-explain-plan-predicates\\\/\"},\"wordCount\":406,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/20c-awr-now-stores-explain-plan-predicates\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Annotation-2020-05-12-205338.jpg\",\"keywords\":[\"20c\",\"AWR\",\"dbms_xplan\",\"Oracle\",\"Oracle 19c\",\"Oracle 20c\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/20c-awr-now-stores-explain-plan-predicates\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/20c-awr-now-stores-explain-plan-predicates\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/20c-awr-now-stores-explain-plan-predicates\\\/\",\"name\":\"20c: AWR now stores explain plan predicates - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/20c-awr-now-stores-explain-plan-predicates\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/20c-awr-now-stores-explain-plan-predicates\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Annotation-2020-05-12-205338.jpg\",\"datePublished\":\"2020-05-13T15:00:50+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/20c-awr-now-stores-explain-plan-predicates\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/20c-awr-now-stores-explain-plan-predicates\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/20c-awr-now-stores-explain-plan-predicates\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Annotation-2020-05-12-205338.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/Annotation-2020-05-12-205338.jpg\",\"width\":1957,\"height\":1376},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/20c-awr-now-stores-explain-plan-predicates\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"20c: AWR now stores explain plan predicates\"}]},{\"@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":"20c: AWR now stores explain plan predicates - 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\/20c-awr-now-stores-explain-plan-predicates\/","og_locale":"en_US","og_type":"article","og_title":"20c: AWR now stores explain plan predicates","og_description":"By Franck Pachot . In a previous post https:\/\/www.dbi-services.com\/blog\/awr-dont-store-explain-plan-predicates\/ I explained this limitation in gathering filter and access predicates by Statspack and then AWR because of old bugs about reverse parsing of predicates. Oracle listens to its customers through support (enhancement requests), though the community (votes on database ideas), and through the product managers who [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/20c-awr-now-stores-explain-plan-predicates\/","og_site_name":"dbi Blog","article_published_time":"2020-05-13T15:00:50+00:00","og_image":[{"width":1957,"height":1376,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Annotation-2020-05-12-205338.jpg","type":"image\/jpeg"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/20c-awr-now-stores-explain-plan-predicates\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/20c-awr-now-stores-explain-plan-predicates\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"20c: AWR now stores explain plan predicates","datePublished":"2020-05-13T15:00:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/20c-awr-now-stores-explain-plan-predicates\/"},"wordCount":406,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/20c-awr-now-stores-explain-plan-predicates\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Annotation-2020-05-12-205338.jpg","keywords":["20c","AWR","dbms_xplan","Oracle","Oracle 19c","Oracle 20c"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/20c-awr-now-stores-explain-plan-predicates\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/20c-awr-now-stores-explain-plan-predicates\/","url":"https:\/\/www.dbi-services.com\/blog\/20c-awr-now-stores-explain-plan-predicates\/","name":"20c: AWR now stores explain plan predicates - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/20c-awr-now-stores-explain-plan-predicates\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/20c-awr-now-stores-explain-plan-predicates\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Annotation-2020-05-12-205338.jpg","datePublished":"2020-05-13T15:00:50+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/20c-awr-now-stores-explain-plan-predicates\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/20c-awr-now-stores-explain-plan-predicates\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/20c-awr-now-stores-explain-plan-predicates\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Annotation-2020-05-12-205338.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Annotation-2020-05-12-205338.jpg","width":1957,"height":1376},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/20c-awr-now-stores-explain-plan-predicates\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"20c: AWR now stores explain plan predicates"}]},{"@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\/14156","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=14156"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14156\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/14157"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=14156"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=14156"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=14156"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=14156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}