Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Expert One on One Oracle 1st Edition

4.8 out of 5 stars 79 customer reviews
ISBN-13: 067-6623048264
ISBN-10: 1861004826
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used
Condition: Used - Good
Condition: Used: Good
Comment: The item shows wear from consistent use, but it remains in good condition and works perfectly. All pages and cover are intact (including the dust cover, if applicable). Spine may show signs of wear. Pages may include limited notes and highlighting. May include "From the library of" labels.
Access codes and supplements are not guaranteed with used items.
28 Used from $0.01
More Buying Choices
7 New from $32.25 28 Used from $0.01

There is a newer edition of this item:

Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Save Up to 90% on Textbooks Textbooks

Editorial Reviews

Amazon.com Review

Tom Kyte is of a rare breed. To begin, he's technically expert in his subject (administration of and development of applications for Oracle database management systems). What's more (and what distinguishes him from the ranks of the super-competent), he is both able and willing to share his considerable store of wisdom with Oracle users via books like Expert One on One: Oracle. Perhaps the best book about Oracle products ever put out, this book is a model of all aspects of technical publishing: scope, level of detail, clarity of explanations, and quality of examples. It's pretty much certain that you will learn a great deal about Oracle from Kyte's work, and that you'll become more capable in your work as a result of studying this book.

Kyte--it's very tempting to call him an Oracle oracle--seems not to have had to struggle to fit his message into the Wrox Press form, which relies on a running commentary interspersed with code listings and conceptual diagrams. Kyte's commentary is eminently informed and packed with references to the differences between that which is ideal and that which often must be done to accommodate reality. He takes care to explain how little-known pieces of the Oracle environment--and alternative ways of looking at the more familiar ones--solve problems, an approach that leads to elegant, efficient solutions. Kyte boosts his readers across the chasm that separates people who can write applications for Oracle databases from people who understand Oracle databases. --David Wall

Topics covered: Deep wisdom on developing applications for Oracle database management systems, as well as plenty of advice on designing and administering them. There are sections on general design and implementation practices, application architecture, locking and concurrency, transactions and rollbacks, importing and exporting, and lots more of interest to developers.

From the Publisher

This book offers the knowledge required for both those who build Oracle database applications, and those who administer the database.

It is critical that the DBA knows what the developers are trying to accomplish and the best developers know how to exploit the DBA's data management strategies. Armed with the fundamental knowledge of the Oracle environment that Tom describes, you will be able to build bigger, faster, and more scalable applications.

Knowledge of SQL and PL/SQL is assumed and familiarity with any 3GL language (such as C, Java, or Visual Basic) would be useful.


Product Details

  • Series: Programmer to Programmer
  • Paperback: 1265 pages
  • Publisher: Peer Information Inc.; 1 edition (June 2001)
  • Language: English
  • ISBN-10: 1861004826
  • ISBN-13: 978-1861004826
  • Product Dimensions: 9.2 x 7.3 x 2.3 inches
  • Shipping Weight: 4.4 pounds
  • Average Customer Review: 4.8 out of 5 stars  See all reviews (79 customer reviews)
  • Amazon Best Sellers Rank: #946,434 in Books (See Top 100 in Books)

More About the Author

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

Customer Reviews

Top Customer Reviews

Format: Paperback Verified Purchase
This book belongs on every developer, team leader, or DBAs desk that works with Oracle. Kyte has written a masterpiece in advanced Oracle knowledge. He does three things very well in this book: tells you what is important in Oracle, why it is important, and what happens if you do things the wrong way.
Kyte starts out giving the foundations for Oracle databases, the architecture, locking schemes, and table and index considerations. He gives a good treatment of the types of tables and indexes that Oracle offers including the appropriate times to use them and the trade-offs to weigh.
Another key topic that he covers is redo and rollback. These features are handled in a unique way in Oracle, and a lack of understanding can lead to inefficient and incorrect databases and applications.
Armed with the foundations, Kyte then takes the reader through performance tuning and optimizing databases. The best advice in this section is that performance cannot be thrown in at the end. The design decisions for a database will determine how it performs and scales. As he says, "There is no fast=true setting in the init parameters."
Then the book tackles some more advanced features, such as autonomous transactions, dynamic sql, and C and Java extensions for stored procedures. Kyte again gives good advice for when these are appropriate over standard PL/SQL stored procedures.
The size of the book can be intimidating at first glance, but it is pleasant to read. Kyte uses a conversational style rather than a lecturing delivery. This book has a lot to offer, and you won't find yourself tired after reading it.
Comment 24 of 25 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
I've been developing Oracle applications for many years and have never found a book more resourceful than Tom's. It is packed full of valuable information and is a must have for anyone working with Oracle. It covers many aspects application development from a variety of languages including C, PL/SQL and Java. Most Oracle books are strictly for reference, this book makes for good reference but also is great reading and covers interesting concepts. Chapter 1 in this book is called "Developing Successful Oracle Applications" and is a must read. I recently found that my long running query was not properly using the index I created. I looked in Tom's book and found the answer to my problem under a section called "Why isn't my Index Getting Used?" What more could you ask for? If you're a beginner, intermediate or advanced programmer, or DBA this book is for you.
Comment 17 of 17 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
This book attempts to cover dozens of subjects, and as such is 1,300 pages in length! Each subject contains gems of insight that had escaped me for some years now. I very much recommend this book if you are going to do any PL/Sql or Java coding. Read a chapter a day and really think about what Tom is saying. If you are really going to write industrial-strength code then you need this book, as Oracle Documentation and Oracle-Press books (I own several) tend to be quite shallow and omit explanations that Tom includes.
If there is a downside, it is that only a few pages are dedicated to any one subject, meaning that while there are many gems, this is not a book to learn the basics from and it does not cover any one subject completely. But then again, I have not seen an Oracle book that does. I wish Tom would write an entire series of books of this quality; I would buy it in a heart-beat!
P.S. Make sure that you get the 2003 version of this book from "APress", as I purchased one from the "New and Used" and got stuck with the 2001 version from "Oracle Press". Apparently Amazon does not require such disclosure.
Comment 16 of 16 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
As I mention in the title, I rate this book from a developer's perspective not a DBA's: My Oracle experience is usually Java/J2EE/JDBC and little PL/SQL programming.
When I first saw this book, I thought it to be a DBA reference book. Then I started picking up chapters and reading: I was amazed with the quality of information and suprised how blindly I before was working with the Oracle database. Why my query was so slow? why my index didn't help? Why transaction isolation level was so critical? and so on. I found answers to my questions in this book.
In this book, Tom explains internals of Oracle database, detailing and emphasizing critical points, and helping us to understand how we can use the Oracle database correctly and efficiently. Topics range from DBA topics like configuration, data loading, partioning to those which programmers can benefit as well: Optimization, indexes, transactions, tables etc.
This book is not a book about SQL, database design or database theory. It's all about getting the best out of an Oracle database. I strongly recommend it to any programmer developing software interacting with an Oracle database. SQL, general database knowledge, and basic Oracle knowledge is almost mandatory for reading (One should know what trigger, view, transaction, schema, index etc. are before starting the book).
With this book, "Expert One on One" series of Wrox seems to make a very good start.
Comment 14 of 14 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
If you are an Oracle programmer, or a DBA that works with programmers (and has to tell them all the things that they are supposed to know), this the best book you can buy. There are books by people that can program, and books by writers who can write but don't quite understand what they are writing about and there are a million other faults a book could have, but this book has none of them. Tom Kyte is at the very top of Oracle programming and he is a teacher who wants you to be able the do the same thing. Every topic in this book "reaches the ground". Tom starts from setting up your environment, and takes you through many high level exercises, showing you how to make it work, every single step of the way. He is teacher like W. Richard Stevens and Steve Rago.
There is too much to describe it all but as an example, there is a 70 page section on writing a C-Based external procedure. It starts with six pages of setting up your environment (listener, schema, server, exproc program, libraries), then the code in PL/SQL and C, how to make it, how to install it, how to test it, and ends with the answer to every error message you might get if you make a mistake.
The applications discussed are not just "interesting" and they don't just "work". There is a recurring theme in all of the applications and that is this: they scale. Tom has sections on bind variable, and then more on bind variables, and then more on bind variables, until the idea is branded on you that a "working" application is trivial unless it scales. You aren't writing code for developers, but for end users who may do millions of transactions a day; that is the kind of code you want.
If you already know everything, you will learn more, but either way Tom's projects are complete, and well documented; you can learn this.
This is great book, you will read all 1200 pages.
Comment 26 of 29 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews