Sybex

Home Certification IT Administration Architecture & Design
3D Animation & CGI Internet Marketing
Print this page Share

OCP: Oracle9i Performance Tuning Study Guide: Exam 1Z0-033

ISBN: 978-0-7821-4065-1
602 pages
June 2002
OCP: Oracle9i Performance Tuning Study Guide: Exam 1Z0-033 (0782140653) cover image

Description

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

Authoritative coverage of all exam objectives, including:

  • 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

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

See More

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.

See More

Author Information

Joseph Johnson is an OCP in database administration with more than 7 years' experience with Oracle databases. He is currently a senior DBA for Greenbriar & Russel in Milwaukee. Johnson was the coauthor of Sybex's Oracle8i DBA Performance Tuning and Network Administration Study Guide.
See More

Downloads

Download TitleSizeDownload
See More

Errata

Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.

ChapterPageDetailsDatePrint Run
See More

Learn more about