{"id":8597,"date":"2016-07-21T17:04:27","date_gmt":"2016-07-21T15:04:27","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/"},"modified":"2016-07-21T17:04:27","modified_gmt":"2016-07-21T15:04:27","slug":"oda-x-6-log-file-sync-with-nvme-flash","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/","title":{"rendered":"ODA X-6 log file sync with NVMe flash"},"content":{"rendered":"

By Franck Pachot<\/h2>\n

.
\nThe new ODA X-6 has been announced last month with two smaller configurations and smaller prices: 2S and 2M. Small, but high performance configuration: all SSD, and I\/O transfer optimized for Flash with PCIe bus and NVMe protocol. Let’s see how it keeps up with an high OLTP workload. Thanks to Arrow Oracle Authorized Solution Center to let us evaluate performance on their ODA.
\n
\nJust in case you wonder if Flash is good for writes, and especially for redo, we have run a workload that mainly inserts rows and commit, from 10 sessions without think time.<\/p>\n

log file sync<\/h3>\n

From the following picture shows a workload all in CPU: OLTP mainly inserts.
\n\"CaptureX62M003\"<\/a>
\nAll in CPU and some waits on ‘log file sync’, the commit wait event. At first sight, it seems that those waits are high (30%) and irregular (peaks in transaction rate). But beyond the colors, let’s check the numbers:<\/p>\n

\nLoad Profile                    Per Second   Per Transaction  Per Exec  Per Call\n~~~~~~~~~~~~~~~            ---------------   --------------- --------- ---------\n             DB Time(s):               9.5               0.0      0.00      0.00\n              DB CPU(s):               6.7               0.0      0.00      0.00\n      Background CPU(s):               0.4               0.0      0.00      0.00\n      Redo size (bytes):      28,534,906.0           5,647.3\n  Logical read (blocks):         546,914.9             108.2\n          Block changes:         167,747.0              33.2\n Physical read (blocks):              15.2               0.0\nPhysical write (blocks):           4,807.8               1.0\n       Read IO requests:               8.7               0.0\n      Write IO requests:           2,581.3               0.5\n           Read IO (MB):               0.1               0.0\n          Write IO (MB):              37.6               0.0\n           IM scan rows:               0.0               0.0\nSession Logical Read IM:\n             User calls:           3,881.8               0.8\n...\n         Executes (SQL):         104,409.9              20.7\n              Rollbacks:               8.5               0.0\n           Transactions:           5,052.9\n<\/code><\/pre>\n
5000 transactions per seconds, 30MB\/s of redo, that’s not bad. Then are those waits a problem?<\/p>\n
Wait event historgrams<\/h3>\n
\nWait Event Histogram                      DB\/Inst: LABDB1\/labdb1  Snaps: 75-76\n-> Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000\n-> % of Waits: value of .0 indicates value was  % of Waits: column heading of <=1s is truly 1s is truly >=1024ms\n-> Ordered by Event (idle events last)\n                                                    % of Waits\n                                 -----------------------------------------------\n                           Total\nEvent                      Waits  <1ms  <2ms  <4ms  <8ms <16ms <32ms  1s\n------------------------- ------ ----- ----- ----- ----- ----- ----- ----- -----\nlog file parallel write     4.2M  96.3   1.6   1.5    .3    .2    .0    .0\nlog file sequential read   25.8K  22.2  22.5  38.2  14.0   2.3    .6    .1\nlog file single write         22  86.4         9.1                     4.5\nlog file switch (private      73         4.1  75.3  17.8               2.7\nlog file switch completio     20                   100.0\nlog file sync               3.5M  77.5  10.6   7.8   2.1   1.2    .7    .2\n<\/code><\/pre>\n
Log file parallel writes are all less than what you can have with spinning disks, and 96% are less than one millisecond.
\nLog file sync, the only time where a user may wait for an I\/O, is mostly less than 8 millisecond. Actually, the average is:<\/p>\n
\nTop 10 Foreground Events by Total Wait Time\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n \n                                          Total Wait       Wait   % DB Wait\nEvent                                Waits Time (sec)    Avg(ms)   time Class\n------------------------------ ----------- ---------- ---------- ------ --------\nDB CPU                                         9082.7              71.1\nlog file sync                    3,472,568     3487.5       1.00   27.3 Commit\nenq: HW - contention                 3,169        195      61.55    1.5 Configur\n<\/code><\/pre>\n
1 millisecond. Even if a application with a very bad design does an hundred of commits per user interaction, the user will not see it. <\/p>\n
This is done on a database created as-is with the ODA provisioning interface. Files are on ACFS. ODA is bare metal (no virtualization for 2S and 2M). Redo logs have 512 bytes block size.<\/p>\n
So what?<\/h3>\n
This is just a first quick test and it looks promising. This Oracle Database Appliance X6-2M is sold at 24,000 dollars. And the X6-2S at 18,000 dollars has exactly the same storage but only one socket. This is a great opportunity for small customers with few Oracle databases in Enterprise Edition or Standard Edition.<\/p>\n","protected":false},"excerpt":{"rendered":"
By Franck Pachot . The new ODA X-6 has been announced last month with two smaller configurations and smaller prices: 2S and 2M. Small, but high performance configuration: all SSD, and I\/O transfer optimized for Flash with PCIe bus and NVMe protocol. Let’s see how it keeps up with an high OLTP workload. Thanks to […]<\/p>\n","protected":false},"author":27,"featured_media":8599,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[],"type_dbi":[],"class_list":["post-8597","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring"],"acf":[],"yoast_head":"\nODA X-6 log file sync with NVMe flash - 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-x-6-log-file-sync-with-nvme-flash\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ODA X-6 log file sync with NVMe flash\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . The new ODA X-6 has been announced last month with two smaller configurations and smaller prices: 2S and 2M. Small, but high performance configuration: all SSD, and I\/O transfer optimized for Flash with PCIe bus and NVMe protocol. Let’s see how it keeps up with an high OLTP workload. Thanks to […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-07-21T15:04:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureX62M003-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1393\" \/>\n\t<meta property=\"og:image:height\" content=\"857\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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\/oda-x-6-log-file-sync-with-nvme-flash\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"ODA X-6 log file sync with NVMe flash\",\"datePublished\":\"2016-07-21T15:04:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/\"},\"wordCount\":343,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureX62M003-1.png\",\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/\",\"name\":\"ODA X-6 log file sync with NVMe flash - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureX62M003-1.png\",\"datePublished\":\"2016-07-21T15:04:27+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureX62M003-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureX62M003-1.png\",\"width\":1393,\"height\":857},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ODA X-6 log file sync with NVMe flash\"}]},{\"@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":"ODA X-6 log file sync with NVMe flash - 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-x-6-log-file-sync-with-nvme-flash\/","og_locale":"en_US","og_type":"article","og_title":"ODA X-6 log file sync with NVMe flash","og_description":"By Franck Pachot . The new ODA X-6 has been announced last month with two smaller configurations and smaller prices: 2S and 2M. Small, but high performance configuration: all SSD, and I\/O transfer optimized for Flash with PCIe bus and NVMe protocol. Let’s see how it keeps up with an high OLTP workload. Thanks to […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/","og_site_name":"dbi Blog","article_published_time":"2016-07-21T15:04:27+00:00","og_image":[{"width":1393,"height":857,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureX62M003-1.png","type":"image\/png"}],"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\/oda-x-6-log-file-sync-with-nvme-flash\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"ODA X-6 log file sync with NVMe flash","datePublished":"2016-07-21T15:04:27+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/"},"wordCount":343,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureX62M003-1.png","articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/","url":"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/","name":"ODA X-6 log file sync with NVMe flash - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureX62M003-1.png","datePublished":"2016-07-21T15:04:27+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureX62M003-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureX62M003-1.png","width":1393,"height":857},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oda-x-6-log-file-sync-with-nvme-flash\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ODA X-6 log file sync with NVMe flash"}]},{"@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\/8597","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=8597"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/8597\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/8599"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=8597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=8597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=8597"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=8597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}