{"id":14467,"date":"2020-08-07T17:53:35","date_gmt":"2020-08-07T15:53:35","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/"},"modified":"2020-08-07T17:53:35","modified_gmt":"2020-08-07T15:53:35","slug":"merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/","title":{"rendered":"Merge-Statement crashes with ORA-7445 [kdu_close] caused by Real Time Statistics?"},"content":{"rendered":"<p>In a recent project we migrated an Oracle database previously running on 12.1.0.2 on an Oracle Database Appliance to an Exadata X8 with DB version 19.7. Shortly after the migration a merge-statement (upsert) failed with an <\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nORA-07445: exception encountered: core dump [kdu_close()+107] [SIGSEGV] [ADDR:0xE0] [PC:0x1276AE6B] [Address not mapped to object] [] \n<\/pre>\n<p>The stack looked as follows:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nkdu_close - updThreePhaseExe - upsexe - opiexe - kpoal8 - opiodr - ttcpip - opitsk - opiino - opiodr - opidrv - sou2o - opimai_real - ssthrdmain - main - __libc_start_main - _start\n<\/pre>\n<p>As experienced Oracle DBAs know an ORA-7445 error is usually caused by an Oracle bug (defect). Searching in My Oracle Support didn&#8217;t reveal much for module &#8220;kdu_close&#8221; and the associated error stack. Working on a Service Request (SR) with Oracle Support hasn&#8217;t provided a solution or workaround to the issue so far as well. Checking <a href=\"http:\/\/orafun.info\/\">Orafun<\/a> also didn&#8217;t provide much insight about kdu_close other than the fact that we are in the area of the code about kernel data update (kdu).<\/p>\n<p>As the merge crashed at the end of its processing (from earlier successful executions we knew how long the statement usually takes) I setup the hypothesis that this issue might be related to the 19c new feature Real Time Statistics on Exadata. To verify if the hypothesis is correct, I did some tests first with Real Time Statistics and merge-statements in my environment to see if they do work as expected and if we can disable them with a hint:<\/p>\n<p>1.) Enable Exadata Features<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nalter system set \"_exadata_feature_on\"=TRUE scope=spfile;\nshutdown immediate\nstartup\n<\/pre>\n<p>2.) Test if a merge-statement triggers real time statistics<\/p>\n<p>I setup a table tab1 and tab2 similar to the setup on <a href=\"https:\/\/oracle-base.com\/articles\/19c\/real-time-statistics-19c\">Oracle-Base<\/a> and run a merge statement, which actually updates 1000 rows:<\/p>\n<p>Initially we just have statistics on tab1 from dbms_stats.gather_table_stats. Here e.g. the columns:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\ntestuser1@orcl@orcl&gt; select column_name, last_analyzed, notes from user_tab_col_statistics where table_name='TAB1';\n\nCOLUMN_NAME      LAST_ANALYZED       NOTES\n---------------- ------------------- ----------------------------------------------------------------\nID               07.08.2020 17:29:37\nDESCRIPTION      07.08.2020 17:29:37\n<\/pre>\n<p>Then I ran the merge:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\ntestuser1@orcl@orcl&gt; merge\n  2  into\ttab1\n  3  using\ttab2\n  4  on\t(tab1.id = tab2.id)\n  5  when matched then\n  6  \t     update set tab1.description = tab2.description\n  7  WHEN NOT MATCHED THEN\n  8  \t INSERT (  id, description )\n  9  \t VALUES ( tab2.id, tab2.description )\n 10  ;\n\n1000 rows merged.\n\ntestuser1@orcl@orcl&gt; commit;\n\nCommit complete.\n\ntestuser1@orcl@orcl&gt; exec dbms_stats.flush_database_monitoring_info;\n\nPL\/SQL procedure successfully completed.\n\ntestuser1@orcl@orcl&gt; select column_name, last_analyzed, notes from user_tab_col_statistics where table_name='TAB1';\n\nCOLUMN_NAME      LAST_ANALYZED       NOTES\n---------------- ------------------- ----------------------------------------------------------------\nID               07.08.2020 17:29:37\nDESCRIPTION      07.08.2020 17:29:37\nID               07.08.2020 17:37:34 STATS_ON_CONVENTIONAL_DML\nDESCRIPTION      07.08.2020 17:37:34 STATS_ON_CONVENTIONAL_DML\n<\/pre>\n<p>So obviously Real Time Statistics gathering was triggered. <\/p>\n<p>After the verification that merge statements trigger statistics to be gathered in real time I disabled Real Time Statistics on that specific merge-statement by adding the hint <\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\n\/*+ NO_GATHER_OPTIMIZER_STATISTICS *\/\n<\/pre>\n<p>to it. <\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\ntestuser1@orcl@orcl&gt; select column_name, last_analyzed, notes from user_tab_col_statistics where table_name='TAB1';\n\nCOLUMN_NAME      LAST_ANALYZED       NOTES\n---------------- ------------------- ----------------------------------------------------------------\nID               07.08.2020 17:46:38\nDESCRIPTION      07.08.2020 17:46:38\n\ntestuser1@orcl@orcl&gt; merge \/*+ NO_GATHER_OPTIMIZER_STATISTICS *\/\n  2  into\ttab1\n  3  using\ttab2\n  4  on\t(tab1.id = tab2.id)\n  5  when matched then\n  6  \t     update set tab1.description = tab2.description\n  7  WHEN NOT MATCHED THEN\n  8  \t INSERT (  id, description )\n  9  \t VALUES ( tab2.id, tab2.description )\n 10  ;\n\n1000 rows merged.\n\ntestuser1@orcl@orcl&gt; commit;\n\nCommit complete.\n\ntestuser1@orcl@orcl&gt; exec dbms_stats.flush_database_monitoring_info;\n\nPL\/SQL procedure successfully completed.\n\ntestuser1@orcl@orcl&gt; select column_name, last_analyzed, notes from user_tab_col_statistics where table_name='TAB1';\n\nCOLUMN_NAME      LAST_ANALYZED       NOTES\n---------------- ------------------- ----------------------------------------------------------------\nID               07.08.2020 17:46:38\nDESCRIPTION      07.08.2020 17:46:38\n<\/pre>\n<p>So the hint works as expected.<\/p>\n<p>The statement of the real application was generated and could not be modified, so I had to create a SQL-Patch to add the hint at parse-time to it:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nvar rv varchar2(32);\nbegin\n   :rv:=dbms_sqldiag.create_sql_patch(sql_id=&gt;'13szq2g6xbsg5',\n                                      hint_text=&gt;'NO_GATHER_OPTIMIZER_STATISTICS',\n                                      name=&gt;'disable_real_time_stats_on_merge',\n                                      description=&gt;'disable real time stats');\nend;\n\/\nprint rv\n<\/pre>\n<p>REMARK: If a statement is no longer in the shared pool, but available in the AWR history, you may use below method to create the sql patch:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">\nvar rv varchar2(32);\ndeclare\n   v_sql CLOB;\nbegin\n   select sql_text into v_sql from dba_hist_sqltext where sql_id='13szq2g6xbsg5';\n   :rv:=dbms_sqldiag.create_sql_patch(\n             sql_text  =&gt; v_sql,\n             hint_text=&gt;'NO_GATHER_OPTIMIZER_STATISTICS',\n             name=&gt;'disable_real_time_stats_on_merge',\n             description=&gt;'disable real time stats');\nend;\n\/\nprint rv\n<\/pre>\n<p>It turned out that disabling Real Time Statistics actually worked around the ORA-7445 issue. It might be a coincidence and positive side effect that disabling Real Time Statistics worked around the issue, but for the moment we can cope with it and hope that this information helps to resolve the opened SR so that we get a permanent fix from Oracle for this defect.<\/p>\n<h2>Update 24.08.2020<\/h2>\n<p>The opened SR has been updated with the following info:<br \/>\nThe Development team confirmed that the error ORA-7445 [KDU_CLOSE] is due to an invalid pointer passed to the failing function kdu_close() from updThreePhaseExe(). This is caused by BUG 31237127, which is still under investigation by Oracle development. Once the bug is fixed My Oracle Support Note 31237127.8 will be available with details. There is no workaround available.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In a recent project we migrated an Oracle database previously running on 12.1.0.2 on an Oracle Database Appliance to an Exadata X8 with DB version 19.7. Shortly after the migration a merge-statement (upsert) failed with an ORA-07445: exception encountered: core dump [kdu_close()+107] [SIGSEGV] [ADDR:0xE0] [PC:0x1276AE6B] [Address not mapped to object] [] The stack looked as [&hellip;]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[752,2052,96,2053],"type_dbi":[],"class_list":["post-14467","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-merge","tag-ora-7445","tag-oracle","tag-real-time-statistics"],"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>Merge-Statement crashes with ORA-7445 [kdu_close] caused by Real Time Statistics? - 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\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Merge-Statement crashes with ORA-7445 [kdu_close] caused by Real Time Statistics?\" \/>\n<meta property=\"og:description\" content=\"In a recent project we migrated an Oracle database previously running on 12.1.0.2 on an Oracle Database Appliance to an Exadata X8 with DB version 19.7. Shortly after the migration a merge-statement (upsert) failed with an ORA-07445: exception encountered: core dump [kdu_close()+107] [SIGSEGV] [ADDR:0xE0] [PC:0x1276AE6B] [Address not mapped to object] [] The stack looked as [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-08-07T15:53:35+00:00\" \/>\n<meta name=\"author\" content=\"Clemens Bleile\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ifgtxD2SrQ8r!YuXj\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Clemens Bleile\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 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\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/\"},\"author\":{\"name\":\"Clemens Bleile\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"headline\":\"Merge-Statement crashes with ORA-7445 [kdu_close] caused by Real Time Statistics?\",\"datePublished\":\"2020-08-07T15:53:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/\"},\"wordCount\":502,\"commentCount\":0,\"keywords\":[\"MERGE\",\"ora-7445\",\"Oracle\",\"real time statistics\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/\",\"name\":\"Merge-Statement crashes with ORA-7445 [kdu_close] caused by Real Time Statistics? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2020-08-07T15:53:35+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Merge-Statement crashes with ORA-7445 [kdu_close] caused by Real Time Statistics?\"}]},{\"@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\/0ac04011f60f2e93c115358d0789c2da\",\"name\":\"Clemens Bleile\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"caption\":\"Clemens Bleile\"},\"description\":\"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.\",\"sameAs\":[\"https:\/\/www.dbi-services.com\",\"https:\/\/x.com\/ifgtxD2SrQ8r!YuXj\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/clemens-bleile\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Merge-Statement crashes with ORA-7445 [kdu_close] caused by Real Time Statistics? - 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\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/","og_locale":"en_US","og_type":"article","og_title":"Merge-Statement crashes with ORA-7445 [kdu_close] caused by Real Time Statistics?","og_description":"In a recent project we migrated an Oracle database previously running on 12.1.0.2 on an Oracle Database Appliance to an Exadata X8 with DB version 19.7. Shortly after the migration a merge-statement (upsert) failed with an ORA-07445: exception encountered: core dump [kdu_close()+107] [SIGSEGV] [ADDR:0xE0] [PC:0x1276AE6B] [Address not mapped to object] [] The stack looked as [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/","og_site_name":"dbi Blog","article_published_time":"2020-08-07T15:53:35+00:00","author":"Clemens Bleile","twitter_card":"summary_large_image","twitter_creator":"@ifgtxD2SrQ8r!YuXj","twitter_misc":{"Written by":"Clemens Bleile","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/"},"author":{"name":"Clemens Bleile","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"headline":"Merge-Statement crashes with ORA-7445 [kdu_close] caused by Real Time Statistics?","datePublished":"2020-08-07T15:53:35+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/"},"wordCount":502,"commentCount":0,"keywords":["MERGE","ora-7445","Oracle","real time statistics"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/","url":"https:\/\/www.dbi-services.com\/blog\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/","name":"Merge-Statement crashes with ORA-7445 [kdu_close] caused by Real Time Statistics? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2020-08-07T15:53:35+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/merge-statement-crashes-with-ora-7445-kdu_close-caused-by-real-time-statistics\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Merge-Statement crashes with ORA-7445 [kdu_close] caused by Real Time Statistics?"}]},{"@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\/0ac04011f60f2e93c115358d0789c2da","name":"Clemens Bleile","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","caption":"Clemens Bleile"},"description":"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.","sameAs":["https:\/\/www.dbi-services.com","https:\/\/x.com\/ifgtxD2SrQ8r!YuXj"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/clemens-bleile\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14467","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\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=14467"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14467\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=14467"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=14467"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=14467"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=14467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}