- 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: 81 customer reviews
- Amazon Best Sellers Rank: #1,905,760 in Books (See Top 100 in Books)
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.
To get the free app, enter your mobile phone number.
Expert One on One Oracle 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Customers who bought this item also bought
What other items do customers buy after viewing this item?
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.
Top customer reviews
About Tom Kyte: Tom is an acknowledged expert in the field; he is Vice President of the Core Technologies Group at Oracle. His web site is a terrific alternative source of information about Oracle. He also publishes the "Ask Tom" column in Oracle Magazine.
Tom Kyte's book is simply awesome. Every time I read another chunk of it, I learn something new. His depth and breadth of understanding is amazing. (If you think you are an Oracle expert, buy the book. You'll be amazed at how much more Tom can teach you.) His troubleshooting is really good too. He seems to know all of the places where people encounter problems with specific features, and includes great troubleshooting information where appropriate.
If you're hesitant to buy the book because it doesn't have "9i" stamped on it, buy it anyway! Believe me, you won't regret it! Remember: 9i is a superset of 8i, and a good understanding of 8i functionality will help you understand most of 9i too.
I also had the privilege of meeting Tom in person, during an Oracle 9iR2 presentation. He is a very generous with his time, but also perpetually busy answering questions on his web site (he was connected with a laptop and cell phone before he started the presentation). I asked him about the time it took to write the book, and he acknowledged that it took a major chunk out of his life. Be thankful that there is a person as knowledgable as Tom who is so willing to help the rest of us get up to speed!!
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.
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.
Plus he tells it like it is. If you didn't know anything about technology and wanted to manage a software development project, you could rip out the first 3 pages of this book, throw the rest of it away and you'd be better off than 95% of the managers out there.
The rest of the book is for us hands-on folks....
Most recent customer reviews