 | |
| |
Oracle SQL High-Performance Tuning (2nd Edition)
 |
Author: Guy Harrison
List Price: $54.99
Our Price: Click to see the latest and low price
ISBN: 0130123811
Publisher: Prentice Hall PTR (29 December, 2000)
Edition: Paperback
Sales Rank: 31,500
Average Customer Rating: 4.55 out of 5
|
Customer ReviewsRating: 5 out of 5
There is no other book on SQL Tuning
I have read this book cover to cover and more. I have been using this book since 1998 and I still have to say it is good book.It is one of the Oracle Classics. It is a little outdated. If you look at the cover it clearly states it covers to oracle 8i. If you still have 8i databases this is a good book. if you are using 9i and cost based optimization it is still useful but it will not pick up on some of the newer fetures of the CBO. If you use Rule based optimization(RBO) than it is a good book. I had actually used this book as a teaching guide when I use to teach SQL Tuning for an application software company who uses oracle database. I look forward to when the revised version does ship.
Rating: 5 out of 5
A must for DBAs and plus for developers, One of the Best
Oracle performance tuning has become more critical for dba's and developers to master as database are approaching 10 plus terabytes. Some of the newest concepts have really improved performance and speed in which data can be found and retrieved. Some of this concepts include function based indexes, bitmap index, partitioning, parallel queries, and optimization hints. The basic starting permise is to make sure your system has enough memory and hardware processing speed. Two branches of thought have emerged when focusing on performance improvement: improved system tuning and improved Optimizer decisions. The Oracle DBA must become familar with how to tune operating system performance and database performance. Some of the valuable indicators are data cache hit ratios, Disk I/O activity, library cache, buffer hit ratios, and shared pool memory. Various views, scripts, tools, and data tables give the DBA insight into how the database is performing. It is safe to assume the database will grow and performance will vary from time to time. By monitoring and adjusting parameters the Oracle database can achieve relative performance to growth. If performance drops add more hardware or change object schema designs to reflect the data loads. Oracle has offered two amazing database architectures: dedicated server and Multiple Transaction Server. Each architecture has its advantages. From a developer's view performance of the schema objects are important, such as, tables, views, indexes, and PL/SQL. The Optimizer evaluates system statistics to decide how to retrieve data, whether it be by full table scans, index range scans, or join table sorts. Each type of index should be evaluated: single indexes, multiple field indexes, partitioned indexes, bitmap indexes, and function indexes. In some cases, it will make sense to use bitmap indexes for data that is relatively static. In other cases it will make sense to use function based indexes where data search on alpha data is complex. Yet in another case it will make sense to use a partitioned index where the data tables have been spread over multiple partition sectors and datafiles. Sometimes usage of indexes is not need and full tables scans are better. The developer uses the optimizer execution plan to see how the data will be retrieved. At first the execution plan may seem confusing, but understanding Oracle database architecture will make the plan readable. I've personally found that keeping the database statistic current and using oracle hints (ordered,index,and parallel) provided the best return on my performance improvements. Table joins is another critical area of performance tuning to grasp. There are a number of join types: nested loops, sort merge, cluster, hash, and index. The optimizer decides which type of join to use based on statistics and available indexes and constraints. The helpful advice, I can give you for purchasing this book is that there are PL/SQL optimization techniques to consider. One I found helpful was to use Packaged procedure calls from triggers rather than putting the PL/SQL code to execute in the trigger. I recommend adding this book to your library.
Rating: 5 out of 5
Great tuning book
I had a nagging and peculiar performance problem with a specific query involving a quirk in the Oracle optimizer which I had been trying to solve on and off for months. With the help of this book, I resolved the problem. It has a level of detail in query optimization way beyond other "highly recommended" books. The explanations are clear, *complete* (completeness was lacking in the other books), and easy and enjoyable to read. I finally have the understanding of these Oracle internals that I have been seeking!
Similar Products
· Oracle High-Performance SQL Tuning
· Oracle SQL Tuning Pocket Reference
· Effective Oracle by Design (Osborne ORACLE Press Series)
· Optimizing Oracle Performance
· Expert One-on-One Oracle
| | | | | |
| |
