Faithin Omaha eBook Collection

Download or read book Oracle Silver Bullets: Real-World Oracle Performance Secrets written by Donald K Burleson and published by . This book was released on 2005-01-01 with total page 280 pages. Available in PDF, EPUB and Kindle. Book excerpt: Every Oracle professional should feel the exhilaration of adding a single function-based index and seeing the execution speed cut-in-half for 500 SQL statements. It's these silver bullets that can make you a hero in your shop and amaze your friends and associates. All Oracle tuning professionals know that they must start by optimizing the database as-a-whole before tuning individual SQL statements. Only after you have tuned the external hardware (disk RAID, network, OS kernel parms) and the instance (indexes, CBO statistics, optimal parameter settings), is it appropriate to t