Join Amazon Prime and ship Two-Day for free and Overnight for $3.99. Already a member? Sign in.

 

or
Sign in to turn on 1-Click ordering.
 
 
More Buying Choices
39 used & new from $22.99

Have one to sell? Sell yours here
 
   
Effective Oracle by Design (Osborne ORACLE Press Series)
 
See larger image
 
Tell the Publisher!
I’d like to read this book on Kindle

Don’t have a Kindle? Get yours here.
 
  

Effective Oracle by Design (Osborne ORACLE Press Series) (Paperback)

by Thomas Kyte (Author)
4.9 out of 5 stars See all reviews (27 customer reviews)

List Price: $59.99
Price: $37.79 & this item ships for FREE with Super Saver Shipping. Details
You Save: $22.20 (37%)
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.

Want it delivered Tuesday, July 14? Choose One-Day Shipping at checkout. Details
21 new from $35.90 18 used from $22.99
Also Available in: List Price: Our Price: Other Offers:
Paperback (2nd) Order it used!

Frequently Bought Together

Effective Oracle by Design (Osborne ORACLE Press Series) + Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions + Cost-Based Oracle Fundamentals (Expert's Voice in Oracle) (v. 1)
Price For All Three: $109.49

Show availability and shipping details


Customers Who Bought This Item Also Bought

Cost-Based Oracle Fundamentals (Expert's Voice in Oracle) (v. 1)

Cost-Based Oracle Fundamentals (Expert's Voice in Oracle) (v. 1)

by Jonathan Lewis
4.6 out of 5 stars (27)  $40.21
Expert Oracle, Signature Edition Programming Techniques and Solutions for Oracle 7.3 through 8.1.7 (Expert One-On-One)

Expert Oracle, Signature Edition Programming Techniques and Solutions for Oracle 7.3 through 8.1.7 (Expert One-On-One)

by Thomas Kyte
4.8 out of 5 stars (77)  $72.00
Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)

Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)

by Richmond Shee
5.0 out of 5 stars (34)  $34.55
Oracle Database 10g Performance Tuning Tips & Techniques (Osborne ORACLE Press Series)

Oracle Database 10g Performance Tuning Tips & Techniques (Osborne ORACLE Press Series)

by Richard Niemiec
4.9 out of 5 stars (15)  $37.79
Optimizing Oracle Performance

Optimizing Oracle Performance

by Cary Millsap
4.7 out of 5 stars (27)  $25.51
Explore similar items

Editorial Reviews

Product Description
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


See all Editorial Reviews

Product Details

  • Paperback: 688 pages
  • Publisher: McGraw-Hill Osborne Media; 1st edition (August 21, 2003)
  • Language: English
  • ISBN-10: 0072230657
  • ISBN-13: 978-0072230659
  • Product Dimensions: 9.1 x 7.3 x 1.6 inches
  • Shipping Weight: 3 pounds (View shipping rates and policies)
  • Average Customer Review: 4.9 out of 5 stars See all reviews (27 customer reviews)
  • Amazon.com Sales Rank: #247,499 in Books (See Bestsellers in Books)

    Popular in this category: (What's this?)

    #85 in  Books > Computers & Internet > Databases > Relational Databases



Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
Check the boxes next to the tags you consider relevant or enter your own tags in the field below.

Your tags: Add your first tag
 
Help others find this product — tag it for Amazon search
No one has tagged this product for Amazon search yet. Why not be the first to suggest a search for which it should appear?

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

 

Customer Reviews

27 Reviews
5 star:
 (25)
4 star:
 (2)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
4.9 out of 5 stars (27 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

 
37 of 37 people found the following review helpful:
5.0 out of 5 stars Second best Oracle Book ever., October 13, 2003
By P. H PICOT (Haymarket, VA United States) - See all my reviews
(REAL NAME)   
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. Finally, if you just type in the examples, it will be a great series of lessons, and well worth doing, but there is much more to learn, and most of it is free. Tom points out Oracle documentation that you should read, that you must read to be really good, and all of it is on the net. If you read Tom's books, you will be better than a lot of developers or DBAs, but reading at least part of what Tom has read to get where he is, is the only way to get the most out of his books and Oracle. This book is written in such detail that it has a lot for every skill level, it is not over your head, and certainly not beneath you. You can use this book to do better work, starting from any level. Tom Kyte has one of the best grasps of Oracle, and he is certainly the best instructor, teaching many of Oracle's best developers. This is a chance to the same kind of instruction, at a much lower cost.
Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
21 of 22 people found the following review helpful:
5.0 out of 5 stars Another masterpiece from Thomas Kyte, September 14, 2003
By Alberto Dell'era (Milan, Italy) - See all my reviews
(REAL NAME)   
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! Well, this magic property comes straight from the Author's experience in answering thousands of technical question on his aforementioned web site, asked by Oracle developers and DBAs all around the world - so it's not surprising that the book is tuned with what people think, and need to know, about Oracle. I would say that this is a feature present only in Thomas Kyte's books, since there is simply no other place like asktom.

To sum up - this book and "Expert one-on-one: Oracle" are overall the best books about Oracle I've read, and I own more than 15 of them. I can't remember all the times that I've used the latter book in my work as an Oracle specialist, and I've already used a lot of things learnt from this book as well. I absolutely recommend both this and "Expert one-on-one: Oracle".

Comment Comment | Permalink | Was this review helpful to you? Yes No (Report this)



 
14 of 14 people found the following review helpful:
5.0 out of 5 stars Excellent Oracle design book, May 20, 2004
By ueberhund "ueberhund" (Salt Lake City, UT United States) - See all my reviews
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.

Comment Comment (1) | Permalink | Was this review helpful to you? Yes No (Report this)


Share your thoughts with other customers: Create your own review
 
 
 
Most Recent Customer Reviews

5.0 out of 5 stars Doesn't get any better....
I've been a Database guy for some 12 year now since graduating. I've worked on numerous large projects involving complex database problems. Read more
Published 10 months ago by Stevie

5.0 out of 5 stars Fabulous
the book will teach basic Oracle things and clear the misconcepts, myths and mis understanding prevailing amongst numerous Oracle users. Read more
Published 23 months ago by Mital Juthani

5.0 out of 5 stars If only all Oracle books were this good
This book delivers the clear insight before delving into intricate details on a good selection of topics that are critical to those concerned with deigning and implementating high... Read more
Published on March 13, 2007 by P. Gallagher

5.0 out of 5 stars Benchmark it..
Tom has done a great job at busting several myths related to performance tuning, SQL, Architechture etc.. Read more
Published on February 18, 2007 by Pavan Achanta

5.0 out of 5 stars Well-written and packed with useful information
I've been an Oracle developer for 12 years, and this is the best book on Oracle that I've read. No waffle, well laid out and it's packed with information and relevant examples. Read more
Published on January 3, 2007 by D. A. Frost

5.0 out of 5 stars Very handy
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... Read more
Published on November 9, 2006 by jasond

5.0 out of 5 stars Do read this book !!
This is very helpful, if you want to learn how to design a performance efficient system. I have suggestion for the readers of this book, that they should read concept guide to get... Read more
Published on March 10, 2006 by Muhammad Waqas

5.0 out of 5 stars A good reference of db design
Another great Kyte's book which is for database designer to learn how to design and build high performance db application. Read more
Published on February 28, 2006 by Wallace Chan

5.0 out of 5 stars Truly remarkable book
Thank you Mr.Kyte for taking the time to write this book.
I got the book less than 1 hr ago and was able to solve 3 of our most vexing production issues immediately with the... Read more
Published on December 14, 2005 by Bernard Antonuk

5.0 out of 5 stars must read for anyone using oracle technology
A must read for anyone who works with the Oracle Database.This book opened up new methods of testing, debugging and tools(jdeveloper) and others. Read more
Published on December 3, 2005 by MPV

Only search this product's reviews



Customer Discussions

 Beta (What's this?)
New! See all customer communities, and bookmark your communities to keep track of them.
This product's forum (0 discussions)
  Discussion Replies Latest Post
  No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
  [Cancel]


Active discussions in related forums
   


Product Information from the Amapedia Community

Beta (What's this?)


So You'd Like to...


Look for Similar Items by Category


SpaFeatures: Free Shipping

bath poof
Get free shipping on all SpaFeatures orders of $50 or more. See new items from SpaFeatures here.

Shop SpaFeatures now

 

Big Savings in Books

Bargain Books
Find great titles at fantastic prices in our Bargain Books Store.
 

Dive into Summer Reading

Summer Reading for Kids and Teens
Don't even think about hitting the beach without browsing the books in our Summer Reading Store. Discover bestsellers, paperback picks, beach reads, and more terrific titles all summer long.
 

Listen While You Work

Shop for job site radios
Listen to your favorite bands while you work. Check out durable job site radios in the Home Improvement Store.

Shop now

 

 

Feedback

If you need help or have a question for Customer Service, contact us.
 Would you like to update product info or give feedback on images?
Is there any other feedback you would like to provide?

Your comments can help make our site better for everyone.


Where's My Stuff?

Shipping & Returns

Need Help?

Your Recent History

  (What's this?)
You have no recently viewed items or searches.

After viewing product detail pages or search results, look here to find an easy way to navigate back to pages you are interested in.

Look to the right column to find helpful suggestions for your shopping session.

Continue shopping: Top Sellers
Paranoia
Paranoia by Joseph Finder
Glenn Beck's Common Sense
Finger Lickin' Fifteen
Finger Lickin' Fifteen by Janet Evanovich
My Soul to Lose
My Soul to Lose by Rachel Vincent
$0.00

Conditions of Use | Privacy Notice © 1996-2009, Amazon.com, Inc. or its affiliates