Presentation Title: The Answer to the Ultimate Question of SQL, Performance Tuning & Everything
Speaker: Mr Martin Bach ACE Director
Company: Accenture Enkitec Group
Co-presenter: David Kurtz - Accenture Enkitec Group

Presentation abstract: Some time ago a group of hyper-intelligent pan dimensional beings decided to finally answer the great question of SQL, Performance Tuning and Everything.

To this end they built an incredibly powerful toolset. After the great SQL script had run (a very quick seven and a half million milliseconds) the answer was announced.

The Ultimate answer to SQL, the Universe and Everything is...

(You're not going to like it...)



Which suggests that what you really need to know is 'What was the Question?'

We will talk about how we approach heath checks for our customers @ Enkitec, how we think about performance tuning, about the freely available open-source tools that we use, why we use them, and then we are going to demonstrate them (so you can use them too).

We will focus on EDB360 (whole database overview, includes SQLD360), and SQLD360 (single SQL analysis).

There is also TUNAs360 (if you don't have diagnostics pack), eAdam (to extract ASH data to flat file), PS360 (for PeopleSoft).

Presentation begins: 05/12/2017 10:00
Presentation duration: 50
Presentation content level: 2 (1 = indepth, 5 = strategic overview)
Audience experience: All Experience Levels
Audience function: Oracle, Product Expert, Product User
Speaker biography: Martin is a consultant working for @Enkitec in Europe, focusing on Oracle Engineered Systems and open source topics. In addition to the day job Martin has become a successful technical author and speaker. He specialised in the Oracle DBMS since 2001, his main interests are consolidation, HA and DR solutions for mission critical systems. Martin is a member of the Oracle Certified Master community. He is also a proud member of the Oak Table network and an Oracle Ace Director.
Related topics: Database: Performance & Internals
Hall: Hall 5