View Larger Image	Thomas Kyte Oracle Press, Paperback, Published August 2003, 848 pages, ISBN 0072230657
	List Price: $59.99 Our Price: $35.95 You Save: $24.04 (40% Off)
	Availability: Out-Of-Stock

Write a Review and tell the world about this title!

People who purchase this book frequently purchase:

• Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions; Thomas Kyte, $24.95, 50% Off!
• Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning; Kirtikumar Deshpande, et al, $31.50, 41% Off!
• Oracle Database 10g: The Complete Reference; Kevin Loney, $44.95, 39% Off!
• Oracle Database 10g PL/SQL Programming; Scott Urman, et al, $33.50, 39% Off!

• Databases : Oracle

• Oracle Press

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. 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

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. 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).

Table of Contents

Aug 5, 2005     R. M. Menon from CA, USA
A must-buy!
Tom kyte is the foremost authority on Oracle and his books in general are more than your money's worth. This is another one of his gems. I loved all the chapters (Esp. the chapters 5 through 9.) His writing style is clear and his examples are thorough. The best part are his proof points which showcase the power of simple experiments that eventually the reader can carry out herself. His web site http://asktom.oracle.com is also very highly recommended. Buy this book and you won't regret it.

Jan 15, 2004     Cary Millsap from Dallas, Texas
One of the FIRST BOOKS an Oracle DBA or developer needs
Taking advice from Oracle "experts" has always been risky. Most "expert advice" about Oracle performance in books today is blatantly wrong. Even advice that is correct today is at risk of becoming wrong with your next Oracle patch.

Tom Kyte's contribution to the professional community is completely different and eminently more valuable. "Effective Oracle by Design" teaches you to TEST instead of perpetuating your reliance upon unsubstantiated tips and techniques. This book is practical because it TEACHES you, by EXAMPLE, HOW to TEST. For example, it illustrates the practical details of constructing a testing environment. It opens dozens of critical questions for which Oracle practitioners need answers. For each question, Tom shows you how to construct an elegant test case to reveal the truth about some behavior of an Oracle system.

With this book the attentive reader learns two skills that are absolutely mandatory for any Oracle architect, performance analyst, DBA, or developer. You learn how to find the truth. And you learn how to create compelling evidence that will convince others of that truth. With this book, you can learn how to inspire colleagues, managers, and vendors to improve your system the way you say to improve it. And with this book, you can learn how to make sure that when people DO follow your advice, you won't have embarrassed yourself.

Nov 22, 2003     Malcolm from Boston,Ma
Effective Oracle by Design is a winner.
Tom Kyte has managed to write a highly readable book that will prove invaluable to the data architect, developer, and DBA. I personally like detailed empirical examples. This book makes extensive use of emprical information by walking us through Oracle tuning scenarios, design enhancements, and coding tips. It truly bridges the chasm between the Oracle documentation and what I need as DBA to get a handle on my database. You would think that a book of this scope would lose effectiveness as a reference, but not so. I find myself referring to this book more than the web for some of the most arcane questions (setting 10053 events for example). I started my career working with DB2 in the early 80s and moved on to Oracle in 1992. Since then Ive been looking for an Oracle equivalent to IBM's excellent Redbooks -- books written by technologists that consolidate and present detailed technical information in a clear, and concise manner. This book is our Oracle equivalent.

Oct 4, 2003     Dave Slotnick from London U. K.
Loosing its lustre
Many love Tom Kyte for through Oracle examples, but the organisation of this book is wanting and the examples are long-winded and obtuse. I trust the author and do not need long-winded code example to prove a point. Content is good, but the same book could have been done with half the pages.

Forgot your password? FAQs Shipping Options Returns Your Orders Your Account