Performing Databases at COLLABORATE16 Las Vegas

From April 10th to April 14th 2016 one of the best and biggest Oracle community events of the year takes place, and we are proud to be there: Performing Databases at COLLABORATE16 in Las Vegas, with lectures and community work.

Performing Databases at COLLABORATE16 Las Vegas

Lectures

The Bad One In Your Crop – SQL Tuning Analysis For DBAs

Martin Klier, Senior DBA Consultant

4:30 PM–5:30 PM Apr 11, 2016 (Session #4262)

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.

Oracle Core: 12c InMemory Column Store

Martin Klier, Senior DBA Consultant

3:30 PM–4:30 PM Apr 12, 2016 (Session #4927)

The new In-Memory-Option of the Oracle Database is widely talked about. But how do the In-Memory components of the database really work? Is In-Memory really so transparent as we are told? And why/why not?

This lecture has its focus on “the idea behind” and is intended to be understandable for less experienced or part-time DBAs.

Learn, why using In-Memory Column Store is more or less beneficial for various access paths or usage profiles. Gain a basic expertise do decide if or if not to use this technology.

Community

RAC Attack Workshop

Martin Klier, RAC Attack Ninja 🙂

All Sunday, April 10, 2016 (Event Details and Prerequisites)

One of the best ways to learn new technology is with hands-on experience. During this workshop you will have an opportunity to set up Oracle 12c Real Application Cluster environment on your laptop, go through advanced RAC related setup scenarios or work together with other technical geeks on solving RAC related challenges. Experienced RAC Attack volunteers (ninjas) will help you address any related issues and guide you through the setup.

Martin Klier RAC Attack Ninja Collaborate 2016