Skip to main content

Download: UKOUG Breakthrough 2022: The Price We Pay – Performance and HA with Data Guard

The downloads for the UKOUG Breakthrough 2022 talks are online here: “The Price We Pay – Performance and HA with Data Guard” by Oracle ACE Director Martin Klier and and its “Making Of” by Oracle Ace Axel vom Stein.

The Price We Pay – Performance and HA with Data Guard

Making database systems highly available is somewhat of a challenge. In the end, a whole chain of middle courses emerges, in which the interests of the end customer must be weighed conscientiously: The manufacturer makes compromises in order to provide the required functions. The planner makes compromises in order to obtain an affordable concept. The implementation makes compromises to make the system operable. And the operation makes compromises in order to survive with it in everyday life.

What does this area of tension look like in concrete terms? Complexity, costs, performance – Oracle ACE Director Martin Klier would like to shed light on these three fields in detail in his presentation, which was developed in close cooperation with Axel vom Stein. The focus will be on the problem area of system performance when using Data Guard: Which disadvantages do I buy by which HA features? How can I orient myself in this labyrinth of compromises with facts?

Making of: The Price We Pay – Performance and HA with Data Guard

Does high availability with Data Guard have a negative impact on the expected performance? Are the tensions between these two important principles of a stable environment important or negligible?

With a corresponding setup, HA expert Axel vom Stein, in cooperation with Martin Klier, got to the bottom of these questions using common performance tools and provides corresponding answers.

This presentation is not so much about the results, but about the way we got to these results. An introduction to Swingbench & ORION as well as preliminary considerations including the necessary evil of using a well-known spreadsheet tool will be included. Of course, everything is true to the motto: Don’t trust any statistics you haven’t faked yourself!

This is the “Making Of” to Martin Klier’s presentation “The Price We Pay – Performance and HA with Data Guard” about necessary trade-offs between availability and system performance in the database environment.

Project Report: Oracle OLTP Benchmarks against Dell EMC RecoverPoint

Oracle Databases on virtual infrastructure have long been part of everyday life, but storage IO there is always a source of annoyance. Especially the gap between high availability and IO performance is a challenge. The product “Dell EMC RecoverPoint” is a storage replication solution via network, which is integrated as a kernel plugin in VMware vSphere/ESXi and works for individual VMDKs or volume groups.

And you really want to run Oracle on this? And in a performant way??

Oracle ACE Director Martin Klier is technically very skeptical when in spring 2021 an end customer of TGW Logistics Group expressed this requirement – deviating from all proven standards – for a project. They had to find out how realistic a solution based on RecoverPoint is for the productive operation of a fully automated warehouse system with several thousand transactions per second. So, intensive performance benchmarks and failover tests were conducted with the customer on the planned live systems.

This presentation reports on the prehistory, the scoping, and the benchmark tests. The results and their interpretation are part of the presentation, but the focus will be on the art of benchmarking in the IOPS field, independent of the tested product.

More Noisy Neighbors and Annoying Children – Oracle Multitenant Performance II

After the very successful lecture Part I had dealt primarily with parsing, this time the focus will be on crosstalk behavior in the IO field.

The structure of Oracle Database, which many of us are also emotionally familiar with, is being fundamentally renewed. It is expected that the next generations of Oracle Database and its technologies will only be available on the basis of the “Multitenant” architecture. With version 19c, this is already optionally available in the third revision – Oracle will therefore certainly build on it for the coming versions.

So it’s high time to take a detailed look at the matter: Are there differences in performance between the “classic” and “pluggable” database concepts?

Based on conducted tests and fresh impressions from practice, OLTP specialist and Oracle ACE Director Martin Klier explains where the (no longer) new architecture requires caution from a performance point of view, where a new tenant should exactly look for Noisy Neighbors, and why the location for the playground wants to be well considered.

In addition, the presentation will provide knowledge of how performance analysis works in practice in the Multitenant environment.

Of Noisy Neighbors and Annoying Children in the Condo – Oracle Multitenant Performance I

The structure of Oracle Database, which many of us are also emotionally familiar with, is being fundamentally renewed. It is expected that the next generations of Oracle Database and its technologies will only be available on the basis of the “Multitenant” architecture. With version 19c, this is already optionally available in the third revision – Oracle will therefore certainly build on it for the coming versions.

So it’s high time to take a detailed look at the matter: Are there differences in performance between the “classic” and “pluggable” database concepts?

Based on conducted tests and fresh impressions from practice, OLTP specialist and Oracle ACE Director Martin Klier explains where the (no longer) new architecture requires caution from a performance point of view, where a new tenant should exactly look for Noisy Neighbors, and why the location for the playground wants to be well considered.

In addition, the presentation will provide knowledge of how performance analysis works in practice in the Multitenant environment.

OUG Scotland Online Conference – Slide Downloads

On June 18th, 2020 our Oracle ACE Director Martin Klier had the honour to speak two slots for the OUG Scotland Online Conference. The free download is now available.

Do not run-away! Oracle Performance for the Uncertain

Abstract

It’s eternal. Autonomous Database yes, Self-driving maybe – at the end, one of us has to put boots on the ground if there are shortcomings in real throughput or latency. In the cloud, analysis is a bit harder, on-premises has a few features less. The Oracle RDBMS is changing, but architecture, the way how it works and its limitations are still very similar on all platforms. One dilemma will stay with us: Using precious and finite resources efficiently, while valuable time passes mercilessly.

With this background, I’d like to show you in theory and practice, how Oracle uses resources. How you can analyze with Oracle’s on-board tools what currently is going on, and how you derive from that how to proceed. There is much to influence the runtime behaviour: We’ll talk about Queueing Theory, Wait Events, AWR/Statspack, ASH, Indexes, Statistics, the optimizer, software developers, users and the janitor.

Even runaways are a topic of this entertaining session: They will bite you one day, and you have to be aware!

This talk was made for experienced Administrators and DevOperators, who want to learn more about about performance analysis and its background.

Download

Here you can get the slides for free.

Sharing Experience from 24 Months of Database Upgrade and Migration

Abstract

Sharing Experience from 24 Months of Database Upgrade and Migration Running out of support, security concerns, new features, coming operating system or hardware changes…. there is a long and versatile list of potential reasons for our customers, to change the version of their running Oracle Databases. The “choice” of situations, challenges and options for changing the version, is at least as long and as versatile as the reasons are. Oracle ACE Director Martin Klier will deliver an unveiled overview about his adventures with logical dependencies, human sensitivities, technical skulduggeries and license traps. All this happens, when one or multiple databases are to be migrated or upgraded to a new version in a controlled fashion. For A as in AIX, L like Linux, S like Solaris, V like Virtualization, W twice in Windows … there was trouble, there was a solution, and there was a new experience!

Download

Here you can get the slides for free.

Utah Oracle Users Group: Webinar: Do not run-away! Oracle Performance for the Uncertain

On May29th, 2020 our Oracle ACE Director Martin Klier had the honour to speak for the UTOUG (Utah Oracle Users Group) Webinar series. The free download is now available.

Do not run-away! Oracle Performance for the Uncertain

Abstract

It’s eternal. Autonomous Database yes, Self-driving maybe – at the end, one of us has to put boots on the ground if there are shortcomings in real throughput or latency. In the cloud, analysis is a bit harder, on-premises has a few features less. The Oracle RDBMS is changing, but architecture, the way how it works and its limitations are still very similar on all platforms. One dilemma will stay with us: Using precious and finite resources efficiently, while valuable time passes mercilessly.

With this background, I’d like to show you in theory and practice, how Oracle uses resources. How you can analyze with Oracle’s on-board tools what currently is going on, and how you derive from that how to proceed. There is much to influence the runtime behaviour: We’ll talk about Queueing Theory, Wait Events, AWR/Statspack, ASH, Indexes, Statistics, the optimizer, software developers, users and the janitor.

Even runaways are a topic of this entertaining session: They will bite you one day, and you have to be aware!

This talk was made for experienced Administrators and DevOperators, who want to learn more about about performance analysis and its background.

Download

Here you can get the slides for free.

DOAG Datenbank 2020 – Oracle Alert Log

Die DOAG Datenbank 2020 fand online statt – unser Oracle ACE Director Martin Klier war mit einem Vortrag im Einsteigerstream am 26.05.2020 dabei: Das Oracle Alert Log.

Oracle what?

Die wesentliche Aufgabe eines Oracle Datenbankadministrators oder -operators ist es, in Frieden und Störfall gleichermaßen den Überblick in “seinen” Datenbankinstanzen zu gewinnen und zu behalten. Eine solche Datenbankinstanz besteht aus einer zunächst unübersichtlichen Vielzahl von Speicherbereichen und Prozessen. Bei einer durchschnittlichen 12cR1 Multitenant-Instanz ist so beispielsweise von mindestens 60 Hintergrundprozessen auszugehen. Dazu kommen noch die Server- (Vordergrund-) Prozesse, die für das Bedienen von User-Sessions notwendig sind. Diese Vielzahl von aktiven Komponenten braucht ein klares Konzept, wie Fehlermeldungen den Operator erreichen, und wie man zwischen der bloßen Signalisierung eines Vorfalls und dessen Details abgrenzt.

Daher erläutert der Vortrag, was ich schon immer über das Alert Log wissen wollte: Ein Beitrag über die verschiedenen Formate, die Inhalte, jüngere Oracle-Versionen und die Unterschiede, die sie mit sich bringen, diverse Tools zur Lesbarkeit und was uns das berühmte Logfile nicht liefert. Der Vortrag schließt einen Überblick über die berührten Komponenten im Oracle Datenbanksystem ein, damit der Zuhörer die Herkunft, Bedeutung und Relevanz von (Fehler-)Meldungen abschätzen kann. Ein Crashkurs aus der Praxis nicht nur für Einsteiger, sondern auch für alle, die sich schon einmal gewundert haben.

DOAG Konferenz und Ausstellung – Download der Präsentation

Martin Klier presenting at DOAG 2019

Danke an die vielen Zuhörer heute im Raum TOKIO des CCN Ost in Nürnberg – es hat mir sehr viel Spaß gemacht!

Zusammenfassung

Es ist ein Dauerbrenner. Self-driving hin, Autonomous Database her; einer von uns muss am Ende eingreifen, wenn es bei der erzielten tatsächlichen Leistung klemmt. In der Cloud analysiert es sich ein bisschen schwerer, On-Premises gibt es ein paar Features weniger. Das Oracle RDBMS wandelt sich, doch die Architektur, Funktionsweise und Beschränkungen des Oracle-Datenbanksystems sind auf allen Plattformen im Alltag noch sehr ähnlich. Was jedoch sicher für sehr lange Zeit gleich bleiben wird, ist ein Dilemma: Endliche Ressourcen in gnadenlos verstreichender Zeit effektiv einzusetzen. 

Vor diesem Hintergrund möchte Oracle ACE Director Martin Klier in Theorie und Praxis vorstellen, wie die Ressourcennutzung durch Oracle vor sich geht, wie man mit den Mitteln der Oracle Instanz analysiert was passiert, und wie man davon konkrete Schritte ableitet. Vieles beeinflusst das Laufzeitverhalten: Dazu sprechen wir unter anderem über die Queueing Theorie, Wait Events, AWR/Statspack, ASH, Indexes, Statistiken, den Optimizer, Software-Entwickler, User und den Hausmeister.

Auch Ausreißer sind ein Thema dieser unterhaltsamen Session, gemeint ist jedoch zunächst eine von ostfriesischem Humor geprägte Falschübersetzung: Der Vortrag wendet sich an fortgeschrittene Administratoren und DevOperatoren, die mehr über die Performanceanalyse und deren technologischen Hintergrund in Theorie und Praxis erfahren möchten.

Download

COLLABORATE 19 is a wrap – download presentations

It was awesome again – meeting so many people related to Oracle in USA. This year, COLLABORATE 19 (#C19TX) took place in San Antonio, Texas. For me the first time not in Las Vegas, it was a nice change.

Again, I was honoured with two presentation slots about Oracle Database technology. “Oracle Core – Database I/O” and “YOUR machine and MY database – a performing relationship!?”

If you are interested in my presentations, feel free to download them here. Thank you everybody who attended!
Martin Klier





OBUG TechDays Belgium 2019

The TechDays Belgium 2019 were a great success – so many cool and nice people, and very interesting content. I’d like to say Thank You to the attendees, speakers and organisers – I’ll love to be back in 2020 if possible.

Here is the download link for my presentation “Performance is Rarely an Accident” in English.


And here we have some pictures from the event …


We will keep you up to date

Meet & Greet

our experts worldwide.

Performing Databases Blog

Download: UKOUG Breakthrough 2022: The Price We Pay – Performance and HA with Data Guard
The downloads for the UKOUG Breakthrough 2022 talks are online here: “The Price We Pay – Performance and HA with Data Guard” by Oracle ACE Director Martin Klier and and […]
© 2023 Performing Databases GmbH
Wiesauer Straße 27 | 95666 Mitterteich | info@performing-db.com