Search
 Databases

Tuning

Database Management Systems

SQL

PL & SQL

General

Data Warehousing

DBA

 
 
 
 
 
 
 
 
 
 
 
Home

Databases

SQL

Oracle Tuning: The Definitive Reference (Oracle in-Focus Series)

Oracle Tuning: The Definitive Reference (Oracle in-Focus Series)
Email a friendEmailView larger imageZoom

Oracle Tuning: The Definitive Reference (Oracle in-Focus Series)

 
SKU:  

In Stock
Availability:   Usually ships in 1-2 business days
Only 1 left in stock, order soon!
 
 

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.

 
Our Price: $180.94
 
 

Note: Item may be sold and shipped by another company. Learn more.


Product Details
Author:Alexey B. Danchenkov
Hardcover:640 pages
Publisher:Rampant Techpress
Publication Date:August 01, 2006
Language:English
ISBN:0974448621
Package Length:9.13 inches
Package Width:7.17 inches
Package Height:2.13 inches
Package Weight:3.7 pounds
Average Customer Rating: based on 11 reviews

Customer Reviews
Average Customer Review:3.5
Write an online review and share your thoughts with other customers.

3Useful for sit-down reading, not useful as reference  Sep 03, 2009
I own 5 or 6 Rampant books. I find across the board that they have nearly-useless indexes. Specifically, it is difficult to tell if the subject is covered at any depth, as there are no ranges (e.g., 445-450). Instead the index will say 445, 446, 450. I end up using the table of contents and wasting a lot of time.

Before I get slammed by comments ... This might seem like trivial matter, but compare the indexes in the O'Reilly books, which are much more useful.

(I used to write indexes professionally).

0 of 1 found the following review helpful:

4DB Specialist  Sep 05, 2008
Very good, enough internal tips, common sense tips etc. I have read those parts that are interesting for me like AWR/ASH and some tuning spots. I got some good ideas. I have done work over 15 years with Oracle and some other databases. For me this is proper book, specially AWR and ASH. Perhaps even more internal tips which are gained over years pro work would have been waited. Okey, consult must have something of his own, when visiting customer;)

22 of 24 found the following review helpful:

4Great but incomplete  Mar 26, 2008
It would be easy to criticize any book on such a big topic for being incomplete. The problem here is that this book leaves out essentials that the authors have to know and just didn't bother writing down. Here's an example. "The parameter named optimizer_index_cost_adj controls the CBO's propensity to favor index scans over full table scans." Well, that's great and it's something I needed to know. So what are the values and what do they mean? You'll have to go look that up on the web. This happens over and over and suggests to me that no one bothered to read the book critically.

Now I've had the book for a few days and it keeps getting worse - if I were writing my review now it would be at 3 stars and heading down toward 2. There are SO many mistakes. There are sentences with extra words in the middle - no one ever read this stuff. There are scripts that just don't work, that have SQL errors. There are pompous bits that don't say much strewn here and there. In spite of the book's apparent top-level organization, the chapters themselves are pieced together carelessly with very little development of any ideas. Bits of a given concept are referred to here and there with no attempt to tie them together. One chapter cites one value for an init parameter, another mentions a second value, but nowhere are all the values explained or compared. There's still a lot of information but some of it is hardly usable because it's incomplete, or wrong. Maybe one star....

To add insult, each script contains a warning that it can't be used for a commercial purpose without licensing it from these folks! Who on earth do they imagine is buying these books? Schoolkids? If the scripts worked this would be really sad, but as they don't it's not much of a loss.

I like to think that if I get one really good idea or strategy from a book it will pay for itself, but "Oracle Tuning: The Definitive Reference" is causing me to re-think that philosophy, because it's such hard work wading through all the mess.

In contrast, I'm reading Jonathan Lewis's book on the cost-based optimizer. It's lucid, coherent, well developed, and very usable. Even his old book on 8i is far more useful to me than Burleson!

1 of 2 found the following review helpful:

4A definitive reference  Oct 24, 2007
As someone who is working hard to learn the ins and outs of Oracle, I've acquired a fairly large number of books. It doesn't bother me to note that the authors stumble a little with the language and grammar as it's a logical conclusion that English, in today's world, isn't everyone's first language. I know the language; I want to learn how to make my Oracle database as efficient as possible. This book holds a tremendous amount of information and is well worth the cover price. I've tried the scripts, but I never took it to mean that "script" was short for "scripture" and I didn't buy a Tuning Bible looking for answers without having to do the work. I bought a Tuning Reference, and as such it's never more than an arm's length away.

4 of 5 found the following review helpful:

1Other wise good book spoiled by incorrect scripts  Sep 20, 2007
This is a well written and good book targeted for senior DBAs. I gained a very good understanding of the Automatic Workload Repository (AWR) reading this book. But there is a huge and fundamental flaw in many of the scripts used throughout the book. Let me explain this:
Most the tables in the AWR stores cumulative data for various Oracle statistics. If you think about it, it makes sense because Oracle can get the delta between two snapshots by doing subtraction. The scripts in this book does not consider this fact. I fail to understand how the authors can miss this point. Because of this the output of most of the scripts is wrong or meaningless. Of course, it is not a big deal to fix these scripts ourselves. But the fact that the authors missed this fundamental point annoys me and that is the reason for single star rating from me. I will be happy to be corrected if the authors (or some other oracle experts) can explain that scripts are indeed correct.

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 About UsContact Us
 
Web business powered by Amazon WebStore