• Sign In
  • My Cart 0)
main product photo

OCP Oracle9i Database: Performance Tuning Exam Guide

1st Edition
0071712917 · 9780071712910
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 ter… Read More
Add to Wish List
US$45.00
Request Review Copy
Download file to PC or Mac desktops or laptops

Step 1. Download Adobe Digital Editions Both PC and Mac users will need to download Adobe Digital Editions to access their eBook. You can download Adobe Digital Editions at Adobe's website here.


Step 2. Register an Adobe ID if you do not already have one. (This step is optional, but allows you to open the file on multiple devices) Visit account.Adobe.com to register your Adobe account.


Step 3: Authorize Adobe Digital Editions using your Adobe ID. In Adobe Digital Editions, go to the Help menu. Choose “Authorize Computer.”


Step 4: Open your file with Adobe Digital Editions. Once you’ve linked your Adobe Digital Editions with your Adobe ID, you should be able to access your eBook on any device which supports Adobe Digital Editions and is authorized with your ID. If your eBook does not open in Adobe Digital Editions upon download, please contact customer service

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

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.