latest<\/a> post I’ve run a cached SLOB workload on Oracle Cloud IaaS to measure logical reads per seconds on a system covered by 2 processor licences (so 4 OCPs). Just as a comparison, here is the same on Oracle PaaS database as a service.
\n<\/p>\nPaaS<\/h3>\n
The CPUs in PaaS are not exactly the same: E5-2690 v2 (3.00GHz) – it was E5-2699 v3 (2.30GHz) for my IaaS test.<\/p>\n
\n[oracle@DBI122 ~]$ lscpu\nArchitecture: x86_64\nCPU op-mode(s): 32-bit, 64-bit\nByte Order: Little Endian\nCPU(s): 2\nOn-line CPU(s) list: 0,1\nThread(s) per core: 1\nCore(s) per socket: 2\nSocket(s): 1\nNUMA node(s): 1\nVendor ID: GenuineIntel\nCPU family: 6\nModel: 62\nStepping: 4\nCPU MHz: 2992.874\nBogoMIPS: 5985.74\nHypervisor vendor: Xen\nVirtualization type: full\nL1d cache: 32K\nL1i cache: 32K\nL2 cache: 256K\nL3 cache: 25600K\nNUMA node0 CPU(s): 0,1\n[oracle@DBI122 ~]$ cat \/proc\/cpuinfo | tail -26\nprocessor : 1\nvendor_id : GenuineIntel\ncpu family : 6\nmodel : 62\nmodel name : Intel(R) Xeon(R) CPU E5-2690 v2 @ 3.00GHz\nstepping : 4\nmicrocode : 0x428\ncpu MHz : 2992.874\ncache size : 25600 KB\nphysical id : 0\nsiblings : 2\ncore id : 1\ncpu cores : 2\napicid : 2\ninitial apicid : 2\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 cx16 pcid sse4_1 sse4_2 x2apic popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm xsaveopt fsgsbase smep erms\nbogomips : 5985.74\nclflush size : 64\ncache_alignment : 64\naddress sizes : 46 bits physical, 48 bits virtual\npower management:\n<\/code><\/pre>\nSo it seems that PaaS has faster CPU (see frequency and bogomips) but nothing worth a real test:<\/p>\n
SLOB<\/h3>\n
Here I’ve run 1 to 8 SLOB sessions as I did in the previous post and here is the result:<\/p>\n
\nLoad Profile Per Second Per Transaction Per Exec Per Call\n~~~~~~~~~~~~~~~ --------------- --------------- --------- ---------\n DB Time(s): 1.0 25.1 0.00 2.19\n DB CPU(s): 1.0 25.1 0.00 2.18\n Logical read (blocks): 611,210.2 15,357,878.4\n \nLoad Profile Per Second Per Transaction Per Exec Per Call\n~~~~~~~~~~~~~~~ --------------- --------------- --------- ---------\n DB Time(s): 2.0 40.1 0.00 7.71\n DB CPU(s): 2.0 40.1 0.00 7.70\n Logical read (blocks): 1,195,863.3 24,031,350.5\n \nLoad Profile Per Second Per Transaction Per Exec Per Call\n~~~~~~~~~~~~~~~ --------------- --------------- --------- ---------\n DB Time(s): 3.0 75.1 0.00 11.86\n DB CPU(s): 3.0 75.0 0.00 11.84\n Logical read (blocks): 1,720,446.4 43,208,149.8\n \nLoad Profile Per Second Per Transaction Per Exec Per Call\n~~~~~~~~~~~~~~~ --------------- --------------- --------- ---------\n DB Time(s): 4.0 70.7 0.00 11.78\n DB CPU(s): 4.0 70.6 0.00 11.76\n Logical read (blocks): 2,266,196.4 40,174,995.7\n \nLoad Profile Per Second Per Transaction Per Exec Per Call\n~~~~~~~~~~~~~~~ --------------- --------------- --------- ---------\n DB Time(s): 5.0 125.1 0.00 13.17\n DB CPU(s): 5.0 124.9 0.00 13.15\n Logical read (blocks): 2,802,916.0 70,385,892.6\n \nLoad Profile Per Second Per Transaction Per Exec Per Call\n~~~~~~~~~~~~~~~ --------------- --------------- --------- ---------\n DB Time(s): 6.0 90.1 0.00 15.80\n DB CPU(s): 6.0 90.0 0.00 15.78\n Logical read (blocks): 3,312,050.8 49,898,529.6\n \nLoad Profile Per Second Per Transaction Per Exec Per Call\n~~~~~~~~~~~~~~~ --------------- --------------- --------- ---------\n DB Time(s): 7.0 95.5 0.00 17.22\n DB CPU(s): 7.0 95.3 0.00 17.18\n Logical read (blocks): 3,812,912.2 52,225,112.1\n \nLoad Profile Per Second Per Transaction Per Exec Per Call\n~~~~~~~~~~~~~~~ --------------- --------------- --------- ---------\n DB Time(s): 8.0 141.3 0.00 16.45\n DB CPU(s): 7.9 140.2 0.00 16.33\n Logical read (blocks): 4,237,433.6 75,154,623.7\n<\/code><\/pre>\nFaster CPU but lower logical reads processed by seconds… Don’t look only at the specs when choosing an instance type. Test it with your workload…<\/p>\n
Besides performance, I really like the Oracle Cloud PaaS for Database. You have easy provisioning (a few clicks) but still full access (root, grid, oracle, sysdba). There is no competitor on that. In other clouds, either you go IaaS and you have to install and configure everything yourself, or you go PaaS and you have very limited admin access. Here you have both.<\/p>\n","protected":false},"excerpt":{"rendered":"
By Franck Pachot . In the latest post I’ve run a cached SLOB workload on Oracle Cloud IaaS to measure logical reads per seconds on a system covered by 2 processor licences (so 4 OCPs). Just as a comparison, here is the same on Oracle PaaS database as a service.<\/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,96,824],"type_dbi":[],"class_list":["post-9755","post","type-post","status-publish","format-standard","hentry","category-cloud","category-database-administration-monitoring","tag-cloud","tag-oracle","tag-paas"],"acf":[],"yoast_head":"\n
Oracle Public Cloud: LIOPS with 4 OCPU in PaaS - 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-liops-with-4-ocpu-in-paas\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Public Cloud: LIOPS with 4 OCPU in PaaS\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . In the latest post I’ve run a cached SLOB workload on Oracle Cloud IaaS to measure logical reads per seconds on a system covered by 2 processor licences (so 4 OCPs). Just as a comparison, here is the same on Oracle PaaS database as a service.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-liops-with-4-ocpu-in-paas\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-02-10T18:44:15+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=\"3 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-liops-with-4-ocpu-in-paas\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-public-cloud-liops-with-4-ocpu-in-paas\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle Public Cloud: LIOPS with 4 OCPU in PaaS\",\"datePublished\":\"2017-02-10T18:44:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-public-cloud-liops-with-4-ocpu-in-paas\\\/\"},\"wordCount\":208,\"commentCount\":0,\"keywords\":[\"Cloud\",\"Oracle\",\"PaaS\"],\"articleSection\":[\"Cloud\",\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-public-cloud-liops-with-4-ocpu-in-paas\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-public-cloud-liops-with-4-ocpu-in-paas\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-public-cloud-liops-with-4-ocpu-in-paas\\\/\",\"name\":\"Oracle Public Cloud: LIOPS with 4 OCPU in PaaS - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2017-02-10T18:44:15+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-public-cloud-liops-with-4-ocpu-in-paas\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-public-cloud-liops-with-4-ocpu-in-paas\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-public-cloud-liops-with-4-ocpu-in-paas\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Public Cloud: LIOPS with 4 OCPU in PaaS\"}]},{\"@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: LIOPS with 4 OCPU in PaaS - 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-liops-with-4-ocpu-in-paas\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Public Cloud: LIOPS with 4 OCPU in PaaS","og_description":"By Franck Pachot . In the latest post I’ve run a cached SLOB workload on Oracle Cloud IaaS to measure logical reads per seconds on a system covered by 2 processor licences (so 4 OCPs). Just as a comparison, here is the same on Oracle PaaS database as a service.","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-liops-with-4-ocpu-in-paas\/","og_site_name":"dbi Blog","article_published_time":"2017-02-10T18:44:15+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-liops-with-4-ocpu-in-paas\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-liops-with-4-ocpu-in-paas\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle Public Cloud: LIOPS with 4 OCPU in PaaS","datePublished":"2017-02-10T18:44:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-liops-with-4-ocpu-in-paas\/"},"wordCount":208,"commentCount":0,"keywords":["Cloud","Oracle","PaaS"],"articleSection":["Cloud","Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-liops-with-4-ocpu-in-paas\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-liops-with-4-ocpu-in-paas\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-liops-with-4-ocpu-in-paas\/","name":"Oracle Public Cloud: LIOPS with 4 OCPU in PaaS - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-02-10T18:44:15+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-liops-with-4-ocpu-in-paas\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-liops-with-4-ocpu-in-paas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-liops-with-4-ocpu-in-paas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle Public Cloud: LIOPS with 4 OCPU in PaaS"}]},{"@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\/9755","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=9755"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9755\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9755"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9755"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9755"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9755"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}