Skip to main content

ISBN10: 0071712917 | ISBN13: 9780071712910

OCP Oracle9i Database: Performance Tuning Exam Guide, 1st Edition

ISBN10: 0071712917
ISBN13: 9780071712910
By Charles Pack

© 2002 Published March 27, 2002

Step 1. Download Adobe Digital Editions to your PC or Mac desktop/laptop.

Step 2. Register and authorize your Adobe ID (optional). To access your eBook on multiple devices, first create an Adobe ID. Then, open Adobe Digital Editions, go to the Help menu, and select "Authorize Computer" to link your Adobe ID.

Step 3. Open Your eBook. Use Adobe Digital Editions to open the file. If the eBook doesn’t open, contact customer service for assistance.

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.

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

Need support?   We're here to help - Get real-world support and resources every step of the way.

Top