Oracle Database 12c – New Performance Features – one-day online training

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. First, 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. Second, new segments related to concepts like partial indexes, zone maps, and attribute clustering are available. Finally, as of version 12.1.0.2, the brand-new In-Memory is available.

The aim of this one-day seminar 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.

O-NF12c-P

Duration

1 day

contents

10 a.m. – 12.30 p.m.: QUERY OPTIMIZER NEW FEATURES

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

1.30 p.m. – 4 p.m.: 12.1.0.2 PERFORMANCE FEATURES

  • In-Memory Column Store
  • In-Memory Aggregation
  • Zone Maps
  • Attribute Clustering
PlaceDateLanguageprice 
We offer you this training course exclusively as an in-house course!
We will be glad to advise you personally about this topic. You can contact us directly at training@trivadis.com or by calling 0800 87 48 23 47. Simply fill in the form below (* required field), and we will get back to you without delay.
back to trainings
0 items in cart

Request an inhouse training

Trivadis, Bernd Rössler, Head of Training

Bernd Rössler

  • Solution Manager Trivadis Training
  • Phone: +49 89 9927 5931
  • Email: bernd.roessler@trivadis.com

Arrange a training consultation now