OCP Oracle9i Database: Performance Tuning Exam Guide / Edition 1
by Charles Pack, Jason S. CouchmanISBN-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
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
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 ManagerPART II: Practice Exams 17: Practice Exam 1 and 2
Customer Reviews
Average Review: