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