OCP Oracle9i Database: Performance Tuning Exam Guide

  Author:    Charles Pack
  ISBN:    0072195274
  Sales Rank:    515109
  Published:    2002-03-27
  Publisher:    McGraw-Hill Osborne Media
  # Pages:    470
  Binding:    Hardcover
  Avg. Rating:    5.0 based on 10 reviews
  Used Offers:    9 from $16.07
  Amazon Price:    $32.99
  (Data above last updated:  2008-11-29 05:56:27 EST)
  
  
Sort customer reviews by:
  
Show All Reviews on Page      Hide All Reviews on Page
   
  
OCP Oracle9i Database: Performance Tuning Exam Guide
  
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.
                  Reader Reviews 1 - 10 of 10                 
  
  
Review
Date
Review
Rating(5 High)
Review
Helpful
to:
Customer Review Reviewer
Info
Permanent
Link
Reader Reviews Below Sorted by Newest First
11-10-06 5 (NA)
(Hide Review...)  Excellent Exam Guide
Reviewer Permalink
I used this book to study for the exam. The explanations on this book is very good. The only fault on this book is the level of the questions. The questions on this book are very weak compared with the real exam. So, keep in mind that to think to take the exam, you will need to have a score upper than 90% on the test of the book, to have a chance to pass on the real exam. I bought the SelfTest too and there is the same problem with the questions. But, the key is: you need to understand the concepts behind the questions. If you understand that, you will not have problems to pass on the exam.

I had take the test last week and a I pass on the exam with 82% score. To study I use this book and the Self Test Software.
(Review Data Last Updated: 2008-11-30 06:55:01 EST)
10-04-04 4 5\5
(Hide Review...)  Good Exam Guide
Reviewer Permalink
I used this book to study for the Performance Tuning Exam. This book covers all the objectives of the exam in much more organized way. The chapters reflect the contents of the checklist designed by oracle. Study the chapters carefully before taking the practice exams. Concerning the practices exam itself, it has some mistakes. Some of the answers to the questions are wrong but if you understand the material you will notice those mistakes. Or if you want to clear any doubt you can also check the oracle online manual.
On the exam, expect a lot of questions concerning the views, latch contentions, and some initializations parameters.
My suggestion to you is if you want to maximize your chance you can buy the sybex study guide which is also good. Both books are good for the exam except that I found the Oracle press book more organized. I will definitely recommend them if you are planning to take the performance tuning exam.
(Review Data Last Updated: 2006-11-10 12:19:06 EST)
09-20-02 4 2\6
(Hide Review...)  Good Book - Could have done better
Reviewer Permalink
Read this book - took the Beta exam failed by 6 wrong answers. Second attempt passed - thanks now an OCP Certified. The explanations are good. Need more explanation, the new feature and their effectiveness on the 9i with respect to performance tuning. This would have helped use this book for standard reference for performance tuning 9i. I don't like to keep lot of books around. Now I have to get rid of this and get a book for 9i tuning reference purposes.
(Review Data Last Updated: 2006-07-07 11:08:40 EST)
09-16-02 4 5\5
(Hide Review...)  A good preparation tool
Reviewer Permalink
My purpose was to pass the exam and I have done it using this book but also the Sybex book by J. Johnson.
Both of them are very good books and are complementary.

Pros:
- very well structured and very clear
- the exam-based questions are representative
- the level of detail for package procedures is good

Cons:
- some answers to exam questions I had can't be found in the book
- there are typing mistakes in capital letters commands

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.

(Review Data Last Updated: 2006-07-07 11:08:40 EST)
09-14-02 5 6\6
(Hide Review...)  Oracle Press better than Sybex for Performance Tuning
Reviewer Permalink
I bought the Sybex book. One of my colleagues bought this Oracle Press book. I read both and passed the test with plenty to spare. For the Oracle9i Performance Tuning Exam, I strongly recommend Oracle Press over Sybex. If you are buying just one, get the Oracle Press book. In particular, the Oracle Press sample tests and CD-ROM tests are much closer to the actual exam than Sybex.
(Review Data Last Updated: 2006-07-07 11:08:40 EST)
09-10-02 4 4\4
(Hide Review...)  Good book, but use the Oracle documentation as well..
Reviewer Permalink
This book does exactly what it sets out to do - prepare you for the OCP 9i Performance Tuning exam. However, be warned - it is not a comprehensive tuning manual, nor does it have in-depth explanations of tuning concepts. For this reason I would recommend supplementing this guide with the following books from the Oracle Docs: 1) Oracle 9i Database Performance Guide and Reference, 2) Oracle 9i Database Administrator's Guide. I used these two books and Mr. Pack's guide to clear the exam quite handily.
(Review Data Last Updated: 2006-07-07 11:08:40 EST)
06-03-02 5 4\5
(Hide Review...)  Well Written and Organized
Reviewer Permalink
A strong showing of the Oracle 9i features for performance tuning, and a well written guide for the OCP exam. In addition, this book would be a good source for tuning tips and techniques.
(Review Data Last Updated: 2006-07-07 11:08:40 EST)
05-28-02 5 27\29
(Hide Review...)  Best in the series and very well written
Reviewer Permalink
This book is not only an excellent study guide for both the OCP classes and the exam, but a wonderfully written explanation of the complexities of performance and tuning. Of all of the material I've read on this subject [for training and examination purposes], nothing has made more sense or been more enlightening than this book.

All of the key elements of performance tuning are covered, the illustrations are excellent and aid in understanding, and the drills, self tests and practice questions have been a tremendous help.

(Review Data Last Updated: 2006-07-07 11:08:40 EST)
05-27-02 5 4\4
(Hide Review...)  Mr. Pack, good Show.
Reviewer Permalink
Mr. Pack has come through on his effort to prepare the Oracle9i OCP test taker for the performance tuning exam. His writing is a model of prose, and his examples are on the spot. In this book (I like the fact that it's hard cover) his examples are clear and concise. He follows the objectives of the Performance tuning exams to a tee, yet the book remains usable long after the exam has been put to rest. Indeed, I'm certain that my copy will sit on top of my bookcase here at work, dog eared and well worn, for some time to come.
(Review Data Last Updated: 2006-07-07 11:08:40 EST)
05-06-02 5 4\4
(Hide Review...)  best of the series
Reviewer Permalink
This book is an excellent guide to performance tuning. The errors that plagued the first two books in the series are just not present in this one. This book does a great job of showing the statspack reports alongside the standard queries to the v$ tables in the event you don't have access to statspack. The author just does an amazing job of explaining everything and presenting the material in an order that makes sense.

Examples are abundant and useful. Many of them I am using for our production databases as I work through the book.

The book also does an excellent job of not only talking about what the reports can show you, but it also goes into all the possible causes and makes resolution recommendations for all the problems that show up in the statspack reports and queries. As a beta tester for performance tuning who hasn't yet taking the exam, I feel well prepared for my upcoming exam date.

(Review Data Last Updated: 2006-07-07 11:08:40 EST)
  
                  Reader Reviews 1 - 10 of 10                 
  
  
  
  
  
  

Because the data used to generate this site come from outside sources, VeryWellSaid.com cannot guarantee the completeness or accuracy of the data.
Search VeryWellSaid™
Google
Web VeryWellSaid™
New subjects are added every week.
View Subjects Below by:
* Top Selling
 (click category name, left)
* Top-Rated Top Sellers
 (click 'Top Rated', right)
In the news...  
Dubai\UAE Top Rated
Influenza\Bird Flu Top Rated
Iraq Top Rated
Supreme Court Top Rated
All Books Top Rated
Arts Top Rated
Photography Top Rated
Digital Photography Top Rated
Digital Cameras Top Rated
Biography Top Rated
Business Top Rated
Management Top Rated
Marketing Top Rated
Sales Top Rated
Stocks Top Rated
Bonds Top Rated
Real Estate Top Rated
Trading Top Rated
Commodities Trading Top Rated
Time Management Top Rated
Starting A Business Top Rated
Children's Top Rated
Comics Top Rated
Computers Top Rated
PC Top Rated
Mac Top Rated
Programming Top Rated
Design Patterns Top Rated
.Net Top Rated
C# Top Rated
Vb.Net Top Rated
Asp.Net Top Rated
Java Top Rated
Python Top Rated
PHP Top Rated
Perl Top Rated
Javascript Top Rated
Ajax Top Rated
CSS Top Rated
Open Source Top Rated
SQL Top Rated
Databases Top Rated
Oracle Top Rated
MySql Top Rated
Sql Server Top Rated
IIS Top Rated
Apache Top Rated
Linux Top Rated
Windows Server Top Rated
Project Management Top Rated
HTML Top Rated
UML Top Rated
IT Certifications Top Rated
Cisco Certifications Top Rated
MCSE Top Rated
MCSD Top Rated
Cooking Top Rated
Italian Cooking Top Rated
Vegetarian Cooking Top Rated
Wine Top Rated
Engineering Top Rated
Entertainment Top Rated
Health Top Rated
Nutrition Top Rated
Dieting Top Rated
Sex Top Rated
History Top Rated
Military History Top Rated
British History Top Rated
Middle East History Top Rated
Land Battles Top Rated
Naval Warfare Top Rated
Air Warfare Top Rated
9/11 Top Rated
Terrorism Top Rated
Home Top Rated
Mortgage\Home Equity Loan Top Rated
Cars Top Rated
Car Buying Top Rated
Sports Cars Top Rated
Cat Top Rated
Humor Top Rated
Horror Top Rated
Law Top Rated
IP Law Top Rated
Legal History Top Rated
Fiction Top Rated
Oprah's Book Club Top Rated
Medicine Top Rated
Cancer Top Rated
Stroke Top Rated
Heart Disease Top Rated
Fertility Top Rated
Diabetes Top Rated
Pharmacology Top Rated
Back Problems Top Rated
Menopause Top Rated
Thyroid Top Rated
Pain Top Rated
Organic Chemistry Top Rated
Immune System Top Rated
Mystery Top Rated
Nonfiction Top Rated
Outdoors Top Rated
Running Top Rated
Radio Control Models Top Rated
Guns Top Rated
Parenting Top Rated
Divorce Top Rated
Professional Top Rated
Reference Top Rated
Religion Top Rated
Romance Top Rated
Science Top Rated
Physics Top Rated
Chemistry Top Rated
Astronomy Top Rated
Psychology Top Rated
Science Fiction Top Rated
Sports Top Rated
Teens Top Rated
Travel Top Rated
USA Top Rated
Europe Top Rated
France Top Rated
Italy Top Rated
England Top Rated
China Top Rated
All Books Arts Biography Click Here For An A-Z Index Of All 213 Best-Seller Subjects Business Children's Comics
Computers Cooking Engineering Entertainment Health History Home Horror Humor Law Fiction Medicine Mystery
Nonfiction Outdoors Parenting Professional Reference Religion Romance Science Sci-Fi Sports Teens Travel
In Association with Amazon.com

Cache miss
(not cached)