Oracle SQL High-Performance Tuning (2nd Edition) |
|
|
|
| Title: | Oracle SQL High-Performance Tuning (2nd Edition) |
| Author: | Guy Harrison |
| Publisher: | Prentice Hall PTR |
| Type: | Book / Paperback |
| Publication Date: | 08 January, 2001 |
| ISBN / ISBN-13: | 0130123811 / 9780130123817 |
| List Price: | $54.99 |
| You Save: | $17.88 |
| Amazon Price: | $37.11 |
|
This book is also available, brand-new, from 3rd-party marketplace sellers at Amazon.com, from $19.50.
|
The HTML code below can be pasted onto your web-site, your MySpace page, or blog - or any number of similar places - to create a link to this page:
If, instead of a text link, you'd like to create a link to this page which will display the book cover, if it's available, then the code below will do exactly that:
Check for the same book at these other US book sites:
• [ Abebooks ]
• [ Alibris ]
• [ Barnes & Noble ]
• [ Half.com ]
• [ Powells ]
… or check UK bookstores
|
Editorial Review / Publisher's Information:
Product Description
Offers a way to increase the performance of Oracle and SQL by tuning and optimizing both. Provides a single source for guidance on Oracle 8/8i SQL and P/SQL tuning. Contains specific recommendations, case studies, and benchmarks, covering everything from designing applications to repairing SQL code. Softcover. Previous edition: c1997. DLC: Oracle (Computer file).
|
Other Items You May Enjoy:
Browse Books From These Related Subjects:
Customer Reviews:
• A Must For Dbas And Plus For Developers, One Of The Best
15 December, 2002
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.
- Amazon Customer Review
• Fantastics Oracle Sql Tuning Book!
28 February, 2006
What a perfect book describing nearly all the method to optimize performance(e.g. index, cluster, explain plan trace, tuning table access and joins, using hints etc) for developers. It provides a clear and detail explanation and somtimes illustration on each optimization methods. The book was written in plain English and hence can be easily understood.
- Amazon Customer Review
• Great Tuning Book
14 November, 2001
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!
- Amazon Customer Review
|
