Improving Oracle Join Performance Issues with V$ Views and Temporary Tables

Querying with Correlated Subqueries: Why Oracle 11g Fails and How to Fix It.