|
Oracle Performance Tuning Tips & Techniques
From the exclusive publishers of Oracle Press books comes a unique volume, packed with undocumented tips & techniques, for tuning and tailoring Oracle9i 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! This is a 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.
Table of Contents:
1 Oracle9i - An Introduction to Oracle9i New Features (DBA & Developer)
2 Basic Index Principles (Beginner Developer and Beginner DBA)
3 Disk I/O and Fragmentation (DBA)
4 Tuning the Database with Initialization Parameters (DBA)
5 Enterprise Manager and Tuning Pack (DBA and Developer)
6 Using EXPLAIN, TRACE, TKPROF, and STORED OUTLINES (Developer & DBA)
7 Basic Hint Syntax (Developer and DBA)
8 Query Tuning (Developer and Beginner DBA)
9 Table Joins and Other Advanced Tuning
10 Using PL/SQL to Enhance Performance (Developer and DBA)
11 Using Parallel Features to Improve Performance (DBA)
12 The V$ Views (Developer & DBA)
13 The X$ Tables (Advanced DBA)
14 Using STATSPACK to Tune Waits and Latches (Advanced DBA)
15 Performing a Quick System Review (DBA)
16 Monitoring the System Using UNIX Utilities (DBA)
A Key init.ora Parameters (DBA)
B The V$ Views (DBA and Developer)
C The X$ Tables (DBA)
|
