Nächstes Treffen am 6. November 2018 um 19:00 Uhr

Hall Leute!

Diesmal gibt es einen Vortrag von Rainer Schuettengruber zum Thema "Beating Oracle's Optimizer at its own game".

..und natürlich wie immer zwanglose Gespräch rund um Python!

Schau vorbei!

Geplante Sessions

Beating Oracle's Optimizer at its own game

von Rainer Schuettengruber

Since the Cost Based Optimizer has been introduced in Oracle 7 it has undergone constant improvements with each version. Given the maturity it has reached in version 12.2, the manual effort put into tackling CBO issues has been reduced significantly. However, especially in complex applications, there a still issues that require manual intervention by a seasoned DBA. In this talk I will outline a solution that addresses instable execution plans. After introducing the matter with a general overview of the mechanics behind it, I will explain the factors that led to the faced instability in detail. Since the affected application needs to be available 24x7 there was an urgent need for an automated approach that deals with the issue. This has led to a Python based machine learning solution, capable of alleviating the issue autonomously. After a discussion of detecting runtime anomalies by means of statistical methods, I will present relevant implementation details along with the used Python libraries. Generally spoken, the talk will introduce the building blocks for a self-healing service amongst covering the rationale behind it. Apart from unravelling the alleged buzz word machine learning, I will show that implementing such a solution is astonishingly easy, thereby giving participants a tool set at hand that contributes to automating complex tasks.

Falls du vorhast, zu kommen, bitte trage dich auf Meetup.com ein! Es ist nicht zwingend erforderlich, macht aber unsere Arbeit leichter, wenn wir abschätzen können, wie viele Leute in etwa kommen.

Location: Realraum

Brockmanngasse 15, 8010 Graz

Session-Ideen

Titel	Vortragender
Python instead of shell scripts	Thomas Aglassinger
Komunikationsbausteine für Entwickler	Thomas Aglassinger
typing	Lukas Prokop
Gesetzestexte richtig lesen	Stefan Koch
wtfpython	Lukas Prokop
Python beyond 3.3	Lukas Prokop
Anki	Lukas Prokop
The python data model	Lukas Prokop
The Missing Filesystem Path Type	Christoph Reiter
Aufwandsschätzungen mit Jupyter	Sebastian Kübeck
TensorFlow	Lukas Prokop

Deine Session-Idee