Favorite Sessions from E4 2014

Below are some of our favorite sessions from last years Enkitec Extreme Exadata Expo (E4) conference.

My PX Goes to 11 by Kerry Osborne & Chris Wones

This session provides a case study detailing the implementation of extreme parallelism in a very large DW environment. The system was implemented on a RAC cluster hosted on 2 Exadata X3-8’s. The application provides in-depth analysis for product performance and shopping behaviors to the retail industry. This presentation combines the business case with the technical hurdles that had to be overcome in order to enable the system to work. One of the biggest challenges was the decision/requirement to not do any pre-aggregation of data, meaning that every report had to hit the raw data. Exadata provided the perfect platform allowing the power of SQL to be applied but still allowing a large portion of the work to be pushed down to the data.

Download Presentation

Exadata vs. Teradata in the Healthcare Industry by Tim Fox

This session will recap a Proof of Concept (POC) where 40TB database was migrated from Teradata to Exadata so that a head to head comparison could be done. The application at the center of the test was Epic’s Clarity Data Warehouse which is in use at many, large healthcare organizations in the US. We will discuss the following aspects of this test: architecture comparison, data migration/conversion of 40TB, test execution and recording results and unique challenges with very large databases. The results of this POC are truly staggering. To find out who won, and by how much, come to this session. This is a “must see.”

Download Presentation

E4 2015

Reducing downtime using incremental backups and X-Platform TTS, presented by Martin Bach

A little known MOS note describes how you can potentially reduce downtime by a significant amount when migrating databases between systems with different endianness. Many sites are looking for ways to move their databases from big-endian platforms such as HP-UX, AIX or Solaris/SPARC to an Exadata system running Linux. In this webinar, Martin Bach will explain how implementing a cross-platform incremental backup in conjunction with cross-platform transportable tablespaces makes this possible.

E4 2012 – A Look Back at our First E4 (Enkitec Extreme Exadata Expo)

Here is a compilation from E4 2012 featuring all presenters and abstract titles.

E4 2013 is already shaping up to be a great educational experience as well. Here is a short list of Exadata experts who have already committed to present:

Tom Kyte: Keynote
Maria Colgan
Andy Colvin
Karen Morton
Tyler Muth
Kerry Osborne
Tanel  Põder
Ferhat Sengonul

Call for Papers is currently OPEN – click HERE to submit an abstract.
Deadline: April 30, 2013

The easiest way to make your query run 6-7x faster on Exadata

Check out this bit from my Exadata speech at the previous Enkitec E4 conference. You don’t see much of my screen output there, but if you attended my Exadata hacking session (or have watched the videos), then you’ll recognize what I’m talking about.

Enjoy! 😉

Tanel Poder’s Exadata Snapper Hacking session videos

Exadata Snapper (also called ExaSnapper or ExaSnap) is a new tool by Tanel Poder, which allows to “peek” into some SQL Execution-related cell metrics without leaving the Oracle database session / sqlplus prompt. The current version 0.7 is a beta version and will likely be much improved and changed once it reaches v1.0.

The tool itself will be downloadable from enkitec.com (will update this post once it’s there).

Here are the videos, split into 3 parts:

  • Part 1 – Introduction
  • Part 2 – Smart Scan and IO activity in the cell
  • Part 3 – Advanced Metrics and Q&A

Part 1 – Introduction

Part 2 – Smart Scan and IO activity in the cell

Part 3 – Advanced Metrics and Q&A

“My Perspective on Exadata” – Kerry Osborne interviewing Cary Millsap on E4 Stage

Here’s the opening session’s video of the the Enkitec Extreme Exadata Expo conference. Kerry Osborne is interviewing Cary Millsap on Cary’s view on Oracle Exadata!



Oracle full table scans, direct path reads, object level checkpoints, ORA-8103s

Note: The video below is back online now! 

Here’s another hacking session video from last year:


  • How do full table scans work?
  • How and why do the “ORA-8103: object no longer exists” errors happen
  • How does Oracle (11g) decide between a buffered full table scan and a direct path read scan (plus smart scan in Exadata)
  • What’s the difference between an object_id and data_object_id?