Hello folks, I’m just passing by to say that I am going to speak about Oracle Partitioning at the BGOUG (Bulgarian Oracle Users Group) conference in Borovets in Bulgaria on June 8th, 2018 at 4:30 p.m. The conference takes place at the Rila hotel in Borovets. This will be my first time at an international conference, so I am very excited with the opportunity and I am making an extreme effort to take great content to the people present in my session.
This is the abstract for my presentation:
Oracle Partitioning for DBAs and Developers. Why, when and how to use it?
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 gave 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;Bonus (in case there is enough time):
– Converting partitions;
– Historical data archiving.
Many great names will attend this conference. You can check the agenda of the event here in this link.
Here is the main page for the event if you’d like more details: http://website.bgoug.online/en/events/details/101.html
I hope to learn a lot in this conference.
See you there,
Franky