OCP: Oracle9i Performance Tuning Study Guide

Joseph C. Johnson

  • 出版商: Sybex
  • 出版日期: 2002-06-15
  • 售價: $1,900
  • 貴賓價: 9.5$1,805
  • 語言: 英文
  • 頁數: 704
  • 裝訂: Hardcover
  • ISBN: 0782140653
  • ISBN-13: 9780782140651
  • 相關分類: Oracle
  • 已過版

買這商品的人也買了...

相關主題

商品描述

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

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