<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=1389955974400880&amp;ev=PageView&amp;noscript=1">

Performance Days

The hybrid event to gain maximum Oracle database knowledge and to meet international specialists from all over the world.

On-site in Zurich (Holiday Inn Zürich Messe, Switzerland)
or virtual participation possible!


26. & 27. October 2021

Meet international Oracle database performance specialists and improve your skills.

Trivadis hosts the 12th Performance Days conference with top guest speakers on 26. & 27. October 2021 in Zurich. As in the previous years the focus is on Oracle database performance and query optimization.

Since performance is not simply a product one can buy but rather the results of an accurate planning and a correct implementation, the talks will present valuable techniques not only for troubleshooting performance problems, but also to avoid them in first place.

The event is conducted in English.

  • 26. & 27. October 2021
  • 9:00 am - 5:00 pm

On the evening of 26th there is an opportunity to share your experiences and opinions with the speakers and other participants in a less formal atmosphere as we meet over drinks from 5:00 pm to 7:00 pm


Hybrid Event

Join us either in Zurich (Holiday Inn Zürich Messe in Zurich, Switzerland)


attend the sessions online in our virtual classroom. All sessions are available as live stream. Requirements: access to the internet and headset. You are going to receive your personal account prior to the event. The account is valid for one person.

Attendance Fee

Early booking pays off

Book your ticket until 26. July 2021 to take advantage of the early bird special.

Ticket for Zurich

> early bird special
(until 26. July 2021)

1'595 CHF/EUR

> regular ticket

1'995 CHF/EUR

Online Ticket
> early bird special
(until 26. July 2021)

1'095 CHF/EUR

> regular online ticket

1'395 CHF/EUR


Check out the impressions of the previous event!

What you will learn

Performance Days will provide a lot of valuable and practical information to diagnosing, resolving and avoiding performance problems in applications involving Oracle Database.

The speakers covered topics such as:
  • The lifecycle of a row
  • How to use the active session history to investigate performance problems
  • The most common misconceptions and myths about indexing
  • Introduction to applied machine learning for the DBA
  • How to build a performance prediction system using machine learning and Python
  • How the query optimizer uses statistics to make decitions
  • How to successfully take advantage of optimizer hints

  • New features of the most recent versions regarding performance
  • Performance acceleration of JSON in Exadata and In-Memory
  • Which transformations are used by the query optimizer to deal with such things as subqueries, aggregates, non-mergeable views, partitioned tables and partial indexes
  • What Automatic Materialized Views are and how to take advantage of them
  • Review of frequent pitfalls and fallacies related to parallel execution
Exclusive Speakers

You can look forward to these speakers at the 12th Performance Days

Craig Shallahamer

Craig Shallahamer is President and Founder of OraPub, with over 30 years of experience in consulting, training and tool development in analytics (machine learning) and Oracle database performance tuning for literally hundreds of companies around the world, including Oracle Corporation.

Craig holds a B.S. in Economics from California Polytechnic State University, San Luis Obispo and is an Oracle ACE Director.
He is a frequent presenter at industry events both at the local, national and international levels, such as Oracle OpenWorld, COLLABORATE, Rocky Mountain Oracle User Group (RMOUG), East Coast Oracle User Group (ECO), Germany Oracle User Group (DOAG), UK Oracle User Group (UKOUG), Australia Oracle User Group (AUSOUG) and participates in Oracle speaking tours in Latin America and Asia Pacific regions.

Craig Shallahamer
DBA/Founder/President, OraPub
David Kurtz
David Kurtz has worked with the Oracle Database since 1989 and with PeopleSoft ERP applications since 1996, specialising in system performance tuning. He works as an independent consultant. He is the author of PeopleSoft for the Oracle DBA (published by Apress, www.psftdba.com), and blogs about PeopleSoft (blog.psftdba.com) and Oracle (blog.go-faster.co.uk). David is an Oracle ACE Director and a proud member of the Oak Table. He is a regular presenter at Oracle and PeopleSoft conferences.
David Kurtz

Jonathan Lewis is a well-known figure in the Oracle world with more than 33 years experience using the software. He has published three books about Oracle - the most recent being "Oracle Core" published by Apress Nov 2011 - and contributed to three others. He runs a couple of websites and contributes fairly regularly to newsgroups, forums, and User Group magazines and events around the world. Jonathan has been self-employed for most of his time in the IT industry.
For the last 22 years he has specialised in short-term assignments, typically of a design, review, or trouble-shooting nature. He used to run seminars about using Oracle all over the world and has visited more than 50 different countries to talk about, or trouble-shoot, Oracle systems, but has reduced his travel to a minimum over the last couple of years and only leaves the UK occasionally for special events.

Jonathan Lewis
Independent Consultant
Neil Chandler

Neil has been working in IT since 1988 when he coded 360-Assembler and Cobol on IBM Mainframes against both hierarchical (which are like NoSQL) and relational databases. He started using Oracle software in 1991. He is an independent consultant who specialises in Performance Tuning, RAC, DataGuard, Goldengate, Upgrades, Data Migration, with some PL/SQL and Apex Development. He also has experience with other relational databases, NoSQL databases, and Linux and AIX administration. Neil is an Oracle ACE Director, and a board member of the UKOUG. He likes to drink strong smooth Italian coffee, good beer and better whisky, depending on the time of day.

Neil Chandler
Database Architect, Chandler Systems
Randolf Eberle-Geist
Randolf Eberle-Geist has been working with Oracle software for more than 25 years now, since 2000 as freelance database consultant, focusing primarily on performance related issues, in particular helping people to understand and unleash the power of the Oracle cost based optimizer (CBO). A lot of related information is available on his blog and Youtube channel. Randolf is a regular speaker at some of the major Oracle user conferences and shares his knowledge as DOAG (German Oracle User Group) expert seminar instructor. Randolf is a proud member of the Oak Table Network and was part of the Oracle ACE Director program from 2011 to 2016 - current status is "Oracle ACE Director Alumni".
Randolf Eberle-Geist
Principal Consultant, oracle-performance.de
Roger MacNicol
Roger MacNicol is a Software Architect for Oracle's Data & Storage Technology group. he has been working on core database internals for 36 years and at Oracle for 16 years. He has worked on the implementation of Table Scans, Hybrid Columnar Compression, Exadata Smart Scan, Big Data SQL, and Database In-Memory; he is currently working on Persistent Memory support. Before Oracle, he was the architect for Sybase IQ Query Engine - the world's first commercial columnar database and was the first chairman of the TPC-H subcommittee.
Roger MacNicol
Software Architect Data & Storage Technology, Oracle Corporation

Dani Schnider works as Senior Principal Consultant, trainer and Data Warehouse Lead Architect for Trivadis, a database consulting company in Zurich/Switzerland. Since 1994 he has been working with Oracle databases (version 6 to 19c), since 1997 mainly in Data Warehouse projects. His main focus is architecture, data modeling and physical design of data warehouses, but he also works in development of ETL processes as well as SQL performance tuning.

Dani is co-author of the books “Data Warehousing mit Oracle – Business Intelligence in der Praxis” (Hanser Verlag, 2011) and "Data Warehouse Blueprints" (Hanser Verlag, 2016). He is Oracle ACE and writes about Data Warehousing with Oracle on his blog danischnider.wordpress.com, publishes articles and presents his practical knowledge on conferences.

Dani Schnider
Senior Principal Consultant, Trivadis

Christian Antognini is a strong believer that at the core it is all about the data, and on how effectively companies process and take advantage of it. For that reason, since 1995 he has focused on the efficient use of database engines. His main interests include logical and physical database design, query optimizers, and basically everything else related to data processing and application performance management. He is currently working as a senior principal consultant and trainer at Trivadis in Zürich, Switzerland.

Since 2001, Christian has presented at 100+ conferences and user-group meetings in two dozen countries. He is a proud member of the OakTable Network and is an Oracle ACE Director. He is the author of Troubleshooting Oracle Performance (Apress, 2008/2014) and the co-author of Der Oracle DBA (Hanser, 2011/2016).

Christian Antognini
Senior Principal Consultant, Trivadis

Do not miss the 12th Performance Days 2021

Agenda Performance Days

Day 1 (26th Oct.)

Time Programme
09:00 – 09:10 STAGE 1: Welcome
09:10 – 10:30 STAGE 1: The Lifecycle of a Humble Row (Roger MacNicol)
10:30 - 11:00 Break & Networking
11:00 – 12:20 STAGE 1: Practical Use of Active Session History (David Kurtz)
STAGE 2: Oracle New Performance Features 12c to 21c (Randolf Eberle-Geist)
12:20 - 13:30 Lunch Break
13:30 – 14:50 STAGE 1: An Introduction to Applied Machine Learning for the DBA (Craig Shallahamer)
STAGE 2: Statistics and the Optimizer. How Oracle Makes Decisions (Neil Chandler)
14:50 - 15:20 Break & Networking
15:20 – 16:40 STAGE 1: Transformations - the Things the Optimizer Does (Jonathan Lewis)
16:40 – 19:00 Q&A Session (ask the experts) + Apéro

Day 2 (27th Oct.)

Time Programme
09:10 – 10:30 STAGE 1: Hinting in All It Forms - Pros and Cons (Jonathan Lewis)
10:30 - 11:00 Break & Networking
11:00 – 12:20 STAGE 1: Parallel Execution Pitfalls and Fallacies (Christian Antognini)
STAGE 2: Automatic Materialized Views: How Useful and Easy are they? (Dani Schnider)
12:20 - 13:30 Lunch Break
13:30 – 14:50 STAGE 1: Oracle Database Indexing Myths (Randolf Eberle-Geist)
STAGE 2: Performance Acceleration of JSON in Exadata and In-Memory (Roger MacNicol)
14:50 - 15:20 Break & Networking
15:20 – 16:40 STAGE 1: How to Build a Performance Prediction System Using ML & Python (Craig Shallahamer)
16:40 – 16:50 STAGE 1: Farewell

Target Audience and Requirements

Target audience of this event are performance analysts, database administrators, application developers, as well as consultants who want to improve their skills in managing

performance of database-backed applications involving Oracle database. Participants are expected to have a working knowledge of Oracle database.

We provide special rates for your team or for students. If you want to bring your colleagues, please contact us.


Do you know Trivadis Training?

  • Knowledge from more then 1'900 IT projects / year
  • High-class training courses since 1994
  • Locations in Switzerland, Germany and Austria
  • More then 120 trainer who are working as IT-Consultants

The 12th Performance Days

  • Brand new and first-hand ORACLE topics
  • From practice to practice
  • Exclusive guest speakers
  • Communication platform and networking

Order now your ticket for the Performance Days 2021