OCP: Oracle9i Performance Tuning Study Guide / Edition 1

OCP: Oracle9i Performance Tuning Study Guide / Edition 1

by Joseph C. Johnson
     
 

ISBN-10: 0782140653

ISBN-13: 9780782140651

Pub. Date: 05/24/2002

Publisher: Wiley

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

  • In-depthcoverage of official exam objectives
  • Practical information on optimizingOracle9i databases
  • Hundreds of challenging review questions, in the book andon the CD

Authoritative coverage of all exam…  See more details below

Overview

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

  • In-depthcoverage of official exam objectives
  • Practical information on optimizingOracle9i databases
  • Hundreds of challenging review questions, in the book andon the CD

Authoritative coverage of all exam objectives,including:
  • Using Diagnostic and TuningTools
  • Monitoring and Managing the Buffer Cache
  • Optimizing SortOperations
  • Detecting and Resolving Lock Contention
  • Diagnosing SharedServer Performance Issues
  • Using Oracle Blocks Efficiently
  • Tuning SQL Statements
  • Configuring Resource Manager

Product Details

ISBN-13:
9780782140651
Publisher:
Wiley
Publication date:
05/24/2002
Edition description:
Study Guide
Pages:
602
Product dimensions:
7.80(w) x 9.20(h) x 1.70(d)

Table of Contents

IntroductionxviiAssessment Test.

Chapter1 Introduction to Performance Tuning.

Chapter2 Sources of Tuning Information.

Chapter3 SQL Application Tuning and Design.

Chapter4 Tuning the Shared Pool.

Chapter5 Tuning the Database Buffer Cache.

Chapter6 Tuning Other SGA Areas.

Chapter7 Tuning Redo Mechanisms.

Chapter8 Tuning Disk I/O.

Chapter9 Tuning Contention.

Chapter10 Operating System Tuning.

Glossary.

Index.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >