Available:*
Library | Item Barcode | Call Number | Material Type | Item Category 1 | Status |
---|---|---|---|---|---|
Searching... | 30000004209429 | QA76.9.D3 N53 1999 | Open Access Book | Book | Searching... |
On Order
Summary
Summary
This guide provides Oracle DBAs with the know-how to tune and tweak Oracle databases to achieve optimal performance results, using real-world examples. There is information on bottlenecks, undocumented parameters and performance-enhancing tips useful to Oracle DBAs. It provides specific examples to build performance tuning skill sets. The tips and techniques have been compiled directly from Oracle User Groups around the world.
Author Notes
Joseph C. Trezzo, Bradley D. Brown, and Richard J. Niemiec are co-founders of the TUSC group (The Ultimate Software Consultants), an award-winning, senior-level RDBMS consulting company specializing in Oracle. Niemiec is the executive vice-president of IOUG and executive editor of IOUG-A's Select magazine. Brown has served as executive editor and Trezzo editor-in-chief of Exploring Oracle DBMS magazine. The three are the driving force behind TUSC's success--their efforts were most recently recognized by their introduction into the Entrepreneur Hall of fame.
Table of Contents
Foreword | p. XVII |
Acknowledgments | p. XIX |
Introduction | p. XXIII |
1 Over a Decade of Tuning Experience | p. 1 |
2 Basic Index Principles (Beginner Developer and Beginner DBA) | p. 67 |
3 Disk I/O and Fragmentation (DBA) | p. 97 |
4 Tuning the init.ora (DBA Related) | p. 133 |
5 Enterprise Manager and Tuning Pack (DBA and Developer) | p. 201 |
6 Using Explain Plan, Trace, and TKPROF (Developer and DBA) | p. 251 |
7 Basic Hint Syntax (Developer and DBA) | p. 283 |
8 Query Tuning (Developer and DBA) | p. 315 |
9 Table Joins and Other Advanced Query Tuning | p. 341 |
10 Using PL/SQL to Enhance Performance (Developer and DBA) | p. 417 |
11 Using Parallel Features to Improve Performance | p. 449 |
12 Oracle8 New Features (Developer and DBA) | p. 491 |
13 Oracle8 and 8i New Tips (Developer and DBA) | p. 517 |
14 The V$ Views (Developer and DBA) | p. 555 |
15 The x$ Tables (DBA) | p. 595 |
16 Using and Interpreting UTLESTAT/UTLBSTAT (Advanced DBA) | p. 631 |
17 Performing a Quick System Review (DBA) | p. 661 |
18 Monitor the System Using UNIX Utilities (DBA) | p. 705 |
A Key init.ora Parameters (DBA) | p. 729 |
B The V$ Views (DBA and Developer) | p. 767 |
C The x$ Tables (DBA) | p. 843 |
Index | p. 873 |