# Get the best out of Oracle 12.2 partitioning features

- Institution: CERN
- Department: CERN Computing Seminar
- Speaker: Thomas Teske
- Year: 2018
- Language: English
- Subjects: Computer science
- Source: [CERN](https://videos.cern.ch/record/3007891)
- Licence: [CERN](http://copyright.web.cern.ch)
- Who can watch: Tweens profiles and older (sources give no ratings; placed by Invisible Network from the source's own words)

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

.

0:00:00 Slide 1

0:04:49 Slide 2

0:06:04 Slide 3

0:06:45 Slide 4

0:07:07 Slide 5

0:07:26 Slide 6

0:07:59 Slide 7

0:08:07 Slide 8

0:08:39 Slide 9

0:09:31 Slide 10

0:09:35 Slide 11

0:09:42 Slide 12

0:09:47 Slide 13

0:09:52 Slide 14

0:09:58 Slide 15

0:10:02 Slide 16

0:11:18 Slide 17

0:12:12 Slide 18

0:13:59 Slide 19

0:14:50 Slide 20

0:14:54 Slide 21

0:16:07 Slide 22

0:20:32 Slide 23

0:20:36 Slide 24

0:21:51 Slide 25

0:23:00 Slide 26

0:23:05 Slide 27

0:23:19 Slide 28

0:23:25 Slide 29

0:23:32 Slide 30

0:23:36 Slide 31

0:24:21 Slide 32

0:25:57 Slide 33

0:27:33 Slide 34

0:28:03 Slide 35

0:28:52 Slide 36

0:29:10 Slide 37…

## Lectures

1. [Get the best out of Oracle 12.2 partitioning features](https://invisiblenetwork.ai/learn/cern/3007891/cb27b6e3b7bc), 1 h 36 min (CERN's player)