Here are the conferences where I speak this end of year
Join Methods: Nested Loop, Hash, Sort, Merge, Adaptive
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
Database consolidation brings another level to performance analysis. How to measure shared resources utilization…poug.org
- DOAG 2018 VOM 20. BIS 23. NOVEMBER 2018
This is about the basics: the join methods. Not really new, but the core stuff that must be understood for any SQL…www.doag.org
- Oak Table World 2018 22–23 OCTOBER 2018
Multitenant Security Features Clarify DBA Role in DevOps Cloud
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
Microservices: Get Rid of Your DBA and Send the DB into Burnout
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
Oracle Database on Docker: Lessons Learned
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