Enkitec.tv Oracle, Exadata, ODA and other good stuff!
Tanel Poder's Hacking Session: How Oracle SQL Plans Are Really Executed - Part 2. In this part we will use DTrace to drill down inside an execution plan and see how it gets executed internally.
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 will upload soon) we'll drill down inside an execution plan then.
Just a little bit of fun :-)
In part 3 I will look into some advanced uses of Exadata Snapper (and briefly the regular Session Snapper too), like what happens when a smart scan hits chained rows during processing and what happens when the storage cell requires an older version of a block for read consistency. I will also explain the concept of "cell processint depth" (my term) and show how to measure whether the smart scan actually processes the data in the blocks or just passes entire blocks though, back to the database ...
In the Part 2 I show how to use Exadata Snapper when SQL Monitoring metrics aren't enough to explain what's going on. We'll measure the storage index savings, cell flash cache usefulness and the actual amounts of IO reads and writes done (caused) by your DB session's activity.
I split the 3 hour video into 3 parts. In Part 1 I show some basics, a couple of slides and how I read a SQL Monitoring report on Exadata and its shortcomings.
Opening session from the 2012 E4 Conference. Kerry Osborne interviews Cary Millsap.
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 do, but how parameters work in general. This knowledge can be useful for explaining some seemingly weird things happening in Oracle :) 1) Did you know that there are multiple different types of configuration parameters inside Oracle? 2) Do you want...
Secret hacking session ? full scans, direct path reads, object level checkpoints, ORA-8103s!Topics:How do full table scans workHow and why do the ?ORA-8103: object no longer exists? happenHow 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?and more!