Buy new:
$39.59
FREE delivery: Friday, April 26
Ships from: Amazon.com
Sold by: Amazon.com
List Price: $73.00 Details

The List Price is the suggested retail price of a new product as provided by a manufacturer, supplier, or seller. Except for books, Amazon will display a List Price if the product was purchased by customers on Amazon or offered by other retailers at or above the List Price in at least the past 90 days. List prices may not necessarily reflect the product's prevailing market price.
Learn more
Save: $33.41 (46%)
FREE Returns
FREE delivery Friday, April 26. Order within 23 hrs 46 mins
In Stock
$$39.59 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$39.59
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Ships from
Amazon.com
Ships from
Amazon.com
Sold by
Amazon.com
Sold by
Amazon.com
Returns
Eligible for Return, Refund or Replacement within 30 days of receipt
Eligible for Return, Refund or Replacement within 30 days of receipt
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
Returns
Eligible for Return, Refund or Replacement within 30 days of receipt
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt.
Read full return policy
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Payment
Secure transaction
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
FREE delivery April 30 - May 6. Details
Or fastest delivery April 24 - 26. Details
Used: Good | Details
Sold by ThriftBooks-Atlanta
Condition: Used: Good
Comment: Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less
Access codes and supplements are not guaranteed with used items.
Amazon book clubs early access
Loading your book clubs
There was a problem loading your book clubs. Please try again.
Not in a club? Learn more
Amazon book clubs early access

Join or create book clubs

Choose books together

Track your books
Bring your club to Amazon Book Clubs, start a new book club and invite your friends to join, or find a club that’s right for you for free.
Explore Amazon Book Clubs
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the author

Thomas Kyte
Follow
Something went wrong. Please try your request again later.

Effective Oracle by Design (Osborne ORACLE Press Series) First Edition

by Thomas Kyte (Author)
4.5 4.5 out of 5 stars 45 ratings
See all formats and editions
{"desktop_buybox_group_1":[{"displayPrice":"$39.59","priceAmount":39.59,"currencySymbol":"$","integerValue":"39","decimalSeparator":".","fractionalValue":"59","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"VUaulBnUIoJaD20u1tpdfioocvMVms%2BsMKEVQTa7o2CR%2FLYmO6t6DEi3Nc%2BjtRUv8H%2FOpOiEXdRXerDkGpgicrDxTkrcshgZhUXiExYsJ9obLFXZJ4dDM4yHwdVD1qg58deatT2CX%2F0%3D","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"$6.90","priceAmount":6.90,"currencySymbol":"$","integerValue":"6","decimalSeparator":".","fractionalValue":"90","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"VUaulBnUIoJaD20u1tpdfioocvMVms%2Bs9U6B6TT7tfgC%2Ftfj2UpUic6DWk2qjb5E5bibSXYSel7CV0hM71Yw4CXh4hNg07W8LtAyHkQ6XdaQ75PyLiduM5ou%2F%2B9guR%2BP5Txmv388LIDUs%2FkWFF04BMuIoXIL3INZhED1F2fSXF4%3D","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.


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.
Previous page
  1. ISBN-10
    0072230657
  2. ISBN-13
    978-0072230659
  3. Edition
    First Edition
  4. Publisher
    McGraw Hill
  5. Publication date
    September 12, 2003
  6. Part of series
    Oracle Press
  7. Language
    English
  8. Dimensions
    7.1 x 1.67 x 9.1 inches
  9. Print length
    688 pages
  10. See all details
Next page
Amazon First Reads | Editors' picks at exclusive prices

Editorial Reviews

From the Publisher

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

From the Back Cover

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.


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

Product details

  • Publisher ‏ : ‎ McGraw Hill; First Edition (September 12, 2003)
  • Language ‏ : ‎ English
  • Paperback ‏ : ‎ 688 pages
  • ISBN-10 ‏ : ‎ 0072230657
  • ISBN-13 ‏ : ‎ 978-0072230659
  • Item Weight ‏ : ‎ 2.49 pounds
  • Dimensions ‏ : ‎ 7.1 x 1.67 x 9.1 inches
  • Customer Reviews:
    4.5 4.5 out of 5 stars 45 ratings

About the author

Follow authors to get new release updates, plus improved recommendations.
Thomas Kyte

Thomas Kyte

Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.

Discover more of the author’s books, see similar authors, read author blogs and more

Customer reviews

4.5 out of 5 stars
4.5 out of 5
45 global ratings

Top reviews from the United States

Monkey Boy
5.0 out of 5 stars A must read for DBAs
Reviewed in the United States on December 16, 2004
Verified Purchase
This is one of the best Oracle books I've ever read. The style is different from any book I've ever read. Most of the Oracle books are feature centric, while this (as the name implies) is more design centric. In addition to design, it is interesting to see his methodology for proving his assertions. So many times in my career, I've been asked questions about design, and I've had a hard time articiluating why it should be done one way and not another. Typically the alternative is so bizzare, I've never even considered why other than "its just not right". His explainations to the "make everything varchar2(4000)" and the "have the application do all the validations" scenarios made me laugh out loud. The ETL developer on one of my projects wanted to take that exact approach. I've also never read a book that went into such detail about the Cost Based Optimizer, which was very interesting.

Can't wait to get my hands on "one-on-one", I hope it's more of the same.
5 people found this helpful
Helpful
 Report
jasond
5.0 out of 5 stars Very handy
Reviewed in the United States on November 9, 2006
Verified Purchase
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.
One person found this helpful
Helpful
 Report
pratalife
5.0 out of 5 stars If only all Oracle books were this good
Reviewed in the United States on March 13, 2007
Verified Purchase
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 performance database solutions.

My only wish is that this book covered more ground, especially on newer or perhaps peripheral topics such as RAC, ASM, XMLDB, OCI/OCCI, DataGuard and so on.. but maybe that's asking too much from one book.

Classic Tom Kyte. Get it on your bookshelf today if you implement or support Oracle database solutions for a living.
2 people found this helpful
Helpful
 Report
Glenn D. Miller
5.0 out of 5 stars An outstanding read
Reviewed in the United States on August 27, 2009
Verified Purchase
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.
One person found this helpful
Helpful
 Report
Giampaolo Capelli
5.0 out of 5 stars great book
Reviewed in the United States on December 2, 2009
Verified Purchase
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
Helpful
 Report
Colin Nicholls
5.0 out of 5 stars Five Stars
Reviewed in the United States on July 18, 2016
Verified Purchase
Work in Oracle? Get this book. I wish I'd obtained a copy several years ago.
Helpful
 Report
Jaewoo Kim
4.0 out of 5 stars Very wordy and informative
Reviewed in the United States on May 10, 2005
Verified Purchase
The author is a well known Oracle expert and this book is certainly informative. If you are experienced with Oracle performance tuning, or have read few other Oracle performance books, like I have, then this book doesn't offer much new. The scripts and examples in this book, however, are top notch and well worth emulating.

The publishers of books like this demand that the author write a minimum of XXX pages to justify an exorbitant cost of a book. Unfortunately, most people still believe the price of a book is determined principally by its thickness. Hence, we have books like this which could have been twice as good if it was condensed in less than 300 pages.
Helpful
 Report
Chris Duggin
5.0 out of 5 stars Exceeds expectations.
Reviewed in the United States on May 10, 2014
Verified Purchase
Book and was in better condition than expected. Quality is near new. I'm happy how much I saved with this second hand.
Helpful
 Report

Top reviews from other countries

Translate all reviews to English
Akash
5.0 out of 5 stars Best book for Oracle DB
Reviewed in India on May 10, 2019
Verified Purchase
Great great book. You learn the concepts. Also, the book points to many guides for more knowledge on some topics. Must have for anyone working with Oracle database. Get your copy now.
Report
Abrantes Araújo Silva Filho
5.0 out of 5 stars Esse é um dos livros que eu queria ter lido há 10 anos atrás!
Reviewed in Brazil on June 11, 2014
Verified Purchase
Existem alguns livros que eu gostaria de ter lido há 10 anos atrás. Isso porque se eu tivesse lido o "Effective Oracle by Design" há mais tempo, teria evitado muitas e muitas horas de retrabalho por causa de desconhecimento de alguns detalhes que fazem toda a diferença. Leitura obrigatória para todo desenvolvedor ou toda pessoa que trabalhe com o Oracle.
One person found this helpful
 Report
N. Chivers
5.0 out of 5 stars All technical books should be written like this
Reviewed in the United Kingdom on February 25, 2005
Verified Purchase
This is possibly one of the best technical books I have ever read - I can't believe I have been taking a wage based on my skills as an Oracle developer considering the huge gaps in my knowlege that have been highlighted by this tome.
Usually I shy away from large technical volumes because I know from experience they just sit, gathering dust, on my bookshelves. However, this book is so well written it is actually like pleasure reading. If I did have a criticism it would be that the author really pushes his mantra of "do your own benchmarking", consequently every point he makes has lenghthy examples of tests he has run along side it. Sometimes it just makes you think, "OK, I believe you, now lets get on with it". This is a minor quibble, the book is a reference, not meant to be read from cover to cover (although I did) and also much can be learnt from just looking at the code he is writing.
If you have anything to do with Oracle in your working life, other than being the most low level user, you need to read this book.
4 people found this helpful
 Report
leo
5.0 out of 5 stars Noone like Tom Kyte to explain things clearly.
Reviewed in the United Kingdom on December 11, 2014
Verified Purchase
Excellent book, extremely clear! ask.tom never fails...
Report