If you are forced to dig deeper into this, buy the book Optimizing Oracle Performance by Cary Millsap and Jeff Holt This book is the best for dealing with problems of this class. Dennis Williams