Virtual event: Do not run-away! Oracle Performance for the Uncertain
Speaker: Martin Klier
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.
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).