The notorious #POUG2024 conference is a wrap! I loved being there, enjoying the people, the knowledge and the atmosphere! Sometimes I am thinking it might be the last pure-technology conference left…
Here you can download my presentation pdf:
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.
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.
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.
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?
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.
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.
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.
Here you can get the slides for free.
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!
Here you can get the slides for free.
After talking at DOAG Conference 2018 and IT Tage Frankfurt 2018, the slides for the sessions are available now. Download presentation “Martin Klier – Oracle Core: Database I/O” now, and let me know if there are any questions, any time!
We know different IO types that are used by the database. The DB needs them to fulfill its tasks. This lecture shows how and where they are different, and explains the advantanges and disadvantages of each. We will talk about access to tablespaces, online/archived redo logs and different file types connected to the instance.
I’ll include a quick review on the respective functions in the RDBMS, and we will also have a quick look into Oracle’s Automagic(?) Storage Management ASM.
I’d like to promote understanding of mass storage operations in the modern world, and transfer knowledge for a competent storage sizing.
In April 2018 at COLLABORATE18 in Las Vegas, our newly-promoted Oracle ACE Director Martin Klier had two sessions in the IOUG forum.
Both presentations are available for download now:
Full Throttle: Oracle SQL Tuning & the Ressource Consumption Approach
The (Un)loved Child of Generation Cloud: Oracle Performance on VMware
We hope you can extract useful information for you. For questions, just get in touch!
Wir haben unsere Präsentationen DOAG Konferenz und IT Tage Frankfurt 2017 online!
Download: The (un)loved Child of Generation Cloud: Oracle on VMware
Download: YOUR machine and MY database – a Performing Relationship!?
Download: Full Throttle: Oracle SQL Tuning & the Ressource Consumption Approach
Thanks to everybody who attended the 9th Software Performance Meetup!
That’s the slides to “Performance is rarely an accident” as delivered by Martin Klier on September 27th 2016 in Munich.
Download here
About the lecture:
The intention is, to show development teams, administrators and analysts, how beneficial it would be to think about performance at all, and that you’d need code instrumentation (=runtime meta information about application behavior) to get better. Martin will go from general Excellence over costs and implication of changes to the real craftsmanship of performance analysis.