Fill the Glass Episode 3: Toon Koppelaars and the notion of moving application logic into the Database

Cary Millsap welcomes Toon Koppelaars to Episode 3 of Fill the Glass webinar series. Toon is an “old school” relational database professional. He’s convinced the relational model of data is here to stay, and has co-authored a book on this very topic titled “Applied Mathematics for Database Professionals” (Apress, 2007).

Next to being a relational dude, he’s also a long-time Oracle user. During his career he has worked in both developer (Pro*C, SQLForms, JDeveloper, Apex), as well as DBA roles (Oracle version 4 upwards). At the beginning of this millenium he authored the infamous “TheHelsinkiDeclaration.blogspot.com” blog, as a response to the trend, ignited by the arrival of Java and the JEE architecture, to move all application-logic out of the DBMS (away from PLSQL) and into Java “du-jour” frameworks. Currently Toon is a member of Oracle’s Real-World Performance team, where he troubleshoots performance issues most commonly caused by the aforementioned trend.

Fill the Glass Episode 2: The Oracle Exadata Database Machine and the Wunderschön Wonders of Smart Scan

FilltheGlass 12-18-14

PhotoPhotoCary Millsap welcomes Enkitec engineered system specialist Martin Bach in episode 2 of Fill the Glass. Martin will guide us in this information-packed hour through a tour of the extensive collection of Oracle Exadata internal technologies commonly called Smart Scan. Martin will demonstrate the positive differences that Smart Scan can make, show how it works, and give you a peek under the hood at how everything is instrumented. And as always, Cary and Martin will discuss your questions along the way.

What is “Fill the Glass”? This new webinar series is about Oracle and related technologies. It is a little different than the usual hello-slide-show-Q&A-bye routine. These shows include conversation. Our aim is to bring the technology to life. Our guests of course talk about the problems they’re solving and how they solve them, but our conversations include discussions about their ideas, their motives, their tools, …even their careers. Cary likes to find the twist, a way of perceiving a situation that you might not have thought of. Join us to learn, improve your career, and have some fun. See Episode 1 with Karen Morton here.

Where Did My CPU Go? Enkitec & Redgate Webinar by Karl Arao

This webinar focuses on CPU monitoring and capacity planning. Karl highlights scenarios typically encountered on a massively consolidated environment. For example, an environment where you may have 30+ databases and need to know how many CPU cores are being used at a particular time. In the Oracle world, the CPU is not just the “green thing” in the Enterprise Manager (OEM). It is actually much more than that. Karl will discuss the usual CPU monitoring tools in OEM, visualization enhancements that can be made by AWR analytics, as well as how these can be applied to critical capacity planning scenarios.

Key takeaways from this webinar:

  • Identify the consolidated CPU load of a cluster environment
  • Take quantitative information and make it visual so both the technical and non-technical can “see” what’s going on leading to prompt and accurate solutions

In-Memory in Action by Cary Millsap, Kerry Osborne and Tanel Poder

This one-hour webinar includes three of the brightest minds in the industry, Cary Millsap, Kerry Osborne and Tanel Poder. Hear them discuss the revolutionary technology of Oracle Database In-Memory, an in-memory column store that does not slow down the OLTP components and is compatible with all existing applications. This option enables real-time queries that scan multi-terabyte data sets in memory and return with a subsecond latency.

This webinar examines some of these queries, explain how and when they benefit from the database in-memory option and the related 12c improvements. See performance improvements never seen before.

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

Fill the Glass – New Webinar Series by Cary Millsap

PhotoAccenture Enkitec Group is excited to announce a new webinar series hosted by Cary Millsap. Find details below on the series and the first webinar featuring Karen Morton.

PhotoCary Millsap is a developer, teacher, writer, and consultant who has been a part of the Oracle ecosystem since 1989. His new webinar series about Oracle and related technologies is going to be little different than the usual hello-slide-show-Q&A-bye routine. These shows are going to include conversation. Our aim is to bring the technology to life. Our guests will of course talk about the problems they’re solving and how they solve them, but our conversations will include discussions about their ideas, their motives, their tools, …even their careers. Cary likes to find the twist, a way of perceiving a situation that you might not have thought of. Join us to learn, improve your career, and have some fun.

 

PhotoEpisode 1: SQL Performance Problem Seek & Destroy (Mostly Destroy) with Karen Morton

It’s usually not difficult to find SQL that is performing poorly. The hard part is what to do with a bad SQL statement once you have it. In this session, Karen Morton will show you a simple method that is reliable and repeatable for solving any problem SQL statement you might encounter.

 

DB12c Adaptive Optimization by Kerry Osborne

Summary:

One of the most interesting new features of the Oracle Database Optimizer is the ability to recognize its own mistakes and use execution statistics to automatically improve execution plans. Oracle calls this “Adaptive Optimization” and this talk will focus on how it works.

Webinar by Red Gate and Enkitec

Enkitec Awarded Oracle Excellence Awards- Energy/Utilities & Financial Services

Enkitec has established a global reputation with its customers by building and sustaining advanced technology environments. “Companies in these sectors have complex technology requirements well-suited for Oracle’s sophisticated solutions. We have been fortunate to attract some great clients in these industries. The ultimate measure for a consulting firm is the success of its clients. Enkitec is honored to receive this recognition,” said Wade Nicolas, CEO, Enkitec.

 

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.

Enkitec at Oracle OpenWorld 2013

Oracle PartnerNetwork’s Joel Borellis with Martin Paynter discussing Oracle Exadata for financial services.