Trivadis will host the 13th Performance Days conference with top guest speakers in Zurich. As in the previous years the focus will be 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.
More info
The working day will be from 9am to 5pm; and on the evening of first day there will be 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 5pm to 7pm.
Join us either live in Zurich or attend the sessions online in our virtual classroom. All sessions will be available as live stream for you. Requirements: access to the internet and headset. You will receive your personal account prior to the event. The account is valid for one person.
.
.
Attendance Fee
On site ticket Regular: 1'995 CHF/EUR Early bird until 28.06.2022: 1'595 CHF/EUR
Online ticket Regular: 1'395 CHF/EUR Early bird until 28.06.2022: 1'095 CHF/EUR
The Early-Bird price can not be combined with other discounts/special conditions.
The prices indicated are exclusive VAT.
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 will cover topics such as:
How to tackle performance problems – fundamental questions to address, approaches and tools
The importance of database design for best performance
Which techniques are used by Oracle to automate performance management for indexes, materialized views, table partitioning and zone maps
How to delete (or archive) lot of data – strategies, common mistakes and nasty surprises
Troubleshooting disk I/O performance issues without guessing
SQL Plan Management – myths, legends and facts
Are there differences in performance between the "classic" and "pluggable" database architecture
How automatic indexing works and which improvements and new capabilities were recently introduced
New performance-related features that will be available in Oracle Database 23c
Target Audience and Requirements
Target audiences 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.
Your speakers
Nigel Bayliss
Senior Principal Product Manager (Optimizer), Oracle Corporation
Nigel is the product manager for the Oracle Optimizer. He began as an application developer and Oracle DBA in 1988 and became interested in database design and performance management. After joining Oracle Consulting in 1996, he specialized in delivering performance-critical and very large database applications. He has had various roles in Oracle, including consulting, benchmarking, pre-sales, and development, and has been a member of the Data Warehousing Product Management team since 2014.
Jonathan Lewis is a well-known figure in the Oracle world with more than 34 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 23 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.
Based in Canberra, Australia, Richard has been working in the IT industry for 35+ years, 25+ years with Oracle databases. He's been responsible for many large scale, mission critical Oracle systems, tuning many databases often with 10x performance improvements. In 2002, he became a member of the Oracle OakTable Network and in 2008 an Oracle ACE Director (and again in 2018). Richard regularly presents at conferences including Oracle OpenWorld, IOUG Collaborate, Hotsos Symposium, AUSOUG Connect, ODTUG Kscope, UKOUG Conference & Trivadis Performance Days. In 2018, Richard was awarded "Lifetime Speaker" award by UKOUG and one of the first "Oracle Masters" by AUSOUG. He is renowned for his research and knowledge of Oracle indexing structures, hosts an acclaimed blog and has developed in-depth seminars on Oracle Index Internals and Database Performance Tuning which he has presented in over a dozen countries. In 2017, Richard started his own consulting company in which he globally presents his highly acclaimed seminars and assists customers with diagnosing and resolving Oracle database performance issues.
Stefan Koehler follows his passion about Oracle since more than 21 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 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.
Vice President of Development (In-Memory Data Technologies), Oracle Corporation
Shasank Chavan is the Vice President of the Data and 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 Oracle's next-generation, highly distributed, 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 30+ patents over a span of 23 years working on systems software technology.
His talk at Performance Days 2022
Roger Cornejo
Technology Innovation Senior Principal, Accenture Enkitec Group
Oracle ACE, Roger Cornejo has over 36 years’ experience with large/complex Oracle applications (versions 4.1.4 – 19c) in roles such as Developer, Tech Lead, Enterprise Architect, Database Architect and project manager. Roger has a strong background in DB performance analysis and tuning, and for the past 11 years, diving deep into AWR tuning data. As a thought leader, he has been sought out for his expertise in tuning (presenter at the past 11 East Coast Oracle Conferences, as well as INSYNC21, OOW19, COLLABORATE14 and COLLABORATE18, RMOUG16, and Hotsos 2017-2018). Additionally, Roger authored a book on his recent work, Dynamic Oracle Performance Analytics: Using Normalized Metrics to Improve Database Speed, the book is available through Amazon and Apress.
Being in IT business as a specialist for Linux, Martin Klier has been involved in the administration of Oracle Databases for about fifteen years now. The integration of large Oracle-based high-availability solutions (MAA) with RAC and Data Guard were the first challenges. In the last years, he largely moved into performance analysis and tuning of complex systems with dynamically changing load profiles. Skeptical needs assessments, thorough architecture planning, decent system sizing, critical benchmarking and experienced load-focused system analysis are Martin’s formula to success in avoiding production downtime.
For years now, Martin can be found speaking on topics regarding “Oracle Core, Performance and High Availability” on various national and international conferences, like COLLABROATE (IOUG), Oracle Open World or DOAG Konferenz. Martin frequently blogs about recent issues and their solutions at http://www.usn-it.de and is known on Twitter as @MartinKlierDBA. Martin works a lot for the community, especially for the German Oracle Users Group “DOAG” and Linux User Group Mitterteich, and is an Oracle ACE Director (Database).
Martin is in direct and constant contact with Oracle databases since 2000 - always with a great desire to understand complex technical aspects.
Even though his history was most infrastructure centric, when it comes to applications his focus is on the user and its specific experience. This forces him to a holistic approach without blingers - whatever the specific goal might be.
His second area of interest is capacity measurement, prediction and planning - and the hunt for bottlenecks.
The main tools in these processes are a stopwatch, pen and notebook - even often only figuratively.
Martin documents his findings on his blog, is an Oracle ACE since 2017 and presents his experience on various conferences.
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 is 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.
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).
Walter Dorigo is a Master Principal Technology Engineer in the Technical Solution Engineering Organization based in Switzerland. He has worked with Oracle for 29 years and in different roles from consultancy to product management in a technical capacity to promote different Oracle products to customers and partners by delivering designing workshops, presentations and architecting complex system environments.
Robert Pastijn is a distinguished product manager in the Oracle Database Product Development team. He has worked with Oracle for 28 years and for Oracle for 23 years in a technical capacity to promote the Oracle database to customers and partners by writing/delivering workshops, presentations, solving architecture issues and inventing new tools like Oracle LiveLabs. Robert usually travels in Europe, Middle East and Africa to transfer his knowledge but will be available remotely this time).
His talk at Performance Days 2022
Agenda
Day 1, September 28
09:00-09:10
STAGE 1: Welcome
09:10-10:30
STAGE 1: Jonathan Lewis
10:30-11:00
☕ Break
11:00-12:20
STAGE 1: Walter Dorigo and Robert Pastijn | STAGE 2: Richard Foote
12:20-13:30
? Break
13:30-14:50
STAGE 1: Nigel Bayliss | STAGE 2: Stefan Koehler
14:50-15:20
☕ Break
15:20-16:40
STAGE 1: Martin Berger & Dani Schnider
16:40-18:00
? Q&A Session
Day 2, September 29
09:10-10:30
STAGE 1: Nigel Bayliss
10:30-11:00
☕ Break
11:00-12:20
STAGE 1: Martin Klier | STAGE 2: Roger Cornejo
12:20-13:30
? Break
13:30-14:50
STAGE 1: Jonathan Lewis | STAGE 2: Christian Antognini
