Oracle Performance Tuning Tips and Techniques

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.

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).