Menü

PyGRAZ ist eine Usergroup mit die Python-Programmiersprache in Graz. Wir treffen uns regelmässig am ersten Dienstag im Monat entweder im realraum oder im Gösserbräu.

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

Möchtest du etwas präsentieren? Dann trage deinen Vorschlag hier ein. Wenn es dann wieder auf ein neues Meetup zugeht, werden wir dich via E-Mail kontaktieren, um einen Termin auszumachen.

Vergangene Meetups