OCP Oracle9i Database: Performance Tuning Exam Guide / Edition 1

OCP Oracle9i Database: Performance Tuning Exam Guide / Edition 1

by Charles Pack, Jason S. Couchman
     
 

ISBN-10: 0072195274

ISBN-13: 9780072195279

Pub. Date: 03/27/2002

Publisher: McGraw-Hill Professional Publishing

Prepare to pass the Oracle9i OCP DBA Performance Tuning exam using this focused, and complete guide. Covering all official exam objectives and containing over 300 practice questions, chapter self-tests, two minute drills, a glossary of key Oracle terms—plus a CD-ROM with a testing engine that simulates the actual exam—this is the best study tool available

…  See more details below

Overview

Prepare to pass the Oracle9i OCP DBA Performance Tuning exam using this focused, and complete guide. Covering all official exam objectives and containing over 300 practice questions, chapter self-tests, two minute drills, a glossary of key Oracle terms—plus a CD-ROM with a testing engine that simulates the actual exam—this is the best study tool available.

Product Details

ISBN-13:
9780072195279
Publisher:
McGraw-Hill Professional Publishing
Publication date:
03/27/2002
Series:
Oracle Press Series
Pages:
470
Product dimensions:
6.90(w) x 9.30(h) x 1.52(d)

Table of Contents

Acknowledgments
Introduction
Pt. IOCP Tuning Exam Guide
1Database Tuning Overview3
2Oracle Performance Tuning Methodology17
3Diagnostic and Tuning Tools37
4Sizing the Shared Pool65
5Sizing the Buffer Cache93
6Sizing Other SGA Structures123
7Database Configuration and I/O Issues139
8Optimize Sort Operations167
9Diagnosing Contention for Latches185
10Tuning Rollback or Undo Segments201
11Monitoring and Detecting Lock Contention231
12Tuning Oracle Shared Server257
13Application Tuning275
14Using Oracle Blocks Efficiently297
15SQL Statement Tuning329
16OS Considerations and Oracle Resource Manager359
Pt. IIPractice Exams
17Practice Exam 1 and 2383
Glossary446
Index457

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >