{"id":2519,"date":"2012-03-01T07:19:27","date_gmt":"2012-03-01T06:19:27","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/"},"modified":"2012-03-01T07:19:27","modified_gmt":"2012-03-01T06:19:27","slug":"jonathan-lewis-dbi-services-oracle-optimizer-workshop","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/","title":{"rendered":"Jonathan Lewis @ dbi services: Oracle Optimizer workshop"},"content":{"rendered":"

Last week, Oracle Ace Director Jonathan Lewis held an Oracle Optimizer Workshop at dbi services Basel Area. I would like to share some of the key learnings of this really interesting exchange I experienced together with my colleagues.<\/p>\n

In his workshop, Jonathan Lewis covered an impressive amount of Oracle optimizer know how: from the fundamentals of the Cost Based Optimizer (CBO) to the latest 11.2 Oracle Optimizer features. Useless to say that we were all amazed from Jonathan’s expertise.<\/p>\n

\"Jonathan<\/p>\n

Jonathan provided an impressive insight into the Oracle Optimizer which really helped me to better grasp the decisions of the Cost Based Optimizer (CBO). Understanding how and why nested loops or hash joins are used is a black box if you are not aware of the underlying “maths”. This kind of information cleary was a big added value of Jonathan’s workshop. He also gave us lots of practical and very funny examples of his experience at customer sites.<\/p>\n

\"Jonathan<\/p>\n

As most of you know, Jonathan Lewis is a well known figure in the Oracle community and has also published several books (last publication in November 2011: Oracle Core: Apress, ISBN 978-1430239543<\/a>). His blog really is a key Oracle resource (http:\/\/jonathanlewis.wordpress.com\/<\/a>) and he also contributes to several other blogs, newsgroups, forums, and Oracle User Group magazines.<\/p>\n

\"Jonathan
\nAgain, Jonathan, thanks a lot for your great workshop!<\/p>\n","protected":false},"excerpt":{"rendered":"

Last week, Oracle Ace Director Jonathan Lewis held an Oracle Optimizer Workshop at dbi services BaselArea. I would like to share some of the key learnings of this really interesting exchange I experienced together with my colleagues.<\/p>\n","protected":false},"author":8,"featured_media":2520,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[197],"tags":[18,67,306],"type_dbi":[],"class_list":["post-2519","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-application-integration-middleware","tag-oracle-optimizer","tag-performance","tag-workshop"],"acf":[],"yoast_head":"\nJonathan Lewis @ dbi services: Oracle Optimizer workshop - dbi Blog<\/title>\n<meta name=\"description\" content=\"Last week, Oracle Ace Director Jonathan Lewis held an Oracle Optimizer Workshop at dbi services Basel Area. I would like to share some of the key learnings of this really interesting exchange I experienced together with my colleagues.\" \/>\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\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Jonathan Lewis @ dbi services: Oracle Optimizer workshop\" \/>\n<meta property=\"og:description\" content=\"Last week, Oracle Ace Director Jonathan Lewis held an Oracle Optimizer Workshop at dbi services Basel Area. I would like to share some of the key learnings of this really interesting exchange I experienced together with my colleagues.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2012-03-01T06:19:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/IMGP1834_w.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"669\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Herv\u00e9 Schweitzer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Herv\u00e9 Schweitzer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/\"},\"author\":{\"name\":\"Herv\u00e9 Schweitzer\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7fb08fbefcb9b2c146ef4533cfee00c7\"},\"headline\":\"Jonathan Lewis @ dbi services: Oracle Optimizer workshop\",\"datePublished\":\"2012-03-01T06:19:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/\"},\"wordCount\":232,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/IMGP1834_w.jpg\",\"keywords\":[\"Oracle optimizer\",\"Performance\",\"Workshop\"],\"articleSection\":[\"Application integration & Middleware\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/\",\"name\":\"Jonathan Lewis @ dbi services: Oracle Optimizer workshop - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/IMGP1834_w.jpg\",\"datePublished\":\"2012-03-01T06:19:27+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7fb08fbefcb9b2c146ef4533cfee00c7\"},\"description\":\"Last week, Oracle Ace Director Jonathan Lewis held an Oracle Optimizer Workshop at dbi services Basel Area. I would like to share some of the key learnings of this really interesting exchange I experienced together with my colleagues.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/IMGP1834_w.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/IMGP1834_w.jpg\",\"width\":1000,\"height\":669},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Jonathan Lewis @ dbi services: Oracle Optimizer workshop\"}]},{\"@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\/7fb08fbefcb9b2c146ef4533cfee00c7\",\"name\":\"Herv\u00e9 Schweitzer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g\",\"caption\":\"Herv\u00e9 Schweitzer\"},\"description\":\"Herv\u00e9 Schweitzer has more than ten years of experience in database and infrastructure management, engineering, and optimization. He is specialized in Oracle technologies such as standardisation, Backup and Recovery, Tuning, and in High Availability solutions such as Oracle Data Guard, Oracle Grid Infrastructure, Oracle Real Application Clusters (RAC), Oracle GoldenGate, and Oracle Failsafe. Herv\u00e9 Schweitzer is \\\"Oracle Certified Master 11g (OCM 11g)\\\". Prior to joining dbi services, Herv\u00e9 Schweitzer was Senior Consultant at Trivadis in Basel. He also worked as an IT Administrator and Oracle DBA at Crossair in Basel. Herv\u00e9 Schweitzer holds a BTS degree in Information Systems from France. His branch-related experience covers Pharma, Transport and Logistics, Banking, Energy, Automotive etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/herve-schweitzer\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Jonathan Lewis @ dbi services: Oracle Optimizer workshop - dbi Blog","description":"Last week, Oracle Ace Director Jonathan Lewis held an Oracle Optimizer Workshop at dbi services Basel Area. I would like to share some of the key learnings of this really interesting exchange I experienced together with my colleagues.","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\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/","og_locale":"en_US","og_type":"article","og_title":"Jonathan Lewis @ dbi services: Oracle Optimizer workshop","og_description":"Last week, Oracle Ace Director Jonathan Lewis held an Oracle Optimizer Workshop at dbi services Basel Area. I would like to share some of the key learnings of this really interesting exchange I experienced together with my colleagues.","og_url":"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/","og_site_name":"dbi Blog","article_published_time":"2012-03-01T06:19:27+00:00","og_image":[{"width":1000,"height":669,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/IMGP1834_w.jpg","type":"image\/jpeg"}],"author":"Herv\u00e9 Schweitzer","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Herv\u00e9 Schweitzer","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/"},"author":{"name":"Herv\u00e9 Schweitzer","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7fb08fbefcb9b2c146ef4533cfee00c7"},"headline":"Jonathan Lewis @ dbi services: Oracle Optimizer workshop","datePublished":"2012-03-01T06:19:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/"},"wordCount":232,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/IMGP1834_w.jpg","keywords":["Oracle optimizer","Performance","Workshop"],"articleSection":["Application integration & Middleware"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/","url":"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/","name":"Jonathan Lewis @ dbi services: Oracle Optimizer workshop - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/IMGP1834_w.jpg","datePublished":"2012-03-01T06:19:27+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7fb08fbefcb9b2c146ef4533cfee00c7"},"description":"Last week, Oracle Ace Director Jonathan Lewis held an Oracle Optimizer Workshop at dbi services Basel Area. I would like to share some of the key learnings of this really interesting exchange I experienced together with my colleagues.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/IMGP1834_w.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/IMGP1834_w.jpg","width":1000,"height":669},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/jonathan-lewis-dbi-services-oracle-optimizer-workshop\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Jonathan Lewis @ dbi services: Oracle Optimizer workshop"}]},{"@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\/7fb08fbefcb9b2c146ef4533cfee00c7","name":"Herv\u00e9 Schweitzer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0730552c0cfc0a9297c56f2efe56dadd8de399885ca6161a2bee83aebe291afc?s=96&d=mm&r=g","caption":"Herv\u00e9 Schweitzer"},"description":"Herv\u00e9 Schweitzer has more than ten years of experience in database and infrastructure management, engineering, and optimization. He is specialized in Oracle technologies such as standardisation, Backup and Recovery, Tuning, and in High Availability solutions such as Oracle Data Guard, Oracle Grid Infrastructure, Oracle Real Application Clusters (RAC), Oracle GoldenGate, and Oracle Failsafe. Herv\u00e9 Schweitzer is \"Oracle Certified Master 11g (OCM 11g)\". Prior to joining dbi services, Herv\u00e9 Schweitzer was Senior Consultant at Trivadis in Basel. He also worked as an IT Administrator and Oracle DBA at Crossair in Basel. Herv\u00e9 Schweitzer holds a BTS degree in Information Systems from France. His branch-related experience covers Pharma, Transport and Logistics, Banking, Energy, Automotive etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/herve-schweitzer\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2519","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\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2519"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2519\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2520"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2519"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}