|Baking Big Data Batches: Fan-Out Parallel Query and Big Data SQL||Orchestrating efficient parallel scan of multiple datastores as part of a single query is complicated. For each query, a balance must be struck between synchronized, serial control from the query coordinator and asynchronous parallel behavior from the remote systems. Oracle Big Data SQL provides a novel solution to this problem which provides a unique ability to orchestrate fan-out parallelism on query which simultaneously touch Oracle Exadata and Hadoop. In this talk, we explore changes to Oracle Parallel Query necessary to accomplish this parallelism, and discuss future improvements to both the control and execution of queries spanning Oracle Database and data source ranging from Hadoop to NoSQL sources.|| Dan McClary|
|Real World Experience with the (O)VCA||This presentation will cover my real world experience with a large VCA based project. The project encompasses the deployment of 3 VCA units - each with 12+ compute nodes. ZFS ZS-32 storage is used as the underlying storage component.
In the presentation I will discuss the issues surrounding VCA deployment including Windows VM specifics, external storage presents (using FC, iSCSI, NFS), tape storage and backup issues, OVM Manager, EM12c integration, patching and new node inclusion, network issues (including firewalls and routing) as well as the tools used and benchmarks we created for storage, network and compute aspects. We will discuss both the positives and the negatives of the solution which covers several hundred VMs for Linux and Windows.
I will also discuss the benefits we encountered for specific tuning using ZFS and how it actually is a very good storage platform for consolidation. || James Anthony|
|DBaaS at Scale: Engineered Systems Consolidation in Banking||This presentation will show the design decisions taken and the engineering work that was required for a large scale DBaaS implementation project at a global investment bank.
The bank had decided to consolidate it’s entire oracle estate of several thousand databases onto a collection of Exadata racks and ODA’s. This presentation will focus on the engineering challenges that were faced in ensuring these new engineered systems were production ready for use within the bank.
After attending this presentation attendees will have an idea of what design decisions are required when performing an engineered systems consolidation at scale and will be better placed to avoid some of the pitfalls when using engineered systems for your consolidation project.|| Jason Arneil, Jason Arneil|
|Modern Infrastructure Science: Old Doctrines, New Doctrines||Aside from the all the cultural, financial and vendor disruption, the doctrines that underlie what Google, Yahoo and Facebook initiated (resulting in things like Accumulo, Hadoop and Hive and Open Compute) was to completely deconstruct everything about doing computing at scale and with it, came a different set of developmental and operational doctrines that were driven by the business and less by vendors and they way it had always been done.|| Jeff Needham|
|Capacity Planning||Capacity Planning|| Kapil Goyal|
|A Deep Dive into HCC Mechanics & Internals||HCC is a much hyped Oracle feature. Unfortunately, there are still too many misconceptions about HCC circulating on Oracle forums and on blogs. This talk is about demystifying these. The audience will learn about the concepts of HCC as well as the other Oracle compression algorithms (basic/OLTP) before diving into the HCC-specific compression algorithms and their implementation. We will use block dumps to show the structure of the so-called Compression Unit and how to decode it.
Useful tips from HCC implementations with regards to lifecycle management (ILM) including the new 12c Automatic Data Optimisation conclude this talk.|| Martin Bach|
|Super Cluster : the SWISS army knife of the Engineered Systems||This session will describe what was learned by moving from 3 M9000 s to 2 Super Clusters.
The last couple of years lots of Engineered systems saw the light the Sparc Super Cluster (SSC) is one of them.
It offers lots of flexibility and ways to consolidate your current Solaris environment at your own pace to Exadata Storage Cell powered SPARC hardware and protects your investments
This talk will give a short overview of the line-up but focusses on the technology used and the steps taken to consolidate 3 M9000's onto 2 Super Clusters.
Lots of Oracle Database technologies were be used in this project :
RAC One and Data Guard,
using RAT to testdrive,
DBRM, instance Caging and IORM to make consolidation work
Entreprise Manager 12c and the exadata plugging
It will give a brief overview of what the Super Cluster is and why it is a great solution if you are a Solaris shop and want a flexible solution with the power Exadata Storage Cells.
It will go over the issues encountered and how they were resolved, it will describe the stages of the project and give an overview of the technologies used ; Rac One , Data Guard , Real Application Testing, Advanced Compression , Resource Manager, IORM. It will describe how the infiniband network and zones are working together.
If you want to know how the Oracle Super Cluster can make a difference for you and your organisation, how to avoid the pitfalls and potential issues then this session is for you.
|| Philippe Fierens|
|Where’d My Resources Go? Capacity Planning at Exa-Scale||Oracle Exadata Database Machine is designed to significantly improve performance of OLTP, Data Warehouse, and mixed load applications. Managing CPU, Memory, and IO resources is key for good performance. While Exadata engineered systems provide a large number of resources and a wealth of metrics to describe the utilization of those resources. But how does one rationalize 300+ metrics into a story about current utilization and forecasted capacity? This session will describe how we solved this problem for a Fortune 5 bank. We will go over how to organize and aggregate metrics to tell a capacity story. We will discuss methods to forecast future utilization in the presence of noisy data, environment changes (patches, incidents, downtime), and future business forecasts. Unlike most forecasts, this method predicts a distribution of outcomes so one can look at not only the average case, but also outcomes with a 5% probability. We will wrap up with a novel dashboard view of an Exadata system that can show a manager the current and 6-month projected utilization at a system level while allowing a performance tuner to delve down into the details.|| Rishi Khan|
|SmartScan Deep Dive||A top-to-bottom look at how “Table Access Full” works in the context of SmartScan including recent developments in how buffer cache and direct read work together, the introduction of “offload servers”, how SmartScan works with DBIM, and new features in 126.96.36.199. We will also be looking at SmartScan changes for the X5, the All Extreme-Flash configuration, and Big-Data SQL. This talk finishes with notes on how to triage issues with SmartScan in the field.|| Roger MacNicol, Roger MacNicol|
|Tips and Tricks for Successful Consolidation on Exadata||How do you guarantee CPU or flash space for a particular database? Or keep one database's heavy scan workload from slowing down a critical OLTP database? Or ensure one database's excessive PGA usage doesn't destabilize another? In this session, we will guide you through the best way to use Resource Manager for both departmental and cloud consolidation, focusing on the features added in the latest Exadata release.|| Sue Lee, Sue Lee|
"Every day I learn at least one thing new about Oracle - at E4, it was way more than just one. Highly recommended."
- Tom Kyte, Oracle
"E4 is the only conference where you can both listen to the experts of Exadata and talk about the real case scenarios with the biggest Exadata customers."
- Ferhat Sengonul, Turkcell