This website uses cookies to store information on your computer. Some of these cookies are used for visitor analysis, others are essential to making our site function properly and improve the user experience. By using this site, you consent to the placement of these cookies. Click Accept to consent and dismiss this message or Deny to leave this website. Read our Privacy Statement for more.
18th June Martin Klier

Do not run-away! Oracle Performance for the Uncertain


Martin Klier, Performing Databases GmbH


 

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 whant to learn more about about performance analysis and its background.

Speaker Biography

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).