Since its inception in 2008, the Exadata platform has evolved from a balance hardware configuration for Data Warehouse environments to the platform of choice for all database applications. With each new release Exadata has introduced key performance enhancing features such as query offload, storage indexes, flash cache, and Hybrid Columnar Compression. Knowing when and how to take advantage of each of these features can be a daunting task even for the Oracle Optimizer, whose goal has always been to find the optimal execution plan for every SQL statement. This session explains in detail how the Oracle Optimizer costing model has been impacted by the introduction of the performance enhancing feature of the Exadata platform. It will show through the use of real-world examples what you can do to ensure the Optimizer full understands the capabilities of the platform it is running on without having to mess with initialization parameters or Optimizer hints.
Become a member of ODTUG to gain access to more than 12,500 files in our technical database.
- Not a member? Click through to the topic of interest to browse a list of available presentations.
- Already a member? Log-in here to access the full database
Click here to see the Full Techincal Resource Database