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]

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

Snapper V4 BETA launch video

Here's the video of Snapper v4.0 beta "launch party". I have fixed most of the bugs you see in this video :) You can get the latest Snapper v4 BETA from here: http://blog.tanelpoder.com/files/scripts/snapper4.sql Please save it with "Save … [Continue reading]

Oracle Hacking Session with Tanel Poder from OakTableWorld (Oct 2012 in San Francisco)

I delivered a live Oracle hacking session at OakTableWorld in San Francisco two weeks ago and here's the video (Thanks to Kyle Hailey & co)! Note that this was a hacking session deliberately aimed to be fun and "hackerish" rather than useful. … [Continue reading]

“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! Enjoy! http://www.youtube.com/watch?v=RYyCWiej0kk   … [Continue reading]

Oracle Hacking Session with Tanel Poder – Oracle Parameter Infrastructure

This hacking session's topic is Oracle parameter infrastructure. We will look into some internals of Oracle instance, session and optimizer environment parameter management. This session does not attempt to explain what all the individual parameters … [Continue reading]

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: Topics: How do full table scans work? How and why do the "ORA-8103: object no longer exists" errors happen How does Oracle (11g) decide … [Continue reading]