|
 |
|
 |
 |
Oracle Performance Tuning and Optimization
|
by Edward Whalen
Sales Rank: 3423660
|
$0.80
At Amazon
|
|
Paperback: 720 pages
Publisher: Sams Publishing; Pap/Cdr edition April 1996
Language: English
ISBN-10: 067230886X
ISBN-13: 978-0672308864
Product Dimensions:
9.2 x 7.5 x 1.8 inches
Shipping Weight: 3.1 pounds
Publisher Description
As today's IS departments move toward Client/Server environments, the demand and need for RDBMS performance tuning rapidly increases. This book is written to address that need and provide system administrators the detailed information they need to effectively maintain an efficient RDBMS. - Shows readers how to design an efficient client/server environment
- Teaches ways to fine tune legacy systems
- CD-ROM includes source code from the book and various powerful utilities
Customer Reviews & Comments
This book contains so little information about Oracle - it could have been called "AnyOtherDatabase Performance Tuning and Optimization". The author presumably has been doing a lot of database tuning and optimization, but only from the administrator side. When an application is already deployed and you need to speed it up without touching the application itself, there is not much you can do - beef up the I/O subsystem, memory and the CPU power. In different variations this is repeated many times throughout the book, like "so, you need to optimize OLTP system ? throw in I/O, memory and CPUs", "so, you need to optimize a DSS ? throw in I/O, memory and CPUs"... And so on and so forth. Parameter tweaking is considered and the book contains a list of may be a hundred Oracle configuration parameters, each accompanied with an explanation few lines long. But then, the book has been published in 1996, many changes have been introduced since thus greatly minimizing this reference's value. 40 little chapters contain so many irrelevant details about different operating systems and TPC benchmarks and CISC vs. RISC CPUs and RAIDs explained and whatnot, but so little about Oracle as such - it's boring. Besides, there are things that are confusing at best. When explaining BLOBs, the author doesn't even mention the fact that they are stored separately and access to those separate segments is not cached at all. Instead, he treats BLOBs as though they were just huge VARCHARS, saying [quote] In the other types of database applications you have seen, it is unlikely that a single record is larger than a data block. With BLOBs, it is certain that a single record will span many data blocks. [/quote] and [quote] In a BLOB system, increasing the database block size greatly improves performance. [...] having a larger block size brings more of the rows into the SGA at once. Having these additional rows in the SGA can benefit you because you will be using them. [/quote] Perhaps, I'm missing something, or Oracle has changed but this is at least misleading. Oh, it also contains the infamous "problem solving algorithm": "if you have a problem you should determine the cause and try to fix it, then repeat until the problem is solved". Duh ! A sure tell-tale of a lack of real information. Anyhow, not worth reading.
Comment | Permalink |
(Report this)
|
Oracle Performance Tuning and Optimization
Available from Amazon
Price: $0.80
| |
|
|
|
|
