OCP: Oracle9i Performance Tuning Study Guide with CDROM [Hardcover]

Joseph C. Johnson (Author)

Book Description

ISBN-10: 0782140653 | ISBN-13: 978-0782140651 | Publication Date: June 15, 2002 | Edition: 1

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

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Editorial Reviews

From the Back Cover

Here's the book you need to prepare for Exam 1Z0-033: Oracle9i Database:Performance Tuning. This Study Guide provides:

• In-depthcoverage of official exam objectives
• Practical information on optimizingOracle9i databases
• Hundreds of challenging review questions, in the book andon the CD

Authoritative coverage of all exam objectives,including:

• Using Diagnostic and TuningTools
• Monitoring and Managing the Buffer Cache
• Optimizing SortOperations
• Detecting and Resolving Lock Contention
• Diagnosing SharedServer Performance Issues
• Using Oracle Blocks Efficiently
• Tuning SQL Statements
• Configuring Resource Manager

About the Author

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.

Product Details

• Hardcover: 704 pages
• Publisher: Sybex; 1 edition (June 15, 2002)
• Language: English
• ISBN-10: 0782140653
• ISBN-13: 978-0782140651
• Product Dimensions: 9.1 x 7.8 x 1.6 inches
• Shipping Weight: 3 pounds (View shipping rates and policies)
• Average Customer Review: 3.7 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #1,970,043 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

6 of 6 people found the following review helpful:

4.0 out of 5 stars A good preparation tool, September 16, 2002

By 

CREFCOEUR PHILIPPE (Brussels Belgium) - See all my reviews

This review is from: OCP: Oracle9i Performance Tuning Study Guide with CDROM (Hardcover)

My purpose was to pass the exam and I have done it using this book but also the Osborne book by Ch. Pack.
Both of them are very good books and are complementary.

Pros:
- A lot of examples: extracts from statspack reports, screenshots of Oracle Enterprise Manager tools. It's very interesting to understand but it's no use for the exam.
- The exam-based questions are challenging.
- Nearly all you need to know can be found in this book

Cons:
- This book doesn't follow Oracle test content checklist. It's all mixed up but there is a good plan table.
- Some chapter are too much detailed, too many parameters for Oracle utilities (eg TKPROF). It's sometime difficult to see what's important to know for the exam. I only had basic questions about those tools nothing about all the options described in the book.
- They are small mistakes: CREATE_STORED_OUTLINES, USE_PRIVATE_OUTLINES and USE_PRIVATE_OUTLINES are stated as initialization parameters but it's not the case (check otn.oracle.com).

My advice:
- have a good understanding of Oracle views. I had between 10 and 15 questions relating to views.
- use both books to be well prepared. This exam is quite difficult.

1 of 1 people found the following review helpful:

3.0 out of 5 stars Sybex not as good as Oracle Press book, September 13, 2002

By 

OCP DBA (Louisville, KY United States) - See all my reviews

This review is from: OCP: Oracle9i Performance Tuning Study Guide with CDROM (Hardcover)

I bought the Sybex Performance Tuning book. A colleague of mine bought the Oracle Press book. I read both and passed the OCP exam with plenty to spare. While the Sybex book is good, the Oracle Press book is better.

4.0 out of 5 stars Topic well-covered, October 4, 2004

By 

TLAW_DBA "OCP Oracle 6i/9i/10g, SCSA Solaris ... (Montreal, QC Canada) - See all my reviews

This review is from: OCP: Oracle9i Performance Tuning Study Guide with CDROM (Hardcover)

Thanks to the author. I used this book for my last exam along with the oracle press book. The topic on the exam is completly covered but not according to checklist designed by oracle. But you can still find your way out. I have to admit that the book is really good I like it. It has sufficient details that help a lot. The practice exams questions are also really good. But there is one small mistake that I noticed is the answer to one question related to the alert log file in Unix environment (sometimes the answer is alert_sid.ora and sometimes it is alert_sid.log).
Finally to candidates for the exam, expect to see a lot of questions on the views (performance & data dictionary), latch contentions, initialization parameters, IOT, and Index...