OCP Oracle9i Database: Performance Tuning Exam Guide / Edition 1

by Charles Pack, Jason S. Couchman

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 Osborne
Publication date:	03/27/2002
Series:	Oracle Press Series
Pages:	470
Product dimensions:	6.90(w) x 9.30(h) x 1.52(d)

About the Author

McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide

Table of Contents

PART I: OCP Tuning Exam Guide

1: Database Tuning Overview

2: Oracle Performance Tuning Methodology

3: Diagnostic and Tuning Tools

4: Sizing the Shared Pool

5: Sizing the Buffer Cache

6: Sizing Other SGA Structures

7: Database Configuration and I/O Issues

8: Optimize Sort Operations

9: Diagnosing Contention for Latches

10: Tuning Rollback or Undo Segments

11: Monitoring and Detecting Lock Contention

12: Tuning Oracle Shared Server

13: Application Tuning

14: Using Oracle Blocks Efficiently

15: SQL Statement Tuning

16: OS Considerations and Oracle Resource Manager
PART II: Practice Exams

17: Practice Exam 1 and 2