CERN Computing Seminar

Get the best out of Oracle 12.2 partitioning features

by Dr Thomas Teske (Oracle)

Europe/Zurich
40-S2-C01 - Salle Curie (CERN)

40-S2-C01 - Salle Curie

CERN

92
Show room on map
Description

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

 

Organized by

Gancho Dimitrov (ATLAS)

Videoconference Rooms
Get_the_best_out_of_Oracle_12_2_partitioning_features
Name
Get_the_best_out_of_Oracle_12_2_partitioning_features
Description
Get the best out of Oracle 12.2 partitioning features
Extension
10697301
Owner
Gancho Dimitrov
Auto-join URL
Useful links
Phone numbers
Contact
Your browser is out of date!

Update your browser to view this website correctly. Update my browser now

×