Olá pessoal, estou passando rapidamente aqui para dizer que vou palestrar sobre Oracle Partitioning na conferência do BGOUG (Bulgarian Oracle Users Group) em Borovets na Bulgária dia 08 de Junho de 2018 às 16:30. A conferência acontece no hotel Rila in Borovets resort. Será minha primeira participação numa conferência internacional, então estou muito empolgado com a oportunidade e estou me esforçando muito para levar um excelente conteúdo para os conferencistas presentes na minha sessão.
Esta será a abordagem da palestra:
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.
Muitos grandes nomes estarão presentes nesta conferência. Você pode conferir a agenda do evento aqui neste link.
Aqui está a página principal do evento para mais detalhes: http://website.bgoug.online/en/events/details/101.html
Espero aprender muito neste evento.
Grande abraço a todos,
Franky