Oracle9i Performance Tuning Tips & Techniques
  • Oracle9i Performance Tuning Tips & Techniques
  • Oracle9i Performance Tuning Tips & Techniques

Oracle9i Performance Tuning Tips & Techniques

by Richard Niemiec, Richard J. Niemiec
     
 

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.

…  See more details below

Overview

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 situations

• Distribute key data files across available hardware disks

• Tune crucial init.ora parameters for peak database performance

• Take full advantage of Oracle Enterprise Manager

• Use EXPLAIN, TRACE, TKPROF, STORED OUTLINES, and other tools

• Specify hints to override the optimizer as necessary

• Automate queries using PL/SQL stored procedures

• Use the Parallel Executions Option (PEO) for enhanced performance

• Monitor and tune the database with STATSPACK

• Query the V$ views and X$ tables

Read More

Editorial Reviews

bn.com
The Barnes & Noble Review
This book can help you dramatically improve the performance of your Oracle9i databases. It’s that simple.

Author Richard J. Niemiec was named in 2001 as one of the world’s six Oracle Certified Masters. He knows the subject inside out. And he’s just updated his definitive guide to Oracle tuning, reflecting dozens of new techniques available in Oracle9i.

You name it, Niemiec covers it in depth: indexing, disk I/O and fragmentation, initialization parameters, EXPLAIN, TRACE, TKPROF, query tuning, table joins, even advanced mathematical analysis techniques and patterns interpretation.

With each version of Oracle, more DBAs become aware of the power of V$ views to look deep into the heart of Oracle databases, and more V$ views become available. (There are now 259 of them!) Niemiec’s substantially beefed up his coverage. With some coauthor assistance, he’s also revamped the book’s discussion of X$ tables, which can expose undocumented features and parameters, even preview forthcoming Oracle versions. He’s also nearly doubled his coverage of PL/SQL tuning.

Niemiec is especially passionate about STATSPACK, Oracle’s new replacement for UTLESTAT/UTLBSTAT. You’ll learn how to install it, manage it, run it, and interpret its results for both proactive and reactive tuning. Among the many other additions in this edition: bitmap indexes, locally managed objects, stored outlines, Kalman filtering, and new Linux-specific coverage.

DBAs are among the busiest people we know. They’ll love this book’s end-of-chapter Tips Reviews, which summarize key techniques into quick-access bullet points. Because what good are fast databases if optimizing them takes forever? Bill Camarda

Bill Camarda is a consultant, writer, and web/multimedia content developer. His 15 books include Special Edition Using Word 2000 and Upgrading & Fixing Networks for Dummies, Second Edition.

Read More

Product Details

ISBN-13:
9780072224733
Publisher:
McGraw-Hill Companies, The
Publication date:
05/12/2003
Series:
Osborne ORACLE Press Series
Pages:
864
Product dimensions:
7.30(w) x 9.00(h) x 1.70(d)

Meet 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

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >