Conferences 2018

Here are the conferences where I speak this end of year

This is an explanation of the join methods, with live demos on very simple cases, reading execution plan statistics, looking at how it is executed. And how to improve the query performance: hints, partitioning, indexing. The goal is to understand, with modern tracing tools (dbms_xplan and SQL Monitoring), the basic core stuff that is involved in all query tuning: the join methods, the estimations that drive the choice between full scan and index access, the transformations that avoid unnecessary joins.

  • POUG 2018 September 07, 2018
  • DOAG 2018 VOM 20. BIS 23. NOVEMBER 2018
  • Oak Table World 2018 22–23 OCTOBER 2018

The role of the DBA changes with the cloud and autonomous managed services. The multitenant architecture is the foundation for these new roles. The container database/pluggable database (CDB/PDB) paradigm enforces role segregation between the container DBA and the application. In a DevOps environment, you need the finer access privilege definition that comes in Oracle Database 12.1 (common/local users) and Oracle Database 12.2 (lockdown profiles, PDB isolation), and that was improved in Oracle Database 18c. In this session learn to administer a cloud or on-premises database and give PDB administration rights to application teams. See how to grant database access to a developer on a PDB with Oracle Database 18c. Discover the new features, see a demo, and learn best practices.

  • Oracle Open World October 22–25, 2018 San Francisco, CA

The database is always a problem: it is a single point of failure for applications; it makes any continuous integration/delivery impossible; the DBA is a drag on your agile developments; and any interaction with the database is done with unmaintainable, complex, old-style SQL queries. Those are the reasons why modern architects want to get all code out of the database and even the data moved out to caches, local to CQRS microservices. But there are drawbacks with this approach, and doing it incorrectly may show the worst once implemented. This session focuses on the antipatterns and shows, with facts and measurements, what can be wrong in the implementation. This knowledge may help you design your applications with scalability in mind.

  • Oracle Code One October 22–25, 2018 San Francisco, CA

Developers need to quickly get a database up and running without wasting time waiting for the DBA or doing the whole installation themselves. Docker containers are perfect for that. But there are two big problems with Oracle Database. First, the default installation is huge, and you do not want a 20GB image to start a container. Second, the database must persist beyond the container lifecycle. This means that we need to create it in external volume. But do you accept a 15 minutes database creation at ‘docker run’?

There can be different solutions to address different needs: a small database to run on a laptop, a large number of databases running on OpenShift, quick continuous integration ephemeral databases…

This session will show some ideas to run Oracle Database in a container in an efficient way. With some tuning and tweaks, it is possible to provide a small image that can run in seconds. And is that different, or complementary, to multitenant containers?

  • UKOUG Tech18, Liverpool, 04/12/2018, 11:40–12:25



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Franck Pachot

Developer Advocate at Yugabyte, Open Source distributed SQL database 🚀 Also Oracle ACE Director, Oracle Certified Master, AWS Data Hero, OakTable member