- Series: Expert's Voice in Oracle
- Paperback: 602 pages
- Publisher: Apress; 1st ed. edition (November 14, 2007)
- Language: English
- ISBN-10: 1590599101
- ISBN-13: 978-1590599105
- Product Dimensions: 7 x 1.4 x 9.2 inches
- Shipping Weight: 1.8 pounds (View shipping rates and policies)
- Average Customer Review: 3.8 out of 5 stars See all reviews (9 customer reviews)
- Amazon Best Sellers Rank: #2,782,422 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.
Oracle Database 11g: New Features for DBAs and Developers (Expert's Voice in Oracle) 1st ed. Edition
Use the Amazon App to scan ISBNs and compare prices.
Prepare for your professional certification with study guides and exam prep tools from Wiley. See more
Customers who viewed this item also viewed
About the Author
Sam R. Alapati is an experienced Oracle database administrator who holds the Oracle Certified Professional designation and the Hewlett-Packard UNIX System Administrator certification. He currently manages Oracle databases at the Boy Scouts of America's national headquarters in Los Colinas, Texas. Alapati has been dealing with databases for a long time, including the Ingres RDBMS in the mid-1980s. He is also well-versed in the Microsoft SQL Server, Sybase, and IBM DB2 database management systems.
Charles Kim is an Oracle ACE Director, VMware vExpert, Oracle Certified DBA, Certified Exadata Specialist, and a Certified RAC Expert. Charles holds certifications in Oracle, VMware, Red Hat Linux, and Microsoft, and has over 23 years of Oracle experience on mission- and business-critical databases. Charles presents regularly at local, regional, national, and international Oracle conferences including IOUG Collaborate, VMware World, and Oracle OpenWorld on topics of RAC, Exadata, Database As A Service, Database Consolidations, Private Database Cloud, ASM, Linux Best Practices, Data Guard Best Practices, Performance Tuning, VMware Virtualization Best Practices, Oracle Database Virtualization, and 7×24 High Availability Considerations. Charles is the technical editor of the Automatic Storage Management book by Oracle Press, the current President of the Cloud Computing and Virtualization SIG for the Independent Oracle User Group, and blogs regularly at blog.dbaexpert.com.
Browse award-winning titles. See more
If you are a seller for this product, would you like to suggest updates through seller support?
Top Customer Reviews
I have found a few problems with the text (I'm still reading it to be honest). First, several of the examples have errors in the code and generated errors when I tried to run them.
One such case is on page 146. A SQL query demonstrated there has some two obvious SQL errors. Clearly it was not tested, because it could not have run without an error (it bombed on me).
Another example is on page 166 where we find dbms_scheduelr instead of dbms_scheduler. A typo, yes, but one easily caught if the examples were tested.
Another example is on page 165 with a call to dbms_scheduler.set_attribute which has a typo. There are others, but you get the idea. It would also be nice if the code was available online somewhere.
The bottom line is that it seems that at least part of this code was not tested.
It also seems that the authors wrote part of this book on the 11g beta. I ran into one problem with the discussion on invisible indexes. The book indicates that you can use hints to force the use of an invisible index. When I tried this, it did not work (this drove me crazy as I was wondering what I was doing wrong!). After some research I found out that this was true in the beta but was not true in the final production cut of Oracle. Another example of what I think is a beta leftover has to do with SQL Query Result Caching. When I was trying this feature I found I could not set result_cache_mode to AUTO as documented in the book (page 176). When I looked in the Oracle documentation I found that AUTO was not a supported value.
Another problem I have is that examples are incomplete. For example, on page 162 there is a discussion on lightweight jobs. The examples are incomplete. I had to go figure out how to create a program (I had not used the scheduler before to be honest) before I could create the lightweight job. I spent about an hour fiddling with this, because another thing not pointed out by the author (or clearly in the documentation to be honest) are the restrictions on lightweight jobs. I know it's a new features book, and maybe I should know the scheduler, but I think at least the examples should be self-contained if possible.
Another twist appears on page 329. The author talks about a new feature that will eliminate failed loads on external tables. The only problem is that he does not give us any detail on how to actually use this new feature. Instead we get an example of how to create a table in Oracle 10g and he moves on to other features.
In the end, 3 stars seems about right to me. A lot of work went into this book, and I think I learned quite a bit about 11g, but I question now some of what I learned based on problems I've run into. I'll be reading the Freeman book mentioned by another review, shortly. It should provide a good contrast and check and balance.
I've finished reading the first three chapters and so far I found too many typing errors, errors in the code and unprecise statements. Obviously it was written in hurry.
All in all, this book does its purpose to me to learn Oracle 11g new features but I expected higher quality from Alapati and Apress.
I wouldn't say this is a bad book - it's a nice read and contains the majority of the information. I am impressed by it being one of the first 11g books out. The authors put in a lot of hard work and I congratulate them.
After completing this book I am very happy with what I have learned. The authors are very thorough in their coverage of the new features in 11g and do a good job of providing applicable real world examples.
Chapter 9 on ASM covered the new features well and Oracle has made some nice improvements. ASM is a growth area for Oracle and am looking forward to it becoming friendlier and easier to use. Moving files in and out of ASM has been made easier in Oracle 11g.
Chapter 11 on Application Development will be best utlized by developers or DBA's that are involved with development beyond the intermediate level. This chapter also introduces DBAs to APEX.
Chapter 12 is one of the most important chapters. This chapter focuses on Data Warehousing and includes the new partitioning features. The examples are easy to understand and are applicable to the real world. This chapter also does an excellent job on explaing Oracle's next generation LOBs called "Secure Files". This is a must read chapter.
If I could have added a chapter to this book it would be a chapter dedicated to RAC. Even though 11g does not bring too many new features to RAC it does have a few. For example the new features on parallel execution I do not think are mentioned. Their are also enhanced configuration assistants that can be better explained and can be found in a single place.
Overall this is an excellent book and for someone who is just starting to work with 11g this is the best place to start.
Most Recent Customer Reviews
But there are so many errors!Read more