previous blog post<\/a>, I tried to show how this can be complex, comparing the same workload (cached SLOB) on different instances of same Cloud provider (Amazon). I did that on instances with 2 virtual cores, covered by 2 Oracle Database processor licences. Here I’m doing the same on the Oracle Public Cloud where, with the same number of licenses, you can run on 4 hyper-threaded cores.
\n<\/p>\nTrial IaaS<\/h3>\n
I’m running with the 30-days trial subscription. I did several tests because they were not consistent at first. I had some runs where it seems that I was not running at full CPU. What I know is that your CPU resources are guaranteed on the Oracle Public Cloud, but maybe it’s not the case on trial, or I were working on a maintenance window, or…<\/p>\n
Well, I finally got consistent results and I’ve run the following test on the IaaS (Cloud Compute Service) to do something similar to what I did on AWS, with the Bring You Own License idea.<\/p>\n
In Oracle Public Cloud, you can run 2 cores per 1 Oracle processor licence. This means that if I have 2 processor licences, I can run on an instance shape with 4 OCPU. This shape is called ‘OC5’. Here it is:<\/p>\n
[oracle@a9f97f ~]$ lscpu\nArchitecture: x86_64\nCPU op-mode(s): 32-bit, 64-bit\nByte Order: Little Endian\nCPU(s): 8\nOn-line CPU(s) list: 0-7\nThread(s) per core: 1\nCore(s) per socket: 8\nSocket(s): 1\nNUMA node(s): 1\nVendor ID: GenuineIntel\nCPU family: 6\nModel: 63\nModel name: Intel(R) Xeon(R) CPU E5-2699 v3 @ 2.30GHz\nStepping: 2\nCPU MHz: 2294.938\nBogoMIPS: 4589.87\nHypervisor vendor: Xen\nVirtualization type: full\nL1d cache: 32K\nL1i cache: 32K\nL2 cache: 256K\nL3 cache: 46080K\nNUMA node0 CPU(s): 0-7\n \n[oracle@a9f97f ~]$ cat \/proc\/cpuinfo | tail -26\nprocessor : 7\nvendor_id : GenuineIntel\ncpu family : 6\nmodel : 63\nmodel name : Intel(R) Xeon(R) CPU E5-2699 v3 @ 2.30GHz\nstepping : 2\nmicrocode : 0x36\ncpu MHz : 2294.938\ncache size : 46080 KB\nphysical id : 0\nsiblings : 8\ncore id : 7\ncpu cores : 8\napicid : 14\ninitial apicid : 14\nfpu : yes\nfpu_exception : yes\ncpuid level : 13\nwp : yes\nflags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 ht syscall nx rdtscp lm constant_tsc rep_good nopl eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm xsaveopt fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid\nbogomips : 4589.87\nclflush size : 64\ncache_alignment : 64\naddress sizes : 46 bits physical, 48 bits virtual\npower management:\n<\/code><\/pre>\nAnd here are the results:<\/p>\n
\nLoad Profile Per Second Per Transaction Per Exec Per Call\n~~~~~~~~~~~~~~~ --------------- --------------- --------- ---------\n DB Time(s): 1.0 30.2 0.00 5.48\n DB CPU(s): 1.0 30.1 0.00 5.47\n Logical read (blocks): 884,286.7 26,660,977.4\n \nLoad Profile Per Second Per Transaction Per Exec Per Call\n~~~~~~~~~~~~~~~ --------------- --------------- --------- ---------\n DB Time(s): 2.0 25.0 0.00 9.53\n DB CPU(s): 2.0 25.0 0.00 9.53\n Logical read (blocks): 1,598,987.2 20,034,377.0\n \nLoad Profile Per Second Per Transaction Per Exec Per Call\n~~~~~~~~~~~~~~~ --------------- --------------- --------- ---------\n DB Time(s): 3.0 40.9 0.00 9.29\n DB CPU(s): 3.0 40.9 0.00 9.28\n Logical read (blocks): 2,195,570.8 29,999,381.1\n \nLoad Profile Per Second Per Transaction Per Exec Per Call\n~~~~~~~~~~~~~~~ --------------- --------------- --------- ---------\n DB Time(s): 4.0 42.9 0.00 14.46\n DB CPU(s): 4.0 42.8 0.00 14.45\n Logical read (blocks): 2,873,420.5 30,846,373.9\n \nLoad Profile Per Second Per Transaction Per Exec Per Call\n~~~~~~~~~~~~~~~ --------------- --------------- --------- ---------\n DB Time(s): 5.0 51.7 0.00 15.16\n DB CPU(s): 5.0 51.7 0.00 15.15\n Logical read (blocks): 3,520,059.0 36,487,232.0\n \nLoad Profile Per Second Per Transaction Per Exec Per Call\n~~~~~~~~~~~~~~~ --------------- --------------- --------- ---------\n DB Time(s): 6.0 81.8 0.00 17.15\n DB CPU(s): 6.0 81.8 0.00 17.14\n Logical read (blocks): 4,155,985.6 56,787,765.6\n \nLoad Profile Per Second Per Transaction Per Exec Per Call\n~~~~~~~~~~~~~~~ --------------- --------------- --------- ---------\n DB Time(s): 7.0 65.6 0.00 17.65\n DB CPU(s): 7.0 65.5 0.00 17.62\n Logical read (blocks): 4,638,929.5 43,572,740.0\n \nLoad Profile Per Second Per Transaction Per Exec Per Call\n~~~~~~~~~~~~~~~ --------------- --------------- --------- ---------\n DB Time(s): 8.0 92.3 0.00 19.20\n DB CPU(s): 8.0 92.1 0.00 19.16\n Logical read (blocks): 5,153,440.6 59,631,848.6\n \n<\/code><\/pre>\nThis is really good. This is x2.8 more LIOPS than the maximum I had on AWS EC2. A x2 factor is expected because I have x2 vCPUS here. But CPU is also faster. So, two conclusions here:<\/p>\n
\n- There is no technical reason behind the reject of core factor on Amazon EC2. It is only a marketing decision.<\/li>\n
- For sure, for same Oracle Database cost, Oracle Cloud outperforms Amazon EC2 because is is cheaper (not to mention the discounts you will get if you go to Oracle Cloud)<\/li>\n<\/ul>\n
So what?<\/h3>\n
This is not a benchmark. The LIOPS may depend a lot on your application behaviour, and CPU is not the only resource to take care. But for sure, the Oracle Public Cloud IaaS is fast and costs less when used for Oracle products, because of the rules on core factor. But those rules are for information only. Check your contract for legal stuff.<\/p>\n","protected":false},"excerpt":{"rendered":"
By Franck Pachot . I’ve blogged recently about the Oracle Core Factor in the Clouds. And then, in order to optimize your Oracle licences, you need to choose the instance type that can run faster on less cores. In a previous blog post, I tried to show how this can be complex, comparing the same […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[955,229],"tags":[135],"type_dbi":[],"class_list":["post-9749","post","type-post","status-publish","format-standard","hentry","category-cloud","category-database-administration-monitoring","tag-cloud"],"acf":[],"yoast_head":"\n
Oracle Public Cloud: 2 OCPU for 1 proc. license - 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-public-cloud-2-ocpu-for-1-proc-license\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Public Cloud: 2 OCPU for 1 proc. license\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . I’ve blogged recently about the Oracle Core Factor in the Clouds. And then, in order to optimize your Oracle licences, you need to choose the instance type that can run faster on less cores. In a previous blog post, I tried to show how this can be complex, comparing the same […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-2-ocpu-for-1-proc-license\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-02-08T16:40:10+00:00\" \/>\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\/oracle-public-cloud-2-ocpu-for-1-proc-license\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-2-ocpu-for-1-proc-license\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle Public Cloud: 2 OCPU for 1 proc. license\",\"datePublished\":\"2017-02-08T16:40:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-2-ocpu-for-1-proc-license\/\"},\"wordCount\":410,\"commentCount\":0,\"keywords\":[\"Cloud\"],\"articleSection\":[\"Cloud\",\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-2-ocpu-for-1-proc-license\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-2-ocpu-for-1-proc-license\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-2-ocpu-for-1-proc-license\/\",\"name\":\"Oracle Public Cloud: 2 OCPU for 1 proc. license - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2017-02-08T16:40:10+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-2-ocpu-for-1-proc-license\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-2-ocpu-for-1-proc-license\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-2-ocpu-for-1-proc-license\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Public Cloud: 2 OCPU for 1 proc. license\"}]},{\"@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":"Oracle Public Cloud: 2 OCPU for 1 proc. license - 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-public-cloud-2-ocpu-for-1-proc-license\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Public Cloud: 2 OCPU for 1 proc. license","og_description":"By Franck Pachot . I’ve blogged recently about the Oracle Core Factor in the Clouds. And then, in order to optimize your Oracle licences, you need to choose the instance type that can run faster on less cores. In a previous blog post, I tried to show how this can be complex, comparing the same […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-2-ocpu-for-1-proc-license\/","og_site_name":"dbi Blog","article_published_time":"2017-02-08T16:40:10+00:00","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\/oracle-public-cloud-2-ocpu-for-1-proc-license\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-2-ocpu-for-1-proc-license\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle Public Cloud: 2 OCPU for 1 proc. license","datePublished":"2017-02-08T16:40:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-2-ocpu-for-1-proc-license\/"},"wordCount":410,"commentCount":0,"keywords":["Cloud"],"articleSection":["Cloud","Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-2-ocpu-for-1-proc-license\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-2-ocpu-for-1-proc-license\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-2-ocpu-for-1-proc-license\/","name":"Oracle Public Cloud: 2 OCPU for 1 proc. license - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-02-08T16:40:10+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-2-ocpu-for-1-proc-license\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-2-ocpu-for-1-proc-license\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-2-ocpu-for-1-proc-license\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle Public Cloud: 2 OCPU for 1 proc. license"}]},{"@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\/9749","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=9749"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9749\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9749"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9749"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}