[ Read Online Oracle High Performance Tuning for 9i and 10g Î social-welfare PDF ] by Gavin JT Powell ☆ izmirescort.pro
[ Read Online Oracle High Performance Tuning for 9i and 10g Î social-welfare PDF ] by Gavin JT Powell ☆ 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 Its good but if I could I would give 3.
5 stars out of 5 It is a good book From it, I learned knowledge deeply.
Hope people benefited from this book 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 queueing theory, hardware advances, models in concrete, domain knowledge, etc and it can really stretch both the depth and breadth of your team s or your capabilities and interests Mr Powell was able to address most of these issues through invaluable pointers throughout the book and kept me interested to explore the pages.
I was thus fortunate to find this book during the middle of a 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 this book will be useful for newcomers but hardly is a High Performance Tuning book as the book s title says There are much better books around Any of Tom Kyte s books will leave this book standing.
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 like he has paid his dues and has something to contribute.
It is well written, helpful and very easy to follow A must.
There Are Three Parts To Tuning An Oracle Database Data Modeling, SQL Code Tuning And Physical Database ConfigurationA 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 ProceduresPhysical 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 Includes All Three Aspects Of Oracle Database Tuning Data Model Tuning, SQL PL SQL Code Tuning, Physical Plus Configuration Tuning Contains Experienced Guidance And Real World Examples Using Large Datasets Emphasizes Development As Opposed To Operating System Perspective