Product Description

-The perfect way to prepare for the Oracle9i Performance Tuning exam! -Contains exam essentials, real-world scenario sidebars, scenario-based questions, and fill-in-the-blank questions. -The CD includes flashcards, chapter-by-chapter exams, randomly generated question sets, a bonus exam, and an electronic version of the book.

Product Details

• Amazon Sales Rank: #1068392 in Books
• Published on: 2002-06-15
• Original language: English
• Number of items: 1
• Binding: Hardcover
• 704 pages

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-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 C
Diagnosing Shared Server Performance Issues
Using Oracle Blocks Efficiently
Tuning SQL Statements
Configuring Resource Manager

Featured on the CD
The enclosed CD is packed with vital preparation tools and materials, beginning with the Sybex EdgeTest testing engine for the Oracle9i Performance Tuning exam. Loaded with hundreds of practice questions, it lets you test yourself chapter by chapter or according to objective areas. You'll also find electronic flashcards for your PC and Palm handhelds and two bonus exams that will help you prepare for the test. Also included is an electronic version of the entire book.

About the Author
Joseph C. Johnson, OCP, has over 8 years of experience in the management of mission-critical Oracle databases. Joseph has administered production and development databases for a variety of clients in the education, manufacturing, e-commerce, healthcare, and financial services industries, and is currently working as a Senior Database Administrator with Greenbrier & Russel, Inc.

Customer Reviews

A good preparation tool
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.

Sybex not as good as Oracle Press book
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.

Topic well-covered
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...