|
by: Gavin JT Powell
List Price: $73.95Amazon.com's Price: $57.98 You Save: $15.97 (22%)Prices subject to change. Availability: Usually ships in 24 hours
Binding: Paperback
Dewey Decimal Number: 005
EAN: 9781555583057
ISBN: 1555583059
Label: Digital Press
Manufacturer: Digital Press
Number Of Items: 1
Number Of Pages: 544
Publication Date: December 22, 2003
Publisher: Digital Press
Sales Rank: 670279
Studio: Digital Press
Related Items:
Editorial Review:
Product Description:
There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration.
A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model.
Poorly written SQL code is often a culprit of performance problems and is expensive to rectify. However, tuning of SQL code is generally cheaper than changing the data model. SQL code tends to be contained inside independent blocks within applications or stored procedures.
Physical database tuning involves hardware resource usage, networking and various other Oracle things such as configuration and file distribution. Physical configuration is often a culprit of poor performance where Oracle is installed with defaults, and never altered by an expert.
Customer Reviews
Average Rating: 
Rating:  - underwhelmed
I am sure this guy knows his stuff, but it sure didn't come through very clearly. I would recommend a re-write with a new editor. There didn't seem to be a smooth transistion from introduction to the deep dive. Examples are explanations of checkpoint and latches.
By the way, the Index was horrible.
Maybe it is because he came from a dev environment as opposed to systems viewpoint. Anyway, not impressed with the overall presentation, which is a shame because it looks ... Read More
Rating:  - Very beginner's book
Before you buying it, please do take a look at the content pages. I believe every oracle dba who has over 1 year experience will be disappointed by those basic topics.
I would say, it might be a good book for trainning java developers, who have to write some embeded SQL codes.
Rating:  - Excellent book for new DBA's and good review book for the experienced
This is an excellent book for the new someone new to performance tuning. It gives very clear and simple explanation to the approach to PT. It is a good mix of technical scripts and verbose. The author is not too chatty neither he is boring. He brings out complex ideas in a simple way without too much of mathematical jargons. Definately recommended.
Update
=======
Well with all the tuning books available now... I would say this in not the top of the line performance book. ... Read More
Rating: - Vague and primitive
I have read this book and regrettably found it primitive and obscure. The author seems to have a bit of Java and development knowledge but not much of knowledge as a designer or DBA. His explanation of various items are rudimentary and shallow. When he talks about Cost based optimizer and the way it is used in Oracle, it is pretty clear to me that the author is very light in understanding the basic concepts. There are also a lot of technical errors in describing various constructs and utilities. I think ... Read More
Rating: - Worth the Investment
In his book "Oracle High Performance Tuning for 9i and 10g", Mr Powell has provided a methodical framework for addressing a complex challenge by covering all three logical aspects - data model, SQL and physical - of tuning in highly readable and practical format.
The difficulty in Oracle tuning stems from the fact that the process typically involves many skill sets - from data modeling to application development to database and network administration. In between, throw in the quintessential ... Read More
|
