Oracle9i Performance Tuning Tips & Techniques - Brossura

Libro 16 di 135: Oracle Press

Niemiec, Richard

 
9780072224733: Oracle9i Performance Tuning Tips & Techniques

Sinossi

This must-have revision of the best-selling Oracle Performance Tuning Tips & Techniques, is an invaluable collection of authoritative, tried-and-true tips and techniques for administrators, programmers, and end users looking to tune and tailor Oracle9i to perform at its peak.

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

Informazioni sull?autore

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

Dalla quarta di copertina

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

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

Altre edizioni note dello stesso titolo

9780070540651: Oracle9I Performance Tuning Tips & Techniques

Edizione in evidenza

ISBN 10:  0070540659 ISBN 13:  9780070540651
Brossura