Oracle Database In-Memory – What’s New and What’s Coming
Oracle Database In-Memory transparently accelerates analytics by orders of magnitude, allowing users to get immediate answers to business driving questions that previously took hours.
This session provides a clear understanding of how our unique “dual format” architecture works and illustrates how the new in-memory functionality interacts with key database performance features such as Oracle Real Application Clusters (Oracle RAC), Oracle Exadata, and much more. Attendees will also get a sneak peak at where Oracle Database In-Memory is going next.
Oracle Database In-Memory By Example
With Oracle Database 12c comes a new In-Memory column store compatible with all existing applications. But how does it work and what steps do you need to take to get started with this new technology? Rather than answering these questions with a traditional PowerPoint presentation, this session will be conducted completely on the command line via SQL*Plus. Step by step examples will demonstrate how our in-memory dual format enables both superfast analytics and online transaction processing. We will also show how it integrates with Oracle's existing performance features including the Optimizer, indexes, Materialized Views etc. By attending this session you will arm yourself with the necessary knowledge to not only get started with Database in-Memory but to dramatically improvement the performance of your analytical workload regardless of your Oracle environment.
Oracle Optimizer – Best Practices for Managing Optimizer Statistics
During the optimization of a SQL statement the Optimizer relies heavily on statistics to estimate the number of rows produced by each of the SQL operators. The quality of the statistics for the objects referenced in the statement greatly affects the quality of the plan. Statistics maintenance is a challenge all DBAs must face in order to prevent execution plan from becoming suboptimal.
This presentation includes information on the features introduced in both Oracle Database 11g and 12c to improve the quality and efficiency of statistics gathering, as well as strategies for managing statistics in various database environments. These strategies include how to use dynamic sampling and when, and how, to manually set statistics directly versus collecting them.