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.
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.
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
Participants are expected to have a working knowledge with Oracle Database 11g.
Following completion by the participants, every single training course is assessed at the levels
and recorded in our "TRIVALUATION" feedback system for quality assurance purposes. This enables us to consistently ensure the high quality and satisfaction of our valued customers. We really appreciate the overall rating of 9.3 from 10 points awarded by our many enthusiastic customers.
Trivadis guarantees the success of your training. Having completed the course / seminar, do you have any questions about the practical aspects? Would you like to repeat any of the exercises in the lab environment?
Our success guarantee allows you to repeat individual days, or even the entire training course, free of charge for up to 6 months after attending a training course. You bring with you the course materials from the previous training course.