Table of Contents

 

 < Day Day Up > 



oracle high performance tuning for 9i and 10g
Oracle High Performance Tuning for 9i and 10g
by Gavin Powell ISBN:1555583059
Digital Press 2004 (738 pages)

This text covers the three parts of tuning an Oracle database: data modeling, SQL code tuning, and physical database configuration, and explains both problem detection and resolution.

Table of Contents
Oracle High Performance Tuning for 9i and 10g
Preface
Introduction
Part I - Data Model Tuning
Chapter 1- The Relational Database Model
Chapter 2- Tuning the Relational Database Model
Chapter 3- Different Forms of the Relational Database Model
Chapter 4- A Brief History of Data Modeling
Part II - SQL Code Tuning
Chapter 5- What is SQL?
Chapter 6- The Basics of Efficient SQL
Chapter 7- Common Sense Indexing
Chapter 8- Making SQL Efficient in Oracle Database
Chapter 9- How to Find Problem Queries
Chapter 10- Tuning SQL with Oracle Enterprise Manager
Part III - Physical and Configuration Tuning
Chapter 11- Installing Oracle and Creating a Database
Chapter 12- Tuning Oracle Database File Structures
Chapter 13- Object Tuning
Chapter 14- Low-Level Physical Tuning
Chapter 15- Hardware Resource Usage Tuning
Chapter 16- Tuning Network Usage
Chapter 17- Oracle Partitioning and Parallelism
Chapter 18- Ratios: Possible Symptoms of Problems
Chapter 19- Wait Events
Chapter 20- Latches
Chapter 21- Tools and Utilities
Chapter 22- Tuning with the Wait Event Interface and STATSPACK
Appendix A- Sample Databases
Appendix B- Sample Scripts
Appendix C- Sources of Information
Index
List of Figures


 

 < Day Day Up > 



Oracle High Performance Tuning for 9i and 10g
Oracle High Performance Tuning for 9i and 10g
ISBN: 1555583059
EAN: 2147483647
Year: 2003
Pages: 164

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net