Oracle Partitioning for DBAs and Developers. Why, when and how to use it?
5 June @ 7:00 pm - 8:00 pm AEST
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 helps 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.
In 12cR2 and 18c we have new features that makes our life much easier. We will see some of these enhancements implemented until Oracle 18c. The main goal here is to show some use cases with different types of partitioning and mainly present scenarios which we should use partitioning and scenarios we should not.
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 go through the following topics:
– Partitioning benefits;
– Types of partitioning;
– Range, Interval, Hash and List partitioning;
– The execution plan;
– Partitioning maintenance operations;
Bonus (in case there is enough time):
– Converting partitions;
– Historical data archiving.
Presenter : Franky Weber Faust
You must register at https://attendee.gotowebinar.com/register/8482177351499109891 if you want to attend this event.