Striving for Optimal Performance
  • Blog
    • Archive
    • Categories
    • Search
  • Troubleshooting Oracle Performance
    • Description
    • Structure
    • Table of Contents
    • Forewords
    • Reviews
    • Downloadable Files
    • Addenda and Errata
    • First Edition
  • Public Appearances
    • Past Public Appearances
  • Contact
  • About

Online Training Ad: Oracle Database 12c – New Performance Features

23 September 2015 Leave a Comment Written by Christian Antognini

On 10 December 2015 I’ll give an online training entitled Oracle Database 12c – New Performance Features. This short post provides key information about it.

Description

With every new release of Oracle Database, a number of features aimed at improving performance are introduced. It goes without saying that 12.1 is no exception to the rule. Notably, it introduces key improvements in three areas.

  • The query optimizer has been enhanced not only by the introduction of adaptive query optimization techniques, but also with improvements in object statistics and dynamic sampling.
  • New segments related to concepts like partial indexes, zone maps, and attribute clustering are available.
  • As of version 12.1.0.2, the brand-new In-Memory is available.

The aim of this one-day online training is to review the new performance features from a practical point of view as well as to point out challenges related to them. In other words, to let you know what you can expect from the new performance features when you upgrade to Oracle Database 12c.

Content

Query Optimizer New Features

  • Adaptive Query Optimization
  • Object Statistics
  • Plan Stability
  • Indexes

12.1.0.2 Performance Features

  • In-Memory Column Store
  • In-Memory Aggregation
  • Zone Maps
  • Attribute Clustering

For additional information and to subscribe, visit this page.

12.1.0.2, 12cR1, Speaking, Trivadis
Foreign Keys and Library Cache Locks
Auto SGA Management Impacts the Default Value of DB_FILE_MULTIBLOCK_READ_COUNT

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.