Description

Product Description

From the exclusive publishers of Oracle Press books comes a unique volume, packed with undocumented tips & techniques, for tuning and tailoring Oracle9 i to perform at its peak. Author Rich Niemiec has been named by Oracle Corporation as one of the top six Oracle experts in the world!

From the Back Cover

Get Undocumented, Insider Advice

Maintain a high-performance Oracle9i environment using the proven tuning methods presented in this authoritative resource. Written by the experts at TUSC and developed through years of successful Oracle consulting experience, this book offers hundreds of essential tips guaranteed to enhance system performance. Real-world examples illustrate insider best practices and in-depth details throughout the book highlight the new tuning options available in Oracle9i.

Select the best indexing options for a variety of situationsDistribute key data files across available hardware disksTune crucial init.ora parameters for peak database performanceTake full advantage of Oracle Enterprise ManagerUse EXPLAIN, TRACE, TKPROF, STORED OUTLINES, and other toolsSpecify hints to override the optimizer as necessaryAutomate queries using PL/SQL stored proceduresUse the Parallel Executions Option (PEO) for enhanced performanceMonitor and tune the database with STATSPACKQuery the V$ views and X$ tables

About the Author

McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide