{"id":16574,"date":"2021-08-04T22:08:44","date_gmt":"2021-08-04T20:08:44","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oda-19-11-oracle_homes-on-acfs\/"},"modified":"2021-08-04T22:08:44","modified_gmt":"2021-08-04T20:08:44","slug":"oda-19-11-oracle_homes-on-acfs","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oda-19-11-oracle_homes-on-acfs\/","title":{"rendered":"ODA 19.11.: ORACLE_HOMEs on ACFS"},"content":{"rendered":"

Introduction<\/h3>\n

Beginning with Oracle Database Appliance (ODA) 19.11. the ORACLE_BASE and ORACLE_HOMEs are created on ACFS. That’s good news, because there is much more space on ASM than on the internal disks, i.e. no space issues with \/u01 anymore. So how does it work?<\/p>\n

ORACLE_BASE and ORACLE_HOME on ACFS<\/h3>\n

When installing an ODA from scratch then ORACLE_BASE and ORACLE_HOME are already on ACFS. See an example of a freshly installed ODA X8-2M:<\/p>\n

\n[root@dbi-oda-x8 ~]# odacli list-dbhome-storages\n\n============================================================================================================= \nID                                     Node Description          Disk Group Volume      Size(GB)   Status     \n-------------------------------------- ---- -------------------- ---------- ----------- ---------- ----------\n3e5b27c0-f021-4cc8-9c4d-a68362aed23b   0    ORACLE_HOME          DATA       orahome_sh  30         CONFIGURED\na8fa8109-d8ec-4a4c-84f4-53b07661dc0f   0    ORACLE_BASE          DATA       odabase_n0  10         CONFIGURED\n============================================================================================================= \n<\/pre>\n
If there is no ORACLE_HOME on ACFS (e.g. after upgrading from an earlier version) then you should configure the database-home-storage. I.e. do that after step 14 (update of the storage components) of the upgrade process. In the following example I configure 100GB for my ORACLE_HOMEs on diskgroup DATA:<\/p>\n
\n[root@dbi-oda-x8 ~]# odacli configure-dbhome-storage -dg DATA -s 100\nDCS-10606:Database homes storage has already been created, no changes are allowed.\n<\/pre>\n
The command failed, because a dbhome-storage has already been configured on my machine.<\/p>\n
With describe-dbhome-storage you can get more information about the dbhome-storage:<\/p>\n
\n[root@dbi-oda-x8 ~]# odacli describe-dbhome-storage -i 3e5b27c0-f021-4cc8-9c4d-a68362aed23b\nORACLE_HOME storage details:\n================================================================\n                     ID: 3e5b27c0-f021-4cc8-9c4d-a68362aed23b\n                  State: CONFIGURED\n                Created: July 29, 2021 9:33:24 AM CEST\n                Updated: July 29, 2021 9:58:33 AM CEST\n\n Volume Details\n --------------\n                   Name: orahome_sh\n             Disk Group: DATA\n            Description: ORACLE_HOME\n            Node Number: 0\n        Allocated Space: 30.0 GB\n             Used Space: 12.22 GB\n             Free Space: 17.77 GB\n               Location: \/u01\/app\/odaorahome\n\n DiskGroup Details\n -----------------\n                   Name: DATA\n        Allocated Space: 4.65 TB\n             Used Space: 352.31 GB\n             Free Space: 4.31 TB\n================================================================\n\n[root@dbi-oda-x8 ~]# \n<\/pre>\n
The size of the dbhome-storage can be changed with modify-dbhome-storage. E.g. here I resize it to 40GB:<\/p>\n
\n[root@dbi-oda-x8 ~]# odacli modify-dbhome-storage -i 3e5b27c0-f021-4cc8-9c4d-a68362aed23b -s 40\n{\n  \"jobId\" : \"bec8b73f-5537-4b59-87e9-bb780edf38d1\",\n  \"status\" : \"Created\",\n  \"message\" : null,\n  \"reports\" : [ ],\n  \"createTimestamp\" : \"August 04, 2021 22:26:02 PM CEST\",\n  \"resourceList\" : [ ],\n  \"description\" : \"Modify database home storage\",\n  \"updatedTime\" : \"August 04, 2021 22:26:02 PM CEST\"\n}\n[root@dbi-oda-x8 ~]# odacli describe-job -i bec8b73f-5537-4b59-87e9-bb780edf38d1\n\nJob details                                                      \n----------------------------------------------------------------\n                     ID:  bec8b73f-5537-4b59-87e9-bb780edf38d1\n            Description:  Modify database home storage\n                 Status:  Success\n                Created:  August 4, 2021 10:26:02 PM CEST\n                Message:  \n\nTask Name                                Start Time                          End Time                            Status    \n---------------------------------------- ----------------------------------- ----------------------------------- ----------\nResizing database home storage           August 4, 2021 10:26:02 PM CEST     August 4, 2021 10:26:02 PM CEST     Success   \n\n[root@dbi-oda-x8 ~]# odacli list-dbhome-storages\n\n============================================================================================================= \nID                                     Node Description          Disk Group Volume      Size(GB)   Status     \n-------------------------------------- ---- -------------------- ---------- ----------- ---------- ----------\n3e5b27c0-f021-4cc8-9c4d-a68362aed23b   0    ORACLE_HOME          DATA       orahome_sh  40         CONFIGURED\na8fa8109-d8ec-4a4c-84f4-53b07661dc0f   0    ORACLE_BASE          DATA       odabase_n0  10         CONFIGURED\n============================================================================================================= \n\n[root@dbi-oda-x8 ~]# odacli describe-dbhome-storage -i 3e5b27c0-f021-4cc8-9c4d-a68362aed23b\n\nORACLE_HOME storage details:\n================================================================\n                     ID: 3e5b27c0-f021-4cc8-9c4d-a68362aed23b\n                  State: CONFIGURED\n                Created: July 29, 2021 9:33:24 AM CEST\n                Updated: August 4, 2021 10:26:02 PM CEST\n\n Volume Details\n --------------\n                   Name: orahome_sh\n             Disk Group: DATA\n            Description: ORACLE_HOME\n            Node Number: 0\n        Allocated Space: 40.0 GB\n             Used Space: 12.24 GB\n             Free Space: 27.75 GB\n               Location: \/u01\/app\/odaorahome\n\n DiskGroup Details\n -----------------\n                   Name: DATA\n        Allocated Space: 4.65 TB\n             Used Space: 362.31 GB\n             Free Space: 4.30 TB\n================================================================\n\n[root@dbi-oda-x8 ~]# df -h \/u01\/app\/odaorahome\nFilesystem               Size  Used Avail Use% Mounted on\n\/dev\/asm\/orahome_sh-250   40G   13G   28G  31% \/u01\/app\/odaorahome\n[root@dbi-oda-x8 ~]# \n<\/pre>\n
Creating a new ORACLE_HOME is created on the dbhome-storage on ACFS:<\/p>\n
\n[root@dbi-oda-x8 ~]# odacli list-dbhomes\n\nID                                       Name                 DB Version                               Home Location                                 Status    \n---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------\ne36a3f2f-22f8-4ff0-9935-9a4943f51349     OraDB19000_home1     19.11.0.0.210420                         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1 CONFIGURED\n\n[root@dbi-oda-x8 ~]# odacli create-dbhome -v 19.11.0.0.210420\n\nJob details                                                      \n----------------------------------------------------------------\n                     ID:  aac4de69-bfde-496e-ac53-9f02ebcf36c2\n            Description:  Database Home OraDB19000_home2 creation with version :19.11.0.0.210420\n                 Status:  Created\n                Created:  August 4, 2021 10:29:58 PM CEST\n                Message:  Create Database Home\n\nTask Name                                Start Time                          End Time                            Status    \n---------------------------------------- ----------------------------------- ----------------------------------- ----------\n\n[root@dbi-oda-x8 ~]# odacli list-dbhomes\n\nID                                       Name                 DB Version                               Home Location                                 Status    \n---------------------------------------- -------------------- ---------------------------------------- --------------------------------------------- ----------\ne36a3f2f-22f8-4ff0-9935-9a4943f51349     OraDB19000_home1     19.11.0.0.210420                         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_1 CONFIGURED\n9cc87345-67a5-41ae-b7b9-4c0c9f2a8be7     OraDB19000_home2     19.11.0.0.210420                         \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_2 CONFIGURED\n\n[root@dbi-oda-x8 ~]# odacli describe-dbhome -i 9cc87345-67a5-41ae-b7b9-4c0c9f2a8be7\nDB Home details                                                   \n----------------------------------------------------------------\n                     ID: 9cc87345-67a5-41ae-b7b9-4c0c9f2a8be7\n                   Name: OraDB19000_home2\n                Version: 19.11.0.0.210420\n          Home Location: \/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_2\n                 Status: CONFIGURED\n                Created: August 4, 2021 10:29:58 PM CEST\n       Database Edition: SE\n[root@dbi-oda-x8 ~]# \n<\/pre>\n
Out of place patching<\/h3>\n
By having much more space for ORACLE_HOMEs, patching DB-Homes (odacli update-dbhome) is no longer happening in place. I.e. when new RDBMS clone files have been loaded in the repository and you run odacli update-dbhome a new ORACLE_HOME with the new version is created and the databases moved to the new ORACLE_HOME. That makes the whole patching process much more stable, because going back to the previous ORACLE_HOME is possible in case of an error.<\/p>\n","protected":false},"excerpt":{"rendered":"
Introduction Beginning with Oracle Database Appliance (ODA) 19.11. the ORACLE_BASE and ORACLE_HOMEs are created on ACFS. That’s good news, because there is much more space on ASM than on the internal disks, i.e. no space issues with \/u01 anymore. So how does it work? ORACLE_BASE and ORACLE_HOME on ACFS When installing an ODA from scratch […]<\/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":[2337,2366,79,1327,2374,2375,2376,2377,2378,365,1330,1331,1332,1697,1698,1699],"type_dbi":[],"class_list":["post-16574","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-19-11","tag-bare-metal","tag-oda","tag-odacli","tag-odacli-configure-dbhome-storage","tag-odacli-create-dbhome","tag-odacli-describe-dbhome-storage","tag-odacli-list-dbhome-storages","tag-odacli-modify-dbhome-storage","tag-oracle-database-appliance","tag-x7-2ha","tag-x7-2m","tag-x7-2s","tag-x8-2ha","tag-x8-2m","tag-x8-2s"],"acf":[],"yoast_head":"\nODA 19.11.: ORACLE_HOMEs on ACFS - 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\/oda-19-11-oracle_homes-on-acfs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ODA 19.11.: ORACLE_HOMEs on ACFS\" \/>\n<meta property=\"og:description\" content=\"Introduction Beginning with Oracle Database Appliance (ODA) 19.11. the ORACLE_BASE and ORACLE_HOMEs are created on ACFS. That’s good news, because there is much more space on ASM than on the internal disks, i.e. no space issues with \/u01 anymore. So how does it work? ORACLE_BASE and ORACLE_HOME on ACFS When installing an ODA from scratch […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oda-19-11-oracle_homes-on-acfs\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-04T20:08:44+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=\"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\/oda-19-11-oracle_homes-on-acfs\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-19-11-oracle_homes-on-acfs\/\"},\"author\":{\"name\":\"Clemens Bleile\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"headline\":\"ODA 19.11.: ORACLE_HOMEs on ACFS\",\"datePublished\":\"2021-08-04T20:08:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-19-11-oracle_homes-on-acfs\/\"},\"wordCount\":273,\"commentCount\":0,\"keywords\":[\"19.11\",\"bare metal\",\"ODA\",\"odacli\",\"odacli configure-dbhome-storage\",\"odacli create-dbhome\",\"odacli describe-dbhome-storage\",\"odacli list-dbhome-storages\",\"odacli modify-dbhome-storage\",\"Oracle database appliance\",\"X7-2HA\",\"X7-2M\",\"X7-2S\",\"x8-2ha\",\"x8-2m\",\"x8-2s\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oda-19-11-oracle_homes-on-acfs\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-19-11-oracle_homes-on-acfs\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oda-19-11-oracle_homes-on-acfs\/\",\"name\":\"ODA 19.11.: ORACLE_HOMEs on ACFS - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2021-08-04T20:08:44+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-19-11-oracle_homes-on-acfs\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oda-19-11-oracle_homes-on-acfs\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-19-11-oracle_homes-on-acfs\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ODA 19.11.: ORACLE_HOMEs on ACFS\"}]},{\"@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":"ODA 19.11.: ORACLE_HOMEs on ACFS - 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\/oda-19-11-oracle_homes-on-acfs\/","og_locale":"en_US","og_type":"article","og_title":"ODA 19.11.: ORACLE_HOMEs on ACFS","og_description":"Introduction Beginning with Oracle Database Appliance (ODA) 19.11. the ORACLE_BASE and ORACLE_HOMEs are created on ACFS. That’s good news, because there is much more space on ASM than on the internal disks, i.e. no space issues with \/u01 anymore. So how does it work? ORACLE_BASE and ORACLE_HOME on ACFS When installing an ODA from scratch […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oda-19-11-oracle_homes-on-acfs\/","og_site_name":"dbi Blog","article_published_time":"2021-08-04T20:08:44+00:00","author":"Clemens Bleile","twitter_card":"summary_large_image","twitter_creator":"@ifgtxD2SrQ8r!YuXj","twitter_misc":{"Written by":"Clemens Bleile","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oda-19-11-oracle_homes-on-acfs\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-19-11-oracle_homes-on-acfs\/"},"author":{"name":"Clemens Bleile","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"headline":"ODA 19.11.: ORACLE_HOMEs on ACFS","datePublished":"2021-08-04T20:08:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-19-11-oracle_homes-on-acfs\/"},"wordCount":273,"commentCount":0,"keywords":["19.11","bare metal","ODA","odacli","odacli configure-dbhome-storage","odacli create-dbhome","odacli describe-dbhome-storage","odacli list-dbhome-storages","odacli modify-dbhome-storage","Oracle database appliance","X7-2HA","X7-2M","X7-2S","x8-2ha","x8-2m","x8-2s"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oda-19-11-oracle_homes-on-acfs\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oda-19-11-oracle_homes-on-acfs\/","url":"https:\/\/www.dbi-services.com\/blog\/oda-19-11-oracle_homes-on-acfs\/","name":"ODA 19.11.: ORACLE_HOMEs on ACFS - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2021-08-04T20:08:44+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-19-11-oracle_homes-on-acfs\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oda-19-11-oracle_homes-on-acfs\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oda-19-11-oracle_homes-on-acfs\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ODA 19.11.: ORACLE_HOMEs on ACFS"}]},{"@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\/16574","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=16574"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16574\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16574"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16574"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16574"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16574"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}