<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 Event to gain maximum Oracle Database knowledge and to meet international specialists from all over the world. 
Zurich, Switzerland

 

Meet international oracle database performance specialists and improve your skills

Trivadis organized the 9th Performance Days congress with top guest speakers in Zurich. This year’s focus was 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 seminars present valuable techniques not only for troubleshooting performance problems, but also to avoid them in first place.

2019 was a blast!

What you learned

Performance Days provided 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:
  • New indexing and partitioning features introduced in Oracle Database 18c and 19c
  • Why it is of paramount importance to keep your SQL statements simple
  • The role of the infrastructure in Oracle Database performance
  • Using resource management to deliver predictable performance
  • In-depth look at how Oracle Database processes joins and star queries
  • Leveraging execution plans for problem solving
  • Using Oracle's kernel debug, diagnostics and tracing infrastructure as well as ASH for troubleshooting
  • Why you probably do not need to read a 10053 trace file
  • How to gather object statistics
  • Tracing parallel executions to better understand how it works
  • What parent and child cursors as well as adaptive cursor sharing and statistics feedback are
Exclusive Speakers

Who were the exclusive speakers on the 9th "Performance Days" Convention?

Christian Antognini

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.

If Christian is not helping one of his customers get the most out of databases, he is somewhere lecturing on application performance management or database performance features. In addition to classes and seminars organized by Trivadis, since 2001 he 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. Christian is the author of Troubleshooting Oracle Performance (Apress, 2008/2014) and the co-author of Der Oracle DBA (Hanser, 2011/2016).

Topic: "Shareable Cursors"

Christian Antognini
Senior Principal Consultant, Trivadis
Ivica Arsov

Ivica is Real-World Performance Engineer at Oracle Real-World Performance group which is part of development organisation. Ivica's main focus is on database performance and systems stability. Ivica is an Oracle Certified Master for versions 12c and 11g. He is an active contributor to the Oracle community, he has spoken at numerous Oracle conferences including Oracle Open World. Ivica is also maintaining his own blog where he shares his professional knowledge. Known for his deep Oracle expertise and ability to troubleshoot efficiently, Ivica has the skills to identify and approach problems in analytical manner regardless of size and complexity.

Topic: "Tracing Parallel Execution"

Ivica Arsov
Oracle Real World Performance, Oracle
Mark Ashdown

Mark Ashdown has worked with the Oracle Database for over twenty five years and before that with a variety of other database products. He joined Oracle 22 years ago and has worked in Consultancy and the Oracle Solution centre where he was one of the team who lead the introduction of Exadata into the EMEA region. Over the last 4 years he has been in the Oracle Real World Performance team which is part of the development organisation. He administers the team's hardware and software estate. He also presents the Real World Performance Workshop across the world which is a concentrated performance related workshop. He also engages with customers with performance related issues and resolves them in conjunction with the customer and Oracle development themselves.

Topics: "Controlling the Chaos – Using Resource Management for Predictable Performance" & "Successful Star Schemas"

Mark Ashdown
Oracle Real World Performance
Shasank Chavan

Shasank Chavan is the Vice President of the In-Memory Technologies group at Oracle. He leads an amazing team of brilliant engineers in the Database organization who develop customer-facing, performance-critical features for an In-Memory Columnar Store which, as Larry Ellison proclaimed, “processes data at ungodly speeds”. His team implements novel SIMD kernels and hardware acceleration technology for blazing fast columnar data processing, optimized data formats and compression technology for efficient in-memory storage, algorithms and techniques for fast in-memory join and aggregation processing, and optimized in-memory data access and storage solutions in general. His team is currently hyper-focused on leveraging emerging hardware technologies to build the next-generation data storage engine that powers the cloud. Shasank earned his BS/MS in Computer Science at the University of California, San Diego. He has accumulated 15+ patents over a span of 20 years working on systems software technology.

Topic: "Deep Dive into the Implementation of Oracle's Join Methods: Past, Present and Future"

Shasank Chavan
Vice President, In-Memory Technologies, Oracle
Richard Foote

Based in Canberra, Australia, Richard has been working in the IT industry for nearly 30 years, 20 plus years with Oracle Database technologies. Richard has supported and diagnosed the performance of numerous highly secure, mission-critical, large-scale applications. In 2002, he became a member of the world-renowned Oracle OakTable Network and an Oracle ACE Director in 2008. Richard is a very popular speaker and regularly presents at conferences including Oracle OpenWorld, IOUG Collaborate, Hotsos Symposium, AUSOUG InSync, ODTUG Kscope, UKOUG Conference and the E4 Enkitec Extreme Exadata Expo. He is especially renowned for his research and knowledge of Oracle indexing structures, hosts an internationally acclaimed blog on Index Internals and has developed in-depth seminars on Oracle Internals which he has presented in over some 18 countries. In 2017 Richard started his own independent consulting and training business.

Topics: "Oracle Database 18c and 19c New Indexing Related Features" & "Indexing With Partitioning"

Richard Foote
Independent Oracle Consultant
Emiliano Fusaglia

I am an IT specialist and I have been managing Oracle Databases since 2000. After some years dedicated to programming I have been specializing as an Oracle DBA covering all the aspects: data modeling, installation, migration, procedures for backup/recovery, PL/SQL, tuning and support to developers. I’m skilled in the design and implementation of High Availability architectures with RAC, ASM, Data Guard and vendor specific solution for Disaster Recovery. I have been working on engineering and on operation with complex environments, running business critical databases.
I’m an active member of the Trivadis Training Center and since few years I enjoy speaking in public events sharing my Oracle experience with the audience.

Topic: "The Key Role of Infrastructure in Oracle Database Performance"

Emiliano Fusaglia
Principal Consultant, Trivadis
Stephan Köhler

Stefan Koehler follows his passion about Oracle since +16 years and specialized in Oracle performance tuning, especially in Oracle cost based optimizer (CBO) and database internal related topics. Nowadays he primarily works as an independent Oracle Database performance consultant and researcher in large mission critical environments (e.g. +10 TB databases) for market-leading companies or multi-billion dollar enterprises in various industries all over the world. He usually supports his clients in understanding and solving complex Oracle performance issues and troubleshooting nontrivial database issues on short-term contracting basis. He is also a proud member of the OakTable Network and is recognized/rewarded as an Oracle ACE by Oracle’s ACE program.Topic: "Identifying Performance Problems in a Multitenant Environment" and “How Autonomous is the Oracle Autonomous Data Warehouse?"

Topic: "Troubleshooting with Oracle's Kernel Debug, Diagnostics and Tracing Infrastructure"

Stephan Köhler
Independent Oracle Consultant and Researcher
Jonathan Lewis

Jonathan Lewis is a well-known figure in the Oracle world with more than 31 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 20 years he has specialised in short-term assignments, typically of a design, review, or trouble-shooting nature. He runs seminars about using Oracle all over the world and has visited more than 50 different countries to talk about, or trouble-shoot, Oracle systems.

Topics: "Problem Solving with Execution Plans" & "You probably don't need ... to read a 10053"

Jonathan Lewis
Independent Oracle Specialist
Franck Pachot

Franck Pachot has more than 20 years of experience in Oracle Databases, all areas from development, data modeling, performance, administration, and training. All size of customers, always around databases, mainly Oracle, trying to get developers and operations collaborating on the same goal. After many years in consulting, Franck is now DBA in the Database Group at CERN, the European Organization for Nuclear Research.

Franck likes to learn and share, writing articles, blogging in multiple places, and talking at conferences. Franck is Oracle Certified Master 11g and 12c, an Oracle ACE Director and proud member of OakTable Network. Franck has co-authored the Oracle Press “Oracle 12cR2 Multitenant”.

Topics: "Do You Gather the Statistics in the Way the Optimizer Expects Them?" & "SQL Join: methods and optimization"

Franck Pachot
Data Engineer, CERN
Tanel Poder

Tanel Poder is a long-time computer performance geek, consultant and an entrepreneur. He is working mostly with enterprise data platforms like Oracle, Hadoop, Spark and the underlying operating systems. Tanel has built a number of performance troubleshooting tools for Linux, Oracle and Hadoop and he co-founded Gluent, a company that builds data sharing solutions for enterprises.

Tanel holds two patents in data virtualization space and is a co-author of the Expert Oracle Exadata book. He blogs about performance and troubleshooting topics at blog.tanelpoder.com

Topics: "Analyzing Non-Trivial Oracle Performance Bottlenecks with ASH Wait Chain" & "Latest Oracle Troubleshooting Scripts, Tools and Technique"

Tanel Poder
Long Term Computer Performance Geek
Dani Schnider

Dani Schnider works as Senior Principal Consultant, trainer and Data Warehouse Lead Architect for Trivadis. Since 1994, he is working with Oracle Databases (version 6 to 12c), since 1997 mainly in data warehouse projects. He is co-author of the (German) books “Data Warehousing mit Oracle – Business Intelligence in der Praxis” (January 2011) and "Data Warehouse Blueprints" (September 2016). Dani is Oracle ACE and writes about Data Warehousing with Oracle on his blog danischnider.wordpress.com.

Topic: "Avoid "Horror Queries": Keep Your SQL Simple and Fast"

Dani Schnider
Senior Principal Consultant, Trivadis

Do not miss the 10th Performance Days 2020

Agenda Performance Days 2019

Time
09:00 - 10:30
10:30 - 11:00
11:00 - 12:20
12:20 - 13:30
13:30 - 14:50
14:50 - 15:20
15:20 - 16:40
16:40 - 19:00
Keynotes Sep. 26, 2019  
STAGE 1: Welcome // Avoid "Horror Queries": Keep Your SQL Simple and Fast (Dani Schnider)
STAGE 2: Welcome // Shareable Cursors (Christian Antognini)
Coffee break
STAGE 1: Controlling the Chaos – Using Resource Management for Predictable Performance (Mark Ashdown)
STAGE 2: Troubleshooting with Oracle's Kernel Debug, Diagnostics and Tracing Infrastructure (Stefan Koehler)
Lunch
STAGE 1: Problem Solving with Execution Plans (Jonathan Lewis)
STAGE 2: Latest Oracle Troubleshooting Scripts, Tools and Techniques (Tanel Poder)
Coffee break
STAGE 1: Indexing With Partitioning (Richard Foote)
STAGE 2: SQL Join: Methods and Optimization (Frank Pachot)
Let's meet over drinks
SPECIAL: All You Want to Know About Performance: Challenge the Experts (16:45 - 17:30)
Time
09:10 - 10:30
10:30 - 11:00
11:00 - 12:20
12:20 - 13:30
13:30 - 14:50
14:50 - 15:20
15:20 - 16:50
Keynotes Sep. 27, 2019  
STAGE 1: The Key Role of Infrastructure in Oracle Database Performance (Emiliano Fusaglia)
STAGE 2: Tracing Parallel Execution (Ivica Arsov)
Coffee break
STAGE 1: Do You Gather the Statistics in the Way the Optimizer Expects Them? (Franck Pachot)
STAGE 2: Deep Dive into the Implementation of Oracle's Join Methods: Past, Present and Future (Shasank Chavan)
Lunch
STAGE 1: Successful Star Schemas (Mark Ashdown)
STAGE 2: You probably don't need ... to read a 10053 (Jonathan Lewis)
Coffee break
STAGE 1: Oracle Database 18c and 19c New Indexing Related Features (Richard Foote)
STAGE 2: Analyzing Non-Trivial Oracle Performance Bottlenecks with ASH Wait Chains (Tanel Poder)
When?
  • September  26 & 27, 2019
  • 9:00 am - 5:00 pm
Where?
Holiday Inn Zürich
Messe Wallisellenstrasse 48
Zurich 8050
SWITZERLAND
More information


You will profit from a special rate if you book your hotel room with the voucher code "PDays19".

Attendance Fee
  • Conference Ticket  
    1950.- CHF .

    1930 USD* 
  • Online Live Stream Ticket
    1650.- CHF .

    1635 USD* 

Do you know Trivadis Training ?

  • Knowledge from more then 1.900 IT-Projects / Year
  • High-Class Trainings since 1994
  • Locations in Switzerland, Germany, Austria and Denmark
  • More then 120 IT-Consultants and trainer

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

Oracle-Platinum-Partner
rocket_black

The 9th "Performance Days" Convention

  • Brand new and first-hand ORACLE topics
  • From practice to practice
  • Exclusive guest-speakers
  • Communication-Platform and Networking
  • Attendance in Zurich or via Live Stream


Performance Days Ticket

You can also order your ticket obligatory by invoice.

Impressions

team_3_foto1_2x
team_1_foto1_2x
team_2_foto1_2x
team_4_foto1_2x