Joseph C. Johnson
Amazon Price: $32.99
List Price: $49.99
Usually ships in 24 hours
By: Sybex
Amazon Marketplace: 48
new & used starting at $1.13
|
Buy at Amazon.com
|
Browse similar items by category:
Subjects -> Computers & Internet -> Certification Central -> Publisher -> Sybex
Subjects -> Computers & Internet -> Certification Central -> General
Subjects -> Computers & Internet -> Certification Central -> General AAS
Customer Reviews:
Total reviews: 3
Average rating: 3.5 of 5
A good preparation tool 4 out of 5 stars.
6 of 6 people found this review helpful.
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.
Editorial Review:
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.