Zum Hauptinhalt springen

Schlagwort: Database

Download: UTOUG Training Days 2025 Presentations

Geschrieben von Martin Klier am . Veröffentlicht in Downloads.

One of the highlights in early spring is UTOUG Training Days – the on-site event of the Utah Oracle User Group in Salt Lake City, UT, USA. As in the years before, Oracle ACE Director Martin Klier was there in March 2025 too, to give talks and to be part of panels.

Pictures

Presentation „Gateway to Hell – Network Basics for DBAs, DEVs and DevOps“

New environments are increasingly based on a software-defined data center, both on-premises and in the cloud. However, more conventional approaches also require database administrators or DevOps teams to understand and handle the network stack. Knowledge of this basic technology is more relevant today than ever before – even if, at its core, it is mostly a creation of the 1980s and 90s.
With a twinkle in our eye, we answer the following questions, among others:

  • What’s so great about the Classless Society?
  • What does a salami pizza have to do with network technology?
  • If Superman likes supernetting, who does subnetting?
  • How do nuclear weapons affect network design?
  • If my routes come from the GPS, what do I need a router for?
  • Who has DNS in their DNA?

We would like to invite all DBAs, developers and DevOperators to rediscover the basics of network technology with us. Everything seen through the practical eyes of experienced, strictly practice-oriented database experts. The lecture is therefore aimed at experienced IT professionals who (only) have little to do with network technology in their day-to-day work and would like to widen their view.

Klier_Schampera-Gateway-to-HellDownload

Presentation „Hard Road to Hardening: CIS Benchmarks and Linux Security for Beginners“

This is our project report about hardening project systems running Linux as a backend for the Oracle Database. Being long-time Linux and Oracle professionals, out of the blue we found ourselves tasked with a strangely nontechnical technical issue. Despite all experience, we were bewildered by all that was to learn in the security domain, to put it mildly!

This is a story of criminal threats, self-imposed limitations, calculated risks, hidden dangers, familiar habits, external pressures, real-world challenges, practical applications, performance, overhead, tools, and the big question: Who will maintain this?

Join us, as we explore the journey towards enhanced security — and the trade-offs that come with it.

Klier-VomStein-CIS-HardeningDownload

Download: Oracle Cloud World 2024 Presentation „Simple AI Use-Cases“

Geschrieben von Martin Klier am . Veröffentlicht in Downloads.

Oracle Cloud World Las Vegas was an amazing event, with an international audience and so many famous and/or interested faces. Oracle ACE Director Martin Klier presented a talk about using Artificial Intelligence (AI) in a very simple way in the daily life of an Oracle Database Administrator (DBA) or DevOps team.

Pictures

From Formula 1 to Airpower at Nellis AFB, Las Vegas is pure show. And we got a tiny piece of the glamour to present some cool tech news that can really help you with your work.

Martin Klier: Simple AI Usecases for the Oracle Database Professional

Klier_AI-UsecasesDownload

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

Geschrieben von Martin Klier am . Veröffentlicht in Downloads.

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?

Klier-Dataguard-Performance-2022Herunterladen

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.

Making-Of-The-Price-We-Pay-Performance-with-HA-and-Data-GuardHerunterladen

OUG Scotland Online Conference – Slide Downloads

Geschrieben von Martin Klier am . Veröffentlicht in 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.

Klier-Do-not-run-away-Oracle-Performance-for-the-UncertainDownload

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.

Klier-Experience-from-24-Months-of-Database-Upgrade-and-MigrationHerunterladen

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

Geschrieben von Martin Klier am . Veröffentlicht in Downloads.

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.

Klier-Do-not-run-away-Oracle-Performance-for-the-UncertainDownload

DOAG Konferenz und Ausstellung – Download der Präsentation

Geschrieben von Martin Klier am . Veröffentlicht in Downloads.

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

Klier-NichtWeglaufen-Oracle-Performance-Runaways.pdfHerunterladen

Oracle Magazine Featuring Martin Klier

Geschrieben von Performing Databases am . Veröffentlicht in News.

The Oracle Magazine featured our co-founder, Senior DBA Consultant and Oracle ACE Martin Klier in its „peer-to-peer“ column of the January/February 2016 issue.

Martin Klier Oracle Magazine 2016

Introducing Martin along with two other renowned technicians – Alex Zaballa and Gustavo Gonzalez – the feature was titled „Firsts and Favorites – Three peers who started early, stayed loyal, and stuck to tech basics“. Martin pointed out, how Oracle Core Technologies forms his daily life, and that Oracle Real Application Clusters (Oracle RAC) was his first love in the Oracle world. It’s easy to understand why – RAC is a highly scalable, sophisticated and reliable business continuity and high availability solution. Implemented into the database core, it provides a scale-out capacity that’s still unique in the market, even after so many years of modern RAC architecture.

See more about Martin Klier on our Team Page or on his personal blog.

Wir halten Sie auf dem Laufenden

Meet & Greet

our experts worldwide.

Events

Performing Databases Blog

Download: UTOUG Training Days 2025 Presentations
One of the highlights in early spring is UTOUG Training Days – the on-site event of the Utah Oracle User Group in Salt Lake City, UT, USA. As in the […]
Blog

Kompetenzen
Unternehmen
Referenzen
Blog

Events
Karriere

Kontakt
Impressum
Datenschutzerklärung
Allgemeine Auftragsbedingungen

© 2024 Performing Databases GmbH
Wiesauer Straße 27 | 95666 Mitterteich | info@performing-db.com