Oracle Partitioning for DBAs and Developers. Why, when and how to use it?

Most VLDBs should use partitioning and in today's world scaling up and out a database is something critical, so every DBA and Developer should work together to accomplish this task. Partitioning may help the application run faster and also help DBAs to perform their work easier. The partitioning feature exists in Oracle since version 8 and since then it is being enhanced each new version.From 12cR2 up to 19c we have new features that make our life much easier. We will see some of these enhancements implemented until Oracle 19c. The main goal here is to show some use cases with different types of partitioning and mainly present scenarios which we should use and scenarios we should not use partitioning.When we think of partitioning we should think that we have a big task and it would be interesting to split it in many small ones. In some cases this will ease our work, but in others it will make it harder. We can improve performance and maintainability, but in many cases we can also ruin everything, that is why we should care about this subject and give importance to it.We will go through the following topics:- Partitioning benefits- Types of partitioning- Range, Interval, Hash and List partitioning- The execution plan- Partitioning maintenance operations