Oracle Performance Tuning Tips and Techniques

Erscheinungsjahr 1998
ISBN: 978-0-07-882434-0
Verlag: McGraw-Hill Education - Europe

Buch, Englisch, 904 Seiten, Format (B × H): 188 mm x 232 mm, Gewicht: 1724 g

In Oracle Performance Tuning Tips & Techniques, there are hundreds of real-world examples and insider secrets compiled from TUSC's standing-room only conference presentations and Oracle User Groups worldwide. From finding and fixing bottlenecks to enhancing performance using PL/SQL, this authroitative guide reveals proven methods for getting the most from your Oracle system throughout its lifecycle. Developed through years of consulting expertise, Oracle Performance Tuning Tips & Techniques is packed with time-saving, tuning strategies designed to ensure top system performance.

Autoren/Hrsg.

Niemic, Rich

Brown, Bradley

Trezzo, Joe

Inhaltsverzeichnis

Over a Decade of Tuning Experience. Basic Index Principles (Beginner Developer and Beginner DBA). Disk I/O and Fragmentation (DBA). Tning the init.ora (DBA Related). Enterprise Manager and Tuning Pack (DBA and Developer). Using EXPLAIN PLAN, TRACE, and TKPROF (Developer and DBA). Basic Hint Syntax (Developer and DBA). Query Tuning (Developer and DBA). Table Joins and Other Advanced Query Tuning. Using PL/SQL to Enhance Performance (Developer and DBA). Using Parallel Features to Improve Performance. Oracle8 New Features (Developer and DA). Oracle8 and 8i New Tips (Developer and DBA). The V$ Views (Developer and DBA). The x$ Tables (DBA). Using and Interpreting UTLESTAT/UTLBSTAT (Advanced DBA). Performing a Quick System Review (DBA). Monitor the System Using UNIX Utilities (DBA). ppendices: A: Key init.ora Parameters (DBA). B: The V$ Views (DBA and Developer). C: The x$ Tables (DBA).

Über Autor(innen)

Brown, Bradley
Bradley D. Brown, Joseph C. Trezzo, and Richard J. Niemiec are co-founders of TUSC (The Ultimate Software Consultants), an award-winning, senior-level RDBMS consulting company specializing in Oracle. Trezzo has served as Ediotr-In-Chief and Brown Executive Editor of the Exploring Oracle DBMS magazine. Niemiec is the Executive Vice-President of ILUG-A's Select magazine. These three are the driving force behind TUSC's success--their efforts were most recently recognized by their induction into the Entrepreneur Hall of Fame.