Effective Oracle by Design (Oracle Press) and over one million other books are available for Amazon Kindle. Learn more
  • List Price: $62.00
  • Save: $24.68 (40%)
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
FREE Shipping on orders over $35.
Used: Very Good | Details
Sold by Jacobs Media
Condition: Used: Very Good
Comment: Slight wear on edges and covers; otherwise item is in very good condition.
Access codes and supplements are not guaranteed with used items.
Add to Cart
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Effective Oracle by Design (Osborne ORACLE Press Series) Paperback – August 22, 2003

ISBN-13: 978-0072230659 ISBN-10: 0072230657 Edition: 1st

Buy New
Price: $37.32
24 New from $19.76 29 Used from $0.01
Amazon Price New from Used from
"Please retry"
"Please retry"
$19.76 $0.01


Frequently Bought Together

Effective Oracle by Design (Osborne ORACLE Press Series) + Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions + Oracle Core: Essential Internals for DBAs and Developers (Expert's Voice in Databases)
Price for all three: $108.87

Buy the selected items together


Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Series: Oracle Press
  • Paperback: 688 pages
  • Publisher: McGraw-Hill Osborne Media; 1st edition (August 22, 2003)
  • Language: English
  • ISBN-10: 0072230657
  • ISBN-13: 978-0072230659
  • Product Dimensions: 9.3 x 7.3 x 1.7 inches
  • Shipping Weight: 3 pounds (View shipping rates and policies)
  • Average Customer Review: 4.9 out of 5 stars  See all reviews (30 customer reviews)
  • Amazon Best Sellers Rank: #803,030 in Books (See Top 100 in Books)

Editorial Reviews

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

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

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

4.9 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See all 30 customer reviews
I highly recommend this book to all Oracle developers and DBAs.
Glenn D. Miller
This book shows you every step, from setting up your environment, to tests that really work.
This is the best Oracle book I've ever read, and I've read a pile of them.

Most Helpful Customer Reviews

41 of 41 people found the following review helpful By P. H PICOT on October 13, 2003
Format: Paperback
Of course, the best Oracle book ever is "Expert One-on-One Oracle" also by Tom Kyte, but being second is still being a head and shoulders above any other Oracle book. Tom's books, both of them, really do show you how to be successful with Oracle. Again and again, chapter after chapter, he shows you how find the information, how to create packages, and how to test. If you did nothing but type in the examples he gives you on testing (they all work, by the way), you would easily justify buying both this book and dinner for Tom (which is not required). There are few books that boost your skills by a quantum measure, but this is one. Tom's emphasis on testing at a low level of development, is the only way to insure that you are not wasting money on a non scalable application. Most of us do not know how easy it is to do small-time and big-time bench marking, so it does not get done often enough. This book shows you every step, from setting up your environment, to tests that really work. There is nothing missing that would keep you from understanding what he is doing, why it is meaningful, and how you can do the same thing. Tom does not assume you have any particular knowledge, he shows you how, in a way that engineers of any level can follow. One thing the book does not do, is describe a huge project that Tom did. Books that do that are rarely much good for anything but the same project. What this book does do, is take the questions you might have about current topics relating to enterprise level applications, and work you through many iterations of the basic Oracle designs and tools you will need to be successful on any project, not just one he did.Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
21 of 22 people found the following review helpful By Alberto Dell'era on September 14, 2003
Format: Paperback
The previous work by the same author, "Expert one-on-one: Oracle", got an average of 5/5 stars and more than 50 reviews, which is of course an outstanding result for any book, but especially for books about Oracle, which aren't normally so well-received by the readers community (to say the least). Well, I'm sure that this book is going to get the same success.
Thomas Kyte is well known for being an excellent writer, and in fact the material is presented here in a clear, concise yet complete manner, and it's very easy to follow the discussion and reproduce the examples.

The examples themselves are one of the greatest strengths of this book, because they illustrate, and prove, the topics discussed (and so what is written is *reliable*, which is of course a fundamental property for any technical book, but a quality seldom found in other Oracle tomes). At the same time, the examples (written mostly in SQL and PL/SQL) teach you a lot about how to code appropriately (the Author being a well-known SQL guru), showing e.g. syntactic variations, useful Oracle-supplied packages, new Oracle extensions ... I strongly believe that in order to be a good developer you must be exposed to high quality code, and reading this book is an excellent way to achieve this (well, I learnt more about SQL and PL/SQL from Thomas Kyte's books than from other books dedicated exclusively to SQL and PL/SQL programming).
The book is also magic - it can read your mind. Yes, I had in store a couple of non-trivial questions to be asked on asktom.oracle.com, and I found the answers in the book!
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
15 of 15 people found the following review helpful By ueberhund VINE VOICE on May 20, 2004
Format: Paperback
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.
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Most Recent Customer Reviews