
OCP: Oracle9i Performance Tuning Study Guide
Exam 1Z0-033
Joseph C. Johnson(Author)
Sybex Inc.,U.S. (Publisher)
1st Edition
Published on 11. July 2002
Book
Hardback
602 pages
978-0-7821-4065-1 (ISBN)
Description
Here's the book you need to prepare for Exam 1Z0-033: Oracle9i Database: Performance Tuning. This Study Guide provides:
* In-depth coverage of official exam objectives
* Practical information on optimizing Oracle9i databases
* Hundreds of challenging review questions, in the book and on the CD
Authoritative coverage of all exam objectives, including:
* Using Diagnostic and Tuning Tools
* Monitoring and Managing the Buffer Cache
* Optimizing Sort Operations
* Detecting and Resolving Lock Contention
* Diagnosing Shared Server Performance Issues
* Using Oracle Blocks Efficiently
* Tuning SQL Statements
* Configuring Resource Manager
* In-depth coverage of official exam objectives
* Practical information on optimizing Oracle9i databases
* Hundreds of challenging review questions, in the book and on the CD
Authoritative coverage of all exam objectives, including:
* Using Diagnostic and Tuning Tools
* Monitoring and Managing the Buffer Cache
* Optimizing Sort Operations
* Detecting and Resolving Lock Contention
* Diagnosing Shared Server Performance Issues
* Using Oracle Blocks Efficiently
* Tuning SQL Statements
* Configuring Resource Manager
More details
Edition
1., Auflage
Language
English
Place of publication
New York
United States
Publishing group
John Wiley & Sons Inc
Target group
Professional and scholarly
Dimensions
Height: 23.6 cm
Width: 19.4 cm
Thickness: 40 mm
Weight
1331 gr
ISBN-13
978-0-7821-4065-1 (9780782140651)
Schweitzer Classification
Other editions
Additional editions

E-Book
07/2006
Sybex
€45.50
Available for download
Person
Joseph Johnson is an OCP in database administration with more than 7 years' experience with Oracle databases. He is currently a senior DBA for Greenbriar & Russel in Milwaukee. Johnson was the coauthor of Sybex's Oracle8i DBA Performance Tuning and Network Administration Study Guide.
Content
IntroductionxviiAssessment Test.
Chapter1 Introduction to Performance Tuning.
Chapter2 Sources of Tuning Information.
Chapter3 SQL Application Tuning and Design.
Chapter4 Tuning the Shared Pool.
Chapter5 Tuning the Database Buffer Cache.
Chapter6 Tuning Other SGA Areas.
Chapter7 Tuning Redo Mechanisms.
Chapter8 Tuning Disk I/O.
Chapter9 Tuning Contention.
Chapter10 Operating System Tuning.
Glossary.
Index.
Chapter1 Introduction to Performance Tuning.
Chapter2 Sources of Tuning Information.
Chapter3 SQL Application Tuning and Design.
Chapter4 Tuning the Shared Pool.
Chapter5 Tuning the Database Buffer Cache.
Chapter6 Tuning Other SGA Areas.
Chapter7 Tuning Redo Mechanisms.
Chapter8 Tuning Disk I/O.
Chapter9 Tuning Contention.
Chapter10 Operating System Tuning.
Glossary.
Index.