Database Performance Tuning and Optimization: Using Oracle

Overview

Database Performance Tuning and Optimization comprehensively addresses each level separately by focusing first on underlying principles and root causes, and then proposes both theoretical and practical solutions using Oracle 8i examples as the RDBMS. The book combines theory with practical tools (in the form of Oracle and UNIX shell scripts) to address the tuning and optimization issues of DBAs and developers, irrespective of whether they use Oracle.
...
See more details below
Hardcover (2003)
$79.20
BN.com price
(Save 20%)$99.00 List Price
Other sellers (Hardcover)
  • All (11) from $4.12   
  • New (5) from $45.0   
  • Used (6) from $4.12   
Sending request ...

Overview

Database Performance Tuning and Optimization comprehensively addresses each level separately by focusing first on underlying principles and root causes, and then proposes both theoretical and practical solutions using Oracle 8i examples as the RDBMS. The book combines theory with practical tools (in the form of Oracle and UNIX shell scripts) to address the tuning and optimization issues of DBAs and developers, irrespective of whether they use Oracle.
Read More Show Less

Product Details

  • ISBN-13: 9780387953939
  • Publisher: Springer New York
  • Publication date: 1/2/2003
  • Edition description: 2003
  • Edition number: 1
  • Pages: 489
  • Product dimensions: 1.13 (w) x 10.00 (h) x 7.00 (d)

Table of Contents

Preface
Pt. 1 Methodology 1
1 Database Application Development 3
2 Performance Tuning Methodology 29
3 Tuning the Conceptual Level of a Database 41
Pt. 2 Oracle Tools for Tuning and Optimization 55
4 Internal Level of an Oracle Database 57
5 Tuning of Disk Resident Data Structures 81
6 Tuning of Memory-Resident Data Structures 137
7 Oracle Utility for Tuning and Optimization 189
8 Optimization of the External Level of a Database 229
9 Query Tuning and Optimization Under Oracle 8i 283
10 Special Features of Oracle 8i and a Glimpse into Oracle 9i 315
Pt. 3 Contemporary Issues 359
11 Tuning the Data Warehouse at All Levels 361
12 Web-Based Database Applications 385
App. A Sizing Methodology in Oracle 8i 401
App. B Instance and Database Creation 413
App. C Instance and Database Removal 433
App. D Database Refresh with Transportable Tablespaces 439
App. E Mathematical Foundation of Relational Databases 449
Index 481
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)