Tom Kyte of Oracle Magazine’s “Ask Tom” column has written the definitive guide to designing and building high-performance, scalable Oracle applications. The book covers schema design, SQL and PL/SQL, tables and indexes, and much more. From the exclusive publisher of Oracle Press books, this is a must-have resource for all Oracle developers and DBAs.
From the Back Cover
Streamline Application Development with Help from an Oracle Expert
Oracle guru Tom Kyte has written the definitive guide to designing and building high-performance, scalable Oracle applications. Providing detailed code examples throughout, Tom teaches proactive and efficient methods to develop and tune Oracle applications that fully exploit the database. You'll learn how to maximize the built-in functionality of the tools you're using in order to achieve the best results possible. From the exclusive publisher of Oracle Press books, this is a must-have resource for all Oracle developers and DBAs.
- Use SQL*Plus, TKPROF, STATSPACK, JDeveloper, and other tools
- Take advantage of Oracle's scalable architectural implementations
- Handle administration with SPFILES, Oracle Managed Files, and Automatic Segment Space Management
- Use archivelog mode, RMAN, and Data Guard for bulletproof backup and recovery
- Improve statement processing by using bind variables and reducing parsing
- Make full use of the Cost Based Optimizer (CBO)
- Choose data structures that result in effectively designed schemas
- Write efficient SQL statements and high-performance PL/SQL code
- Learn invaluable techniques from an Oracle insider
Series: Oracle Press
Paperback: 688 pages
Publisher: McGraw-Hill Education; 1st edition (September 12, 2003)
Language: English
Product Dimensions: 7.1 x 1 x 9.1 inches
Shipping Weight: 3 pounds
Reviews
"My only complaint was that the book was just too short. As I got closer to the end I could feel the disappointment grow as I knew I would finish soon. The book is that good. I promise that halfway through the book your confidence in Oracle and in yourself as an Oracle developer will improve. If you have his first book Expert:One on One you will want this book. If you get this book you will want his first. They are filled with Oracle solutions and facts, not myths, not silly rules of thumb, not opinions. Backed up with examples and bencharked test results."
- A. C.
"If you've ever looked over anything about the Oracle database, you've likely come across the name of this book's author, Tom Kyte. Like his articles, this book is designed to help the reader get the most out of the Oracle database. This is an excellent book for understanding the inner workings of Oracle database engine.
The theme of this book is that by understanding how Oracle works, you can write highly scalable, high performing applications. If you don't know how your database works, you'll always be frustrated and less likely to have a well-performing database. The author is absolutely serious about this point and drives it home by dispelling many myths surrounding Oracle (e.g. partitioning is always better than not partitioning). By discussing these technical details, the reader is equipped with the knowledge to build an application designed to perform.
If you're looking for a book to learn how to write effective PL/SQL, then you might be slightly disappointed by this book. While there is a great chapter on the Oracle specifics of writing SQL, this book is designed to architecting the entire database, not just the SQL statements run inside the database. I think this a very effective (and sadly novel) approach to database design. There are all too many books out there which concentrate on writing fast SQL, with little regard for the underlying data design and structure.
This is by far the best book I have read on understanding how Oracle works. The author covers everything from design to disaster recovery. If you are responsible for maintaining an Oracle database, I would highly recommend this book."
- Ueberhund
"A great book written by a great author. If you really want to become a true professional in database systems, this is for sure one of the books you should read. It's well organized and clear, and extremely heplful for your professional knowledge"
- Giampaolo Capelli
"While this book was written a few years ago the basic information in it is still outstanding. I was able to apply concepts taught in chapter 1 to my system with good results. Each chapter is packed with inside information on how the Oracle system really works.
I highly recommend this book to all Oracle developers and DBAs."
- Glenn D. Miller
"This book now lives permanently in my laptop bag (despite how heavy it is). Tom really goes out of his way to show you why you should do things certain ways, and he proves what he's saying through every part of the book with actual test cases. Applying some of the concepts from this book gave my application a 4x's performance boost, so my customers are much happier already. The biggest things you learn are to benchmark everything and not to assume anything about Oracle without testing it. The book really opened my eyes and made me realize as an application developer how much I was guessing about Oracle without actually knowing."
- Jasond
...
...
About the Author
Thomas Kyte (Leesburg, VA) is among the most knowledgeable Oracle professionals in the world. He is Vice President in the Oracle Government, Education, and Health group and is the “Tom” behind the Ask Tom column in Oracle Magazine and the online forum at http://asktom.oracle.com. He has answered thousands of technical questions that sparked the creation of this book and is the author of Expert One-on-One Oracle (Wrox).
No comments:
Post a Comment