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 … [Continue reading]

Enkitec at Oracle OpenWorld 2013

Oracle PartnerNetwork's Joel Borellis with Martin Paynter discussing Oracle Exadata for financial services. https://www.youtube.com/watch?v=Fy0mwvaJUlo&feature=youtube_gdata_player   … [Continue reading]

Hadoop Architecture vs. Exadata Architecture

Watch Kerry Osborne compare and contrast Hadoop and Exadata Architecture from his E4 2012 presentation "Hadoop Meets Exadata." http://vimeo.com/65149611 … [Continue reading]

Tanel Poder’s Hacking Session: How Oracle SQL Plans Are Really Executed – Part 2

Here's the Part 2 of the Oracle SQL plan execution hacking session (Part 1 is here)! We'll use a bit of DTracing to peek inside an Oracle SQL plan execution, plus some other random experiments. You can download the qer_trace.sh script from … [Continue reading]

Tanel Poder’s Hacking Session: How Oracle SQL Plans Are Really Executed – Part 1

This is the Part 1 of the hacking session I delivered live. In this part we'll talk mostly about how an application talks to the database session when wanting to execute a query (tracing OPI calls, fetch operations etc). In the Part 2 (which I … [Continue reading]

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. http://vimeo.com/58133630 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 … [Continue reading]

What Karen Morton says is different about tuning SQL on Exadata…

https://vimeo.com/60616753 Here is the link to set up a user account at Enkitec and download Karen's presentation deck from E42012: http://www.enkitec.com/about/presentations/tuning_sql_for_oracle_exadata … [Continue reading]

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 … [Continue reading]