Skip to main content
15. November 2016
Blog

SQL Tuning Analysis for DBAs (DOAG 2016)

Performing Databases

Thanks everyone who attended my Oracle Technology session „The Bad Ones Into Your Crop – SQL Tuning Analysis for DBAs“ at DOAG Konferenz 2016 #DOAG2016. (German: „Die Schlechten ins Kröpfchen – SQL Analyse für DBAs“) – Martin Klier

The Bad One Into Your Crop - SQL Tuning Analysis for DBAs

Slides: The Bad One Into Your Crop – SQL Tuning Analysis for DBAs

Download Whitepaper (German)

Picking out, validating and improving slow or resource-eating SQL statements is part of any responsible DBA’s work who takes his/her job serious. Identification alone can be tough, but it will be even harder to improve something you have no chance to understand the purpose of. This way, you will never be in the position to improve elapsed time by factors of 1 million or 100.000 – that’s a privilege of the designers and coders. But there is a generic way for us database whisperers to approach bad-behaving SQL, and improve it by factor 2, 5 or 10. Sometimes this is all we will get, so let me show you how: We are avoiding expensive tools, voodoo features, concatenated heuristics and one-engine-fixes-the-other. An unspectacular, real-world, common-sense approach, reaching the goals with grassroots technology.

Objective 1: Understand the basic components of parsing SQL in Oracle Databases
Objective 2: Pick the culprit, understand its execution plan
Objective 3: Weed them out, avoid collateral damage.


Wir halten Sie auf dem Laufenden

Meet & Greet

our experts worldwide.

Performing Databases Blog

Download: POUG Presentation „Let the Oracle Cost-Based Optimizer Run!“
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 […]

© 2024 Performing Databases GmbH
Wiesauer Straße 27 | 95666 Mitterteich | info@performing-db.com