Oracle performance tuning

Systematic dragnet investigation for performance bottlenecks and usage of performance anti-pattern

Here I offer a set of more than 100 SQL-statements.
Each SQL considers a special aspect of performance anti-pattern or pitfalls. It selects a list of occurrences and gives recommendations to possibly fix this issue.
All lists are sorted by relevance so you can start your consideration at the top.
Be aware of your own brain. All these findings are recommendations for your personal consideration only. May be they are dramatically worth to develop activities for fixing. May also be you consider them as: Exactly this way my application should work.

If you plan to execute this SQL against your database:
Try my application "Panorama", available at this site. Panorama contains all these SQLs inside and it's much more convenient to execute them in Panorama and instantly drill down more from result into deep.