Get the best out of Oracle 12.2 partitioning features

Table partitioning is a popular database feature used in many of the CERN database schemes based on the Oracle RDBMS. An example is the ATLAS experiment DB applications (based on Oracle 11g) where range, interval (extension of range), list, reference and composite (range-list, list-list) partitioning types are used extensively. As of January 2018, ATLAS production databases have 2508 partitioned tables with total number of 128284 partitions and 21251 sub-partitions. The largest table in terms of partitions has about 60 thousand. With the newest Oracle database version 12.2, DB administrators and developers are interested what new partitioning features are built in the DB engine, what benefits in terms of performance and maintenance they come with and what are the recommendations for their future usage. About the speaker: Thomas Teske works at Oracle Switzerland as Business Development Manager for technology. He gained his experience while working with all releases since Oracle 5. During his 20+ years with Oracle he worked as consultant on data management issues and served customers as sales consultant. Prior to his work at Oracle he studied Physics, obtained a PhD by Georgia Augusta University Göttingen in 1994. He plants real trees and b-trees. More information can be acquired from his LinkedIn profile here