OCP Oracle9i Database: Performance Tuning Exam Guide byPack, Charles; Népszerű

Rövid leírás:

Covering all official exam objectives and containing over 300 practice questions, chapter self-tests, two minute drills, a glossary of key Oracle terms, this is the best study tool available.

Több

Hosszú leírás:

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.

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.

Több

Tartalomjegyzék:

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