{"id":7540,"date":"2016-04-08T21:25:20","date_gmt":"2016-04-08T19:25:20","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/"},"modified":"2016-04-08T21:25:20","modified_gmt":"2016-04-08T19:25:20","slug":"oracle-kernel-relink-on-linux-are-my-options-stored-persistently","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/","title":{"rendered":"Oracle kernel relink on Linux: Are my options stored persistently?"},"content":{"rendered":"<p>I recently visited an Oracle presentation about the Oracle-kernel built-in directNFS (dNFS) driver. To use dNFS in the database you have to enable it:<\/p>\n<p><code><br \/>\ncd $ORACLE_HOME\/rdbms\/lib<br \/>\nmake -f ins_rdbms.mk dnfs_on<br \/>\n<\/code><\/p>\n<p>REMARK: In versions before 11gR2\/12c the following manual steps were necessary:<\/p>\n<p><code><br \/>\ncd $ORACLE_HOME\/lib<br \/>\nmv libodm11.so libodm11.so_stub<br \/>\nln \u2013s libnfsodm11.so libodm11.so<br \/>\n<\/code><\/p>\n<p>In the context of make-commands, somebody in the audience asked the question how Oracle persistently stores the current link options, so that a future relink won&#8217;t undo previous settings. E.g. when relinking without the partitioning option, will another relink include the objects again? As nobody had a good answer, I thought I&#8217;ll check that on Linux.<\/p>\n<p>REMARK: Below tests were done on 12.1.0.2.<\/p>\n<p>If options are linked in to the Oracle kernel (e.g. OLAP or Partitioning) is actually stored in the archive $ORACLE_HOME\/rdbms\/lib\/libknlopt.a. <\/p>\n<p>I.e. if I do relink the Oracle kernel without OLAP with the commands<\/p>\n<p><code><br \/>\n$ cd $ORACLE_HOME\/rdbms\/lib<br \/>\n$ make -f ins_rdbms.mk olap_off ioracle<br \/>\n<\/code><\/p>\n<p>I can see the following first steps:<\/p>\n<p><code><br \/>\n\/usr\/bin\/ar d $ORACLE_HOME\/rdbms\/lib\/libknlopt.a xsyeolap.o<br \/>\n\/usr\/bin\/ar cr $ORACLE_HOME\/rdbms\/lib\/libknlopt.a $ORACLE_HOME\/rdbms\/lib\/xsnoolap.o<br \/>\n<\/code><\/p>\n<p>The object xsyeolap.o is removed from $ORACLE_HOME\/rdbms\/lib\/libknlopt.a and object $ORACLE_HOME\/rdbms\/lib\/xsnoolap.o added to it. The link command $ORACLE_HOME\/bin\/orald contains then the following argument:<\/p>\n<p><code><br \/>\n-lknlopt `if \/usr\/bin\/ar tv $ORACLE_HOME\/rdbms\/lib\/libknlopt.a | grep xsyeolap.o &gt; \/dev\/null 2&gt;&amp;1 ; then echo \"-loraolap12\" ; fi`<br \/>\n<\/code><\/p>\n<p>I.e. if object xsyeolap.o is in $ORACLE_HOME\/rdbms\/lib\/libknlopt.a then the argument -loraolap12 is added to the link command. As xsyeolap.o is no longer in  $ORACLE_HOME\/rdbms\/lib\/libknlopt.a (it has been replaced with xsnoolap.o), the current and future link-commands won&#8217;t link OLAP into the kernel.<\/p>\n<p>Obviously adding OLAP again will include the xsyeolap.o to the library $ORACLE_HOME\/rdbms\/lib\/libknlopt.a again:<\/p>\n<p><code><br \/>\n$ make -f ins_rdbms.mk olap_on ioracle<br \/>\n\/usr\/bin\/ar d $ORACLE_HOME\/rdbms\/lib\/libknlopt.a xsnoolap.o<br \/>\n\/usr\/bin\/ar cr $ORACLE_HOME\/lib\/libknlopt.a $ORACLE_HOME\/rdbms\/lib\/xsyeolap.o<br \/>\n...<br \/>\n$ORACLE_HOME\/bin\/orald -o $ORACLE_HOME\/rdbms\/lib\/oracle ... -lknlopt `if \/usr\/bin\/ar tv $ORACLE_HOME\/rdbms\/lib\/libknlopt.a | grep xsyeolap.o &gt; \/dev\/null 2&gt;&amp;1 ; then echo \"-loraolap12\" ; fi` ...<br \/>\n<\/code><\/p>\n<p>What happens if the script $ORACLE_HOME\/bin\/relink with argument &#8220;all&#8221; is being used?<\/p>\n<p>Actually the relink script uses a perl script $ORACLE_HOME\/install\/modmakedeps.pl which generates a file $ORACLE_HOME\/install\/current_makeorder.xml. At the beginning of modmakedeps.pl I can see the following command:<\/p>\n<p><code><br \/>\n# initial hash populated with options from libknlopt<br \/>\nmy %opts_hash = ( 'kcsm.o' =&gt; 'rac_off\/rac_on',<br \/>\n                  'kzlilbac.o' =&gt; 'lbac_off\/lbac_on',<br \/>\n                  'kzvidv.o' =&gt; 'dv_off\/dv_on',<br \/>\n                  'kxmwsd.o' =&gt; 'sdo_off\/sdo_on',<br \/>\n                  'xsyeolap.o' =&gt; 'olap_off\/olap_on',<br \/>\n                  'kkpoban.o' =&gt; 'part_off\/part_on',<br \/>\n                  'dmwdm.o' =&gt; 'dm_off\/dm_on',<br \/>\n                  'kecwr.o' =&gt; 'rat_off\/rat_on',<br \/>\n                  'ksnkcs.o' =&gt; 'rac_on\/rac_off',<br \/>\n                  'kzlnlbac.o' =&gt; 'lbac_on\/lbac_off',<br \/>\n                  'kzvndv.o' =&gt; 'dv_on\/dv_off',<br \/>\n                  'kxmnsd.o' =&gt; 'sdo_on\/sdo_off',<br \/>\n                  'xsnoolap.o' =&gt; 'olap_on\/olap_off',<br \/>\n                  'ksnkkpo.o' =&gt; 'part_on\/part_off',<br \/>\n                  'dmndm.o' =&gt; 'dm_on\/dm_off',<br \/>\n                  'kecnr.o' =&gt; 'rat_on\/rat_off',<br \/>\n                  'jox.o' =&gt; 'jox_on\/jox_off' );<br \/>\n<\/code><\/p>\n<p>I.e. we have the following 2 lines in there:<\/p>\n<p><code><br \/>\n                  'xsyeolap.o' =&gt; 'olap_off\/olap_on',<br \/>\n                  'xsnoolap.o' =&gt; 'olap_on\/olap_off',<br \/>\n<\/code><\/p>\n<p>What that means is that the script uses the list in %opts_hash to check what the current objects are in $ORACLE_HOME\/rdbms\/lib\/libknlopt.a. Depending on the current objects in the archive it checks the original installation settings $ORACLE_HOME\/inventory\/make\/makeorder.xml and generates a new file with the necessary changes in $ORACLE_HOME\/install\/current_makeorder.xml. E.g. if xsyeolap.o is in $ORACLE_HOME\/rdbms\/lib\/libknlopt.a, but $ORACLE_HOME\/inventory\/make\/makeorder.xml has olap_off then create a copy of $ORACLE_HOME\/inventory\/make\/makeorder.xml in $ORACLE_HOME\/install\/current_makeorder.xml with olap_off changed to olap_on. If xsnoolap.o is in the archive but olap_on in $ORACLE_HOME\/inventory\/make\/makeorder.xml then generate $ORACLE_HOME\/install\/current_makeorder.xml with olap_off. Finally the relink happens using the runInstaller:<\/p>\n<p><code><br \/>\n$ORACLE_HOME\/oui\/bin\/runInstaller -relink -waitForCompletion -maketargetsxml $ORACLE_HOME\/install\/current_makeorder.xml -logDir $ORACLE_HOME\/install ORACLE_HOME=$ORACLE_HOME<br \/>\n<\/code><\/p>\n<p>If you want to see what options are currently set in your libknlopt.a you may do the following:<\/p>\n<p><code><br \/>\n$ $ORACLE_HOME\/perl\/bin\/perl $ORACLE_HOME\/install\/modmakedeps.pl $ORACLE_HOME $ORACLE_HOME\/inventory\/make\/makeorder.xml &gt; \/tmp\/currentmakeorder.xml<br \/>\n$ grep TARGETNAME \/tmp\/currentmakeorder.xml |  grep -E \"(_on|_off)\" | cut -d\"\"\" -f4<br \/>\n<\/code><\/p>\n<p>On my ORACLE_HOME the output of the last command ablove looks as follows:<\/p>\n<p><code><br \/>\nrat_on<br \/>\npart_on<br \/>\ndm_on<br \/>\nolap_on<br \/>\nsdo_on<br \/>\nrac_off<br \/>\ndnfs_off<br \/>\nctx_on<br \/>\n<\/code><\/p>\n<p>In case you want to relink the Oracle kernel with the original installation settings then use<\/p>\n<p><code><br \/>\n$ relink as_installed<br \/>\n<\/code><\/p>\n<p>The runinstaller will use the original $ORACLE_HOME\/inventory\/make\/makeorder.xml as the argument for -maketargetsxml then.<\/p>\n<p>So no worries if you have to relink the oracle kernel several times with different options. Previous settings are stored persistently in the archive $ORACLE_HOME\/rdbms\/lib\/libknlopt.a. If you don&#8217;t remember what changes you have done and want to go back to the installation settings then use <\/p>\n<p><code><br \/>\n$ relink as_installed<br \/>\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I recently visited an Oracle presentation about the Oracle-kernel built-in directNFS (dNFS) driver. To use dNFS in the database you have to enable it: cd $ORACLE_HOME\/rdbms\/lib make -f ins_rdbms.mk dnfs_on REMARK: In versions before 11gR2\/12c the following manual steps were necessary: cd $ORACLE_HOME\/lib mv libodm11.so libodm11.so_stub ln \u2013s libnfsodm11.so libodm11.so In the context of make-commands, [&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":[229,198,59],"tags":[796,797,96,798],"type_dbi":[],"class_list":["post-7540","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","category-oracle","tag-link","tag-make","tag-oracle","tag-relink"],"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>Oracle kernel relink on Linux: Are my options stored persistently? - 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\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle kernel relink on Linux: Are my options stored persistently?\" \/>\n<meta property=\"og:description\" content=\"I recently visited an Oracle presentation about the Oracle-kernel built-in directNFS (dNFS) driver. To use dNFS in the database you have to enable it: cd $ORACLE_HOME\/rdbms\/lib make -f ins_rdbms.mk dnfs_on REMARK: In versions before 11gR2\/12c the following manual steps were necessary: cd $ORACLE_HOME\/lib mv libodm11.so libodm11.so_stub ln \u2013s libnfsodm11.so libodm11.so In the context of make-commands, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-04-08T19:25:20+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\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/\"},\"author\":{\"name\":\"Clemens Bleile\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"headline\":\"Oracle kernel relink on Linux: Are my options stored persistently?\",\"datePublished\":\"2016-04-08T19:25:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/\"},\"wordCount\":592,\"commentCount\":0,\"keywords\":[\"link\",\"make\",\"Oracle\",\"relink\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Database management\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/\",\"name\":\"Oracle kernel relink on Linux: Are my options stored persistently? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2016-04-08T19:25:20+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle kernel relink on Linux: Are my options stored persistently?\"}]},{\"@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":"Oracle kernel relink on Linux: Are my options stored persistently? - 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\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/","og_locale":"en_US","og_type":"article","og_title":"Oracle kernel relink on Linux: Are my options stored persistently?","og_description":"I recently visited an Oracle presentation about the Oracle-kernel built-in directNFS (dNFS) driver. To use dNFS in the database you have to enable it: cd $ORACLE_HOME\/rdbms\/lib make -f ins_rdbms.mk dnfs_on REMARK: In versions before 11gR2\/12c the following manual steps were necessary: cd $ORACLE_HOME\/lib mv libodm11.so libodm11.so_stub ln \u2013s libnfsodm11.so libodm11.so In the context of make-commands, [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/","og_site_name":"dbi Blog","article_published_time":"2016-04-08T19:25:20+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\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/"},"author":{"name":"Clemens Bleile","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"headline":"Oracle kernel relink on Linux: Are my options stored persistently?","datePublished":"2016-04-08T19:25:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/"},"wordCount":592,"commentCount":0,"keywords":["link","make","Oracle","relink"],"articleSection":["Database Administration &amp; Monitoring","Database management","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/","name":"Oracle kernel relink on Linux: Are my options stored persistently? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2016-04-08T19:25:20+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-kernel-relink-on-linux-are-my-options-stored-persistently\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle kernel relink on Linux: Are my options stored persistently?"}]},{"@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\/7540","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=7540"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7540\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=7540"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=7540"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=7540"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=7540"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}