{"id":443,"date":"2013-10-04T13:59:28","date_gmt":"2013-10-04T11:59:28","guid":{"rendered":"http:\/\/www.ludovicocaldara.net\/dba\/?p=443"},"modified":"2013-11-11T11:05:33","modified_gmt":"2013-11-11T09:05:33","slug":"exciting-news-from-oracle-open-world-2013","status":"publish","type":"post","link":"https:\/\/www.ludovicocaldara.net\/dba\/exciting-news-from-oracle-open-world-2013\/","title":{"rendered":"Exciting News from Oracle Open World 2013"},"content":{"rendered":"<p><a href=\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2013\/10\/sfo_cut.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-444 alignleft\" alt=\"sfo_cut\" src=\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2013\/10\/sfo_cut.jpg\" width=\"288\" height=\"275\" srcset=\"https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2013\/10\/sfo_cut.jpg 600w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2013\/10\/sfo_cut-300x287.jpg 300w, https:\/\/www.ludovicocaldara.net\/dba\/wp-content\/uploads\/2013\/10\/sfo_cut-313x300.jpg 313w\" sizes=\"auto, (max-width: 288px) 100vw, 288px\" \/><\/a>I&#8217;m back at work now, safely, after the week in San Francisco.<\/p>\n<p>It&#8217;s time to sit down, and try to pull out some thought about what I&#8217;ve experienced and done.<\/p>\n<p>I&#8217;ll start from the new announcements, what is most important for most people, and leave my personal experience for my next post.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>In-memory Database Option<\/strong><\/p>\n<p>Oracle has announced the In-Memory option for the Oracle Database. This feature will store the data simultaneously in traditional row-based and into a new in-memory columnar format, to serve optimally both analytics and OLTP workloads AT THE SAME TIME. Because\u00a0column-based storage is redundant, it will work without logging mechanism, so the overhead will be minimal.\u00a0The <em>marketing message<\/em>\u00a0claims <em>&#8220;ungodly speed&#8221;:\u00a0<\/em>100x faster queries for analytics and 2x faster queries in OLTP environments.<\/p>\n<p>By separating Analytics and OLTP with different storage formats, the indexes on the row-based version of the table can be reduced to make the transactions faster, getting the rid of the analytical indexes thank to the columnar format that is already optimized for that kind of workload.\u00a0The activation of the option will be transparent to the applications.<\/p>\n<p>How it will be activated?<\/p>\n<pre>inmemory_size = XXX GB\r\n\r\nalter table foo ... inmemory;<\/pre>\n<p>Now my considerations:<\/p>\n<ul>\n<li>[evil] Will this option make your database faster than putting it on an actual Exadata?<\/li>\n<li>It will be an option, so it will cost extra-money on top of the Enterprise Edition<\/li>\n<li>[I guess] it will be released with 12cR2 because a such big change cannot be introduced simply with a patch set. So I think we&#8217;ll not see it before the end of 2014<\/li>\n<li>And, uh, Maria Colgan has given up the Product Management of the Cost Based Optimizer to become the Product Manager of the In-Memory option. Tom Kyte will take the ownership of the CBO.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>M6-32 Big Memory Machine<\/strong><\/p>\n<p>I&#8217;ve paid much less attention for this new announcement. The new big super hyper machine engineered by Oracle will have:<\/p>\n<ul>\n<li>1024 DIMMS<\/li>\n<li>32TB of DRAM<\/li>\n<li>12 cores per processors<\/li>\n<li>96 threads per processor<\/li>\n<\/ul>\n<p>This huge memory machine can be connected through InfiniBand to an Exadata to rely on its storage cells.<\/p>\n<p><strong>But<\/strong> it will cost 3M$, so it&#8217;s not really intended for SMBs or for the average DBA, that&#8217;s why I don&#8217;t care too much about it&#8230;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Oracle Database Backup, Logging, Recovery Appliance<\/strong><\/p>\n<p>Only 8 minutes in the keynote to introduce this appliance that is really hot, IMHO. This&#8230; oh my&#8230; let&#8217;s call it <a href=\"http:\/\/www.oracle.com\/us\/corporate\/features\/database-backup-logging-recovery-appliance\/index.html\"><em>ODBLRA<\/em><\/a>, is a backup appliance (based on the same HW of Exadata) capable of receiving the stream of redo logging over SQL*Net, the same way as it&#8217;s done with DataGuard, except that instead of having a standby database, you&#8217;ll have an appliance capable of storing all the redo stream of your entire DB farm and have a real-time backup of your transactions. That&#8217;s it: no transactions lost between two backup archives and no need to have hundreds of \u00a0DataGuard setups or network filesystems as secondary destinations in order to make your redo stream safer.<\/p>\n<p>I guess that it will host an engine RMAN-aware that can create incremental-updated backups, so that you can almost forget about full backups. You can leverage an existent tape infrastructure to offload the appliance if it starts getting full.<\/p>\n<p>Your <a href=\"http:\/\/www.oracle.com\/us\/corporate\/features\/database-backup-logging-recovery-appliance\/index.html\">ODBLRA <\/a>can also replicate your backups to an another appliance hosted on the Oracle Cloud: ODBLRAaaS! \u00a0\ud83d\ude42<\/p>\n<p>To conclude, Oracle is pushing for bigger, dedicated, specialized SPARC machines instead of relying on commodity hardware&#8230;<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Oracle Multi-tenant Self-Service Provisioning<\/strong><\/p>\n<p>There&#8217;s a new APEX application, now in BETA, that can be downloaded from the <a href=\"http:\/\/www.oracle.com\/us\/products\/database\/options\/multitenant\/overview\/index.html\">Oracle Multitenant Page<\/a>\u00a0that provides self-service provisioning of databases in a Multitenant architecture. It&#8217;s worth a try&#8230; if you plan to introduce the Multitenant option in your environment!<\/p>\n<p>&nbsp;<\/p>\n<p><strong>All products in the Cloud<\/strong><\/p>\n<p>Oracle now offers (as a preview) its Database, \u00a0Middleware and Applications as a Service, <a href=\"http:\/\/cloud.oracle.com\">in its public cloud<\/a>. For a DBA can be of interest:<\/p>\n<p>The <strong>Storage<\/strong> aaS, use Java &amp; REST API (Openstack SWIFT) for block level access to the storage.<\/p>\n<p>The <strong>Computing<\/strong> aaS allows you to scale the computing power to follow your computing needs.<\/p>\n<p>The <a href=\"https:\/\/cloud.oracle.com\/mycloud\/f?p=service:database:0\"><strong>Database<\/strong> aaS<\/a> is the standard, full-featured Oracle Database (in the cloud!) 11gR2 or 12c in all editions (SE, SE1, EE). You can choose five different sizes, up to 17cores and 256Gb of RAM, and choose 3 different formulas:<\/p>\n<ul>\n<li>Single Schema (3 sizes: 5, 20 or 50Gb, with prices from 175$\/month to 2000$\/month)<\/li>\n<li>Basic Database (user-managed, single-instance preconfigured databases only with a local EM)<\/li>\n<li>Managed Database (single-instance with managed backups &amp; PITR, managed quarterly apply of critical parches)<\/li>\n<li>Premium Managed Database (fully managed RAC, with optional DG or Active DG, PDB and upgrades)<\/li>\n<\/ul>\n<p>My considerations:<\/p>\n<ul>\n<li>Oracle releases this cloud offering with significant delay comparing to his competitors<\/li>\n<li>It&#8217;s still in preview and there&#8217;s no information about the billing schema. Depending on that, it can be more or less attractive.<\/li>\n<li>As for other cloud services, the performance will be acceptable only when putting all the stack into the same cloud (WebLogic, DB, etc.)<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Oracle on Azure<\/strong><\/p>\n<p>Microsoft starts offering <a href=\"http:\/\/www.windowsazure.com\/en-us\/campaigns\/oracle\/\">preconfigured Oracle platforms<\/a>, Database and WebLogic,\u00a0 on Azure on both Linux and Windows systems. I haven&#8217;t seen the price list yet, but IMHO Azure has been around since longtime now, and it appears as a reliable and settled alternative comparing to Oracle Cloud. Nice move Microsoft, I think it deserves special attention.<\/p>\n<p>&nbsp;<\/p>\n<p><strong> Keynotes recordings<\/strong><\/p>\n<p>You can see the full keynote recordings here:<\/p>\n<p><a href=\"http:\/\/www.oracle.com\/openworld\/live\/on-demand\/index.html#oow\">Oracle OpenWorld Keynote Highlights<\/a><\/p>\n<p><a href=\"http:\/\/medianetwork.oracle.com\/video\/player\/2685494045001\">Larry Ellison &#8212; Oracle OpenWorld Keynote 9-22-2013<\/a><\/p>\n<p><a href=\"http:\/\/medianetwork.oracle.com\/video\/player\/2686974264001\">Oracle OpenWorld General Session 2013: Database<\/a><\/p>\n<p><a href=\"http:\/\/medianetwork.oracle.com\/video\/player\/2688514646001\">Kurian and Fowler &#8212; Oracle OpenWorld Keynote 9-24-2013<\/a><\/p>\n<p>&nbsp;<\/p>\n<p>Will these announcements change your life? Let me know&#8230;<\/p>\n<p>&#8230;and stay tuned, I&#8217;ll come soon with a new post about the my &#8220;real&#8221; week at the Open World and why I&#8217;ve loved it.<\/p>\n<p>Ludovico<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;m back at work now, safely, after the week in San Francisco. It&#8217;s time to sit down, and try to pull out some thought about what I&#8217;ve experienced and done. I&#8217;ll start from the new announcements, what is most important &hellip; <a href=\"https:\/\/www.ludovicocaldara.net\/dba\/exciting-news-from-oracle-open-world-2013\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[116,3,52,132],"tags":[124,122,119,117,118,120,123,121,101,125],"class_list":["post-443","post","type-post","status-publish","format-standard","hentry","category-events-and-conferences","category-oracledb","category-12c","category-triblog","tag-azure","tag-backup-logging-recovery-appliance","tag-big-memory-machine","tag-cloud","tag-in-memory","tag-m6-32","tag-multitenant-self-service","tag-odblra","tag-oow13","tag-open-world"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/443","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/comments?post=443"}],"version-history":[{"count":12,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/443\/revisions"}],"predecessor-version":[{"id":456,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/443\/revisions\/456"}],"wp:attachment":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/media?parent=443"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/categories?post=443"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/tags?post=443"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}