Would like to hear from gurus, what should be the starting point or can say; what are the best practices for a code review, this is in reference of Oracle 11gR2 on Solaris box, having single and multiple instances too (RAC).
Code can either be a simple, but pretty long Sql statement (recursive joins & a lot more) or a 1000 lines of a pl/sql package, having many procedures & functions.
In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!