OCP Oracle9i Database
Performance Tuning Exam Guide
Published on 17. April 2002
Book
Hardback
470 pages
978-0-07-219527-9 (ISBN)
Description
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.
More details
Series
Language
English
Place of publication
New York
United States
Publishing group
McGraw-Hill Education - Europe
Target group
Professional and scholarly
Illustrations
5 Illustrations
Dimensions
Height: 236 mm
Width: 175 mm
Thickness: 38 mm
Weight
1025 gr
ISBN-13
978-0-07-219527-9 (9780072195279)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
Charles Pack
OCP Oracle9i Database: Performance Tuning Exam Guide
E-Book
04/2002
1st Edition
McGraw-Hill Education
€90.65
Available for download
Person
Jason Couchman (New York, NY) is an OCP-certified Oracle DBA and author of several Osborne titles including: Oracle Certified Professional DBA Certification Exam Guide, Oracle Certified Professional Application Developer Exam Guide, and Oracle Certified Professional DBO Certification Exam Guide. He's led Oracle database projects with Fortune 500 corporations and presented topics at the North Carolina Oracle User Group. His articles on Internet and intranet development have been published internationally.
Content
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