Oracle Database 12c – New Performance Features – two days online training

With every new release of the Oracle Database, a number of features aimed at improving performance are introduced. It goes without saying that 12c is no exception to the rule. This seminar will teach you what to expect from these performance features once you have upgraded to Oracle Database 12c Release 1 or Release 2. The seminar will introduce you to key performance improvements in four 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 query transformations.
Second, new or enhanced data structures related to concepts like partial indexes, materialized views, zone maps, and attribute clustering are available. Third, In-Memory option features like in-memory column store and in-memory aggregation. Finally, version 12.2 introduces approximate query processing.

O-NF12c-P

Duration

2 days

goal

  • Understand the new performance features from a practical point of view
  • Gain insight in the challenges related to these features.

target group

Performance analysts, database administrators, application developers, as well as consultants who want to improve their skills in the new performance features provided by Oracle Database 12c Release 1 and Release 2.

contents

Query optimizer (adaptive query optimization, object statistics, plan stability, query transformations
Data structures (indexes, partitioning, materialized views, zone maps, attribute clustering)
In-memory option (in-memory column store, in-memory aggregation)
Approximate query processing

Requirements

Participants are expected to have a working knowledge with Oracle Database 11g.

PlaceDateLanguageprice 
Virtual Classroom
30.10. - 31.10.2017
DE1'680.00 CHF
Inhouse on demand!inquiry
  •    Guaranteed to take place
  •    The course will definitely take place if you make a booking
  •    There are no free places left on this course. If you still book it, we will place you on the waiting list.

  • This course is held in another country. Due to the different tax conditions, you will have to book it in a separate booking process. We apologize for any inconvenience.
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
  • “I'll be glad to advise you on topics such as individual coaching, workshops, project support, and online training courses.”

    Your Bernd Rössler

Arrange a training consultation now