OCP: Oracle9i Performance Tuning Study Guide

Here's the book you need to prepare for Exam 1Z0-033: Oracle9i Database: Performance Tuning. This Study Guide provides:

• In-depth coverage of official exam objectives
• Practical information on optimizing Oracle9i databases
• Hundreds of challenging review questions, in the book and on the CD

• Using Diagnostic and Tuning Tools
• Monitoring and Managing the Buffer Cache
• Optimizing Sort Operations
• Detecting and Resolving Lock Contention
• Diagnosing Shared Server Performance Issues
• Using Oracle Blocks Efficiently
• Tuning SQL Statements
• Configuring Resource Manager

Contents

Introduction
Assessment Test
Chapter 1 Introduction to Performance Tuning
Chapter 2 Sources of Tuning Information
Chapter 3 SQL Application Tuning and Design
Chapter 4 Tuning the Shared Pool
Chapter 5 Tuning the Database Buffer Cache
Chapter 6 Tuning Other SGA Areas
Chapter 7 Tuning Redo Mechanisms
Chapter 8 Tuning Disk I/O
Chapter 9 Tuning Contention
Chapter 10 Operating System Tuning
Glossary
Index