Performance Days 2019

Früh Buchen lohnt sich -
Sichern Sie sich Ihr Ticket zum Early-Bird Preis!*

TREFFEN SIE INTERNATIONAL HERAUSRAGENDE ORACLE PERFORMANCE-SPEZIALISTEN UND PROFITIEREN SIE VOM KNOW-HOW-TRANSFER

Trivadis freut sich sehr, ein weiteres herausragendes Seminar mit hochkarätigen Referenten in Zürich zu veranstalten. Der Schwerpunkt liegt in diesem Jahr auf der Performance von Oracle Datenbanken und der Optimierung von Abfragen.
Da Performance nicht einfach ein Produkt ist, das man kaufen kann, sondern eher das Ergebnis einer genauen Planung und korrekten Implementierung, präsentiert das Seminar wertvolle Techniken zur Behebung von Performance-Problemen und wie diese in erster Linie vermieden werden können.

INHALT
Die Teilnehmer haben die freie Wahl zwischen zwei parallel angebotenen Vortragsreihen. Die Performance Days bieten wertvolle und praktische Informationen zu Diagnose, Lösung und Vermeidung von Performance-Problemen bei Applikationen mit der Oracle Datenbank. Die Referenten werden unter anderem die folgenden Themen behandeln:

  • Neueingeführte Indexierungs- und Partitionierungsfunktionen in Oracle Database 18c und 19c
  • Warum es von größter Bedeutung ist, Ihre SQL-Anweisungen einfach zu halten.
  • Die Rolle der Infrastruktur bei der Performance von Oracle Datenbanken
  • Verwendung des Ressourcenmanagements zur Bereitstellung einer vorhersagbaren Performance.
  • Nutzung von Ausführungsplänen zur Problemlösung
  • Detaillierter Einblick in die Art und Weise, wie die Oracle Datenbank Joins und Sternabfragen verarbeitet.
  • Nutzung der Kernel-Debugging-, Diagnose- und Tracing-Infrastruktur von Oracle sowie ASH zur Fehlerbehebung
  • Warum Sie wahrscheinlich keine 10053-Trace-Datei lesen müssen.
  • Wie Sie Objektstatistiken sammeln
  • Verfolgung paralleler Ausführungen, zum besseren Verständnis der Funktionsweise
  • Was Parent und Child Cursor sowie Adaptive Cursor Sharing und Statistics Feedback sind

TVDPDAYS

Dauer

2 Tage

Inhalt

DIE SESSIONS

Oracle is a complex coordinated multi-process system with layers of background processes potentially on the critical path of your application’s operations. When everything works well, you won’t notice much wasted time or surprising wait events. However, when some critical background process starts falling behind enough, all kinds of problems will start popping up. Due to impact amplification on many foreground sessions, the top-level symptoms showing up in AWR and OEM may mislead you to troubleshoot the wrong thing. When following the links of evidence all the way to the deepest process in the (wait) chain, you can construct the topology of a complex performance issue and address the root cause. In this session you’ll see multiple troubleshooting case studies using ASH wait chain analysis, where the typical tools would have left the customer fixing the wrong problem.

Avoid "Horror Queries": Keep Your SQL Simple and Fast (Dani Schnider)

SQL is a powerful and efficient query language when used correctly. But inefficient and inappropriate SQL statements can cause massive performance problems. Instead of solving such issues with additional indexes, optimizer hints, SQL profiles or SQL plan baselines, a much better and more sustainable solution is often to rewrite the SQL statements and to reduce the complexity of the queries. In this presentation, some real-life examples of terrible "horror queries" will be shown and rewritten into simpler, more elegant and faster SQL statements. The goal of the presentation is to show how to improve the performance of a query by factors with appropriate SQL statements and powerful Oracle SQL features.
With todays’ machines it is usually necessary to run multiple applications or roles on a single machine. This brings up the question of how you can ensure that the performance of the applications can be set up to be reliable and predictable especially when combining OLTP and DW type activity. This paper explores the options available with presentation and live demos to show how virtualization, instance caging, resource manager and multitenant can be used to deliver the required performance.

Deep Dive into the Implementation of Oracle's Join Methods: Past, Present and Future (Shasank Chavan)

Join processing in relational databases involves combining the output of two row sources (e.g. tables) into one result row source.  Most SQL analytic workloads are dominated by time spent in join processing because of the nature of the operation being heavily compute and bandwidth intensive.  Oracle has developed numerous traditional join methods over the years (e.g. nested loop, sort merge, hash join, etc.).  Some of these methods have fallen out of favor over time by the optimizer (i.e. past), others are time-tested and commonly selected by the optimizer to this day (present), and then there's a new class of join algorithms which leverage the latest In-Memory Columnar data formats to deliver the fastest join evaluation known in industry (future).  This talk will dive into the technical implementation details of Oracle's plurality of join methods (including specialized ones such as vector transformation which optimizes aggregations over joins), give insight into why the optimizer may choose one method over the other, and what the SQL and storage engines are actually doing under the hood to implement the join.
You can't blame the optimizer unless you are sure you feed it with relevant statistics. There is the Auto Job which suits lots of cases, and there are some exceptions: volatile tables, partitioned tables, bulk load, histograms and bind variables, etc. You cannot gather all possible statistics every day, and you cannot rely on stale ones. Let's define a few rules, guided by the recent features: 12c Statistics Advisor and 19c real-time statistics.
As databases get ever larger in size and complexity and with the Oracle Partitioning Option becoming more accessible, especially within Oracle Cloud deployments, the Oracle Partitioning option has become more common and a more important feature in Oracle database deployments. This presentation will look at some of the important indexing strategies that can be applied in a Partitioned Database environment in order to effectively maximise both database/application performance and database management practices, dispelling some common myths along the way. With prudent partitioning practices, it’s possible to achieve performance levels that aren’t practical without partitioning being applied. It will also discuss some newer features introduced in 12c R2 and 18c that simplifies the migration to an effective partitioning strategy.
This session will give you a “quick overview” of the variety of the latest (open source) tools that Tanel regularly uses when looking into Oracle performance problems. The presentation will have 3 parts: First, updates to tools like Oracle Session Snapper v5 and LatchProfX. Second, SQL Tuning helper scripts like an extended execution plan display and visualization tool. The last section will introduce a new Linux tool called Process Snapper that can sample any process activity at Linux OS level similarly to Snapper for Oracle.

Oracle Database 18c and 19c New Indexing Related Features (Richard Foote)

The latest Oracle 18c and 19c Database releases have included a number of new indexing related features that help to maximise database and related application performance. This session will cover in some detail at some of these new features and capabilities, how they work and how they can be utilised to successfully improve performance. Some of the features to be discussed include the Memoptized Rowstore, Scalable Sequences, Index/Partitioning Enhancements, JSON Search Index enhancements and one of the big 19c features, Automatic Indexing. With regard Automatic Indexing, not only do we look at how it all works, but also what useful things we can learn regarding manual index management.
This session will examine a couple of execution plans that have appeared on the Oracle Developer Community database over the last year, explaining what information can be seen from the initial request for assistance, what further information might be needed, and what database considerations might come into play that are outside the immediate scope of the information available in a plan. There will be no Powerpoint slides in this presentation as the medium is not appropriate for displaying plans of a "real-world" level of complexity.
The result of a parse operation is a parent cursor and a child cursor stored in the library cache. Obviously, the aim of storing them in a shared memory area is to allow their reutilization and thereby avoid hard parses. But when can they be reused? The aim of this presentation is not only to discuss what parent and child cursors are but also, and foremost, to examine in what situations it is possible to reuse them. In doing so, topics such as bind variable peeking, bind variable graduation, adaptive cursor sharing and statistics feedback will be covered as well.
An important SQL basics: join methods. The approach is live demo showing Nested Loop, Hash, Sort, Merge, with gdb breakpoints on the Oracle executable in order to see how they are processed, in slow motion. When you understand how it works, you know exactly which join method is good for your query. We will also show some internals of one of the most advanced technique of the optimizer: 12c Adaptive Plans. Additional optimization for joins will be covered: table elimination, partition-wise join.

Successful Star Schemas (Mark Ashdown)

 Star schemas and star queries have a strong track record in delivering valuable business information from relational data . The standardised structure of the schema is well-supported by business intelligence and reporting tools from Oracle and numerous other well-known vendors. It has also encouraged many optimisations in the algorithms used by Oracle Database, with new capabilities being introduced to take advantage of the latest developments in hardware. Join this session with Oracle's Real-World Performance Group to learn some simple rules that help to ensure success through consistent and efficient execution of star queries, together with a live demonstration of the trade-offs between different technologies.
The aim of this presentation is to focus on the key role played by the infrastructure in a stable and performing database environment.
Like a skyscraper, a database environment requires a strong foundation. In addition, to fully exploit all available resources, a great synergy among all hardware and software layers is of paramount importance. This presentation covers different architectures and configurations. For each of them, it highlights the expected performance benefits.
This is an opportunity to extend your know-how in diagnosing parallel execution and learn how to analyze PX trace files. PX tracing can be used to get detailed information about operations performed by the coordinator and its parallel execution slaves. We'll look under the covers of parallel execution to better understand how it works. You’ll learn how PX processes communicate, answer questions like “Why are PX slaves not being allocated” or “Why does my statement not execute in parallel?”.
The Oracle RDBMS has implemented three APIs (generic debug, generic trace, numeric events) in its low-level kernel debug, diagnostics and tracing infrastructure since version 11g. This session provides an overview of these three APIs, how to get more information about its tracing possibilities/syntax and how to use/set them. In the end some real life client issues that were troubleshot with help of these three APIs are discussed. You should be able to define and set your own custom actions/events for ORA errors and/or for specific C functions and/or for troubleshooting performance issues after this session.

It's almost true to say that the only time you should read a 10053 trace file is when you don't need to. It's also probably a fairly accurate claim that the only good reason for reading a 10053 trace file is to prove that you didn't need to read the 10053 trace file. In all my years of consulting and trouble-shooting I think I've only used the 10053 trace file a couple of times to demonstrate the cause of a performance issue and suggest a work-around - but having spent a silly amount of time generating and reviewing trace files for increasingly complicated statements I found it easy to pick the bit of the trace file I needed to examine to confirm a hypothesis and explain the evidence to management (and Oracle Support). In this session I'll be giving you plenty of reasons why you shouldn't be reading a 10053 trace file - but we'll probably end up looking at some bits of one anyway.

GEPLANTER TERMIN

26.-27. September 2019
Die Veranstaltung dauert von 9.00 Uhr bis 17.00 Uhr. Am Abend des 26. Septembers haben Sie in ungezwungener Atmosphäre und bei einem Getränk von 17.00 Uhr bis 19.00 Uhr die Gelegenheit zu einem Erfahrungs- und Meinungsaustausch mit den Referenten und anderen Teilnehmern.

SPRACHE

Dieses Seminar wird in englischer Sprache gehalten.

ZIELGRUPPE UND VORKENNTNISSE

Die Zielgruppe dieser Veranstaltung sind Performance Analysten, Datenbank-Administratoren, Anwendungs-Entwickler und Berater, die ihre Kenntnisse im Performance-Management und bei der Entwicklung von Datenbank-gestützten Anwendungen mithilfe der Oracle Datenbank verbessern wollen.
Die Teilnehmer sollten über praktische Kenntnisse der Oracle Datenbank verfügen.

LIVE ODER ONLINE

Kommen Sie entweder zu unserer Live-Veranstaltung in Zürich oder nehmen Sie an den Sitzungen in unserem virtuellen Klassenzimmer teil. Alle Sitzungen stehen Ihnen als Live-Stream zur Verfügung. Voraussetzungen: Internetzugang und Kopfhörer. Sie erhalten Ihr persönliches Konto vor der Veranstaltung. Das Konto gilt für eine Person.

Spezialangebot

Conference Ticket: 1,950 CHF

Preis für den 2. Teilnehmer Ihres Unternehmens - 1463 CHF
Preis für den 3. Teilnehmer Ihres Unternehmens - 975 CHF
Preis für den 4. und jeden weiteren Teilnehmer Ihres Unternehmens - 488 CHF

Online Ticket: 1,650 CHF
Preis für den 2. Teilnehmer Ihres Unternehmens - 1238 CHF
Preis für den 3. Teilnehmer Ihres Unternehmens - 825 CHF
Preis für den 4. und jeden weiteren Teilnehmer Ihres Unternehmens - 413 CHF

VERANSTALTUNGSORT

Die Veranstaltung findet im Holiday Inn Zürich-Messe, Schweiz, statt.
www.ihg.com/holidayinn/hotels/de/de/zurich/zrhme/hoteldetail/directions

PREIS

Live im Holiday Inn, Zürich-Messe, Schweiz: CHF 1.950 / .2083 USD
EARLY-BIRD SPECIAL:  CHF 1.650 / .1770 USD *
Im Preis sind Mittagessen und Erfrischungen in den Pausen enthalten.

Live-Stream: CHF 1.650 / .1763 USD
EARLY-BIRD SPECIAL:  CHF 1.400 / .1500 USD *
Der Live-Stream wird aufgezeichnet. Im Preis enthalten ist Ihr exklusiver Zugang zu den Aufzeichnungen.

* Nur gültig für Buchungen bis zum 17.05.2019. Early-Bird Aktion nicht mit anderen Aktionen kombinierbar.

Unser Qualitätsversprechen

Kontakt zu unserem Service Center

DE+49 (0) 711 90363245

CH+41 (0) 584 595795

AT+43 (0) 133 2353160

FR+41 (0) 584 595454

EN+49 (0) 711 90363245

DA+49 (0) 711 90363245

emailTraining@trivadis.com

OrtTerminSprachePreis 
Virtual Classroom
26.09. - 27.09.2019
EN1'400.00 CHF
Zürich / CH
26.09. - 27.09.2019
EN1'650.00 CHF
  •    Standard
  •    Garantierte Durchführung
  •    Mit Ihrer Buchung findet der Kurs garantiert statt
  •    Dieser Kurs ist ausgebucht. Mit Ihrer Buchung werden Sie auf die Warteliste gesetzt.

  • Aufgrund der verschiedenen Mehrwertsteuersätzen der unterschiedlichen Länder können wir im Shop nur Bestellungen derselben Währung verarbeiten. Bitte legen Sie nur Trainings derselben Währung in den Warenkorb und führen Sie ggf. mehrere Bestellungen aus. Herzlichen Dank für Ihr Verständnis. – Gerne stehen wir Ihnen bei der Bestellung auch telefonisch zur Verfügung: +49 89 9927 5931.

    Unser Angebot richtet sich an gewerbliche Kunden. Die Preise sind als Nettopreis ohne MwSt. angegeben.

Ausgezeichnet und geprüft

Zurück zu Trainings
0 Artikel im Warenkorb
Trivadis, Bernd Rössler, Head of Training

Bernd Rössler

  • Solution Manager Trivadis Training
  • DE: +49 (0) 711 90363245
    CH: +41 (0) 584 595795
    AT: +43 (0) 133 2353160
    FR: +41 (0) 584 595454
    EN: +49 (0) 711 90363245
    DA: +49 (0) 711 90363245

    E-Mail: Training@trivadis.com

    „Gerne beraten wir Sie auch zu Themen wie: Einzelcoachings, Workshops, Projektbegleitung und Online-Trainings.“

    Ihr Bernd Rössler

Jetzt Beratungstermin zu Trainings vereinbaren

In order for us to be able to inform you by telephone or e-mail about Trivadis offers and products in the future, we require your consent. Your consent is voluntary and you can revoke it at any time without giving reasons informally by telephone, in writing or by e-mail at info@trivadis.com. We might forward your personal data to a call centre so that we can contact you and inform you about Trivadis products and offers.

trivadis training zufriedenheitsgarantie

Zufriedenheits- & Qualitätsgarantie

Jedes einzelne Training wird bei Abschluss durch die Teilnehmer auf den Ebenen:

  • Eignung des Schulungsraumes
  • Eignung des Arbeitsplatzes
  • Funktionsfähigkeit der technischen Ausrüstung
  • Zufriedenheit über den gesamten Kurs / das gesamte Seminar

in unserem Feedbacksystem „TRIVALUATION“ zur Qualitätssicherung erhoben. So stellen wir die hohe Qualität und Zufriedenheit unserer geschätzten Kunden permanent sicher. Wir freuen uns über die Gesamtbewertung von 9,3 von 10 Punkten durch unsere zahlreichen begeisterten Kunden.

 

trivadis training erfolgsgarantie

Erfolgsgarantie

Trivadis garantiert den Erfolg Ihres Trainings. Nach Ihrem Training sind in der Praxis noch weitere Fragen aufgetaucht? Sie möchten einzelne Übungen noch einmal in der Lab-Umgebung wiederholen?

Unsere Erfolgsgarantie gibt Ihnen bis zu 6 Monate nach dem Besuch eines Trainings die Möglichkeit zur kostenlosen Wiederholung einzelner Tage oder des gesamten Trainings. Die Kursunterlagen bringen Sie vom vorherigen Training selbst mit.