Alberto Dell’Era’s investigations and scripts on Oracle optimizer
When it comes to Oracle Optimizer Jonathan Lewis, Christian Antognini and Wolfgang Breitling have the best resources I have ever read. And now I will add Alberto Dell’Era to above three - http://www.adellera.it/investigations/index.html
ps: if you still didn’t see this video presentation take a look 
Optimising through Understanding by Jonathan Lewis