Oracle Database 11g: New Features for DBAs and Developers (Expert's Voice in Oracle) [Paperback]

R. Sam Alapati (Author), Charles Kim (Author)

Book Description

ISBN-10: 1590599101 | ISBN-13: 978-1590599105 | Publication Date: November 15, 2007 | Edition: 1

Oracle Database 11g: New Features gives readers the lowdown on the most important new features in the latest release of Oracle's flagship database product. Authors Sam Alapati and Charles Kim are experienced database administrators who go beyond regurgitating Oracle's new feature documentation to report on “what's new that really matters.” Readers whose careers are bound up in Oracle's database system need to know what's new. Sam and Charles deliver with a rigor and candor that will help readers choose the best of the new features to apply in their own environments.

Editorial Reviews

About the Author

Sam R. Alapati is an experienced Oracle database administrator who holds the Oracle OCP DBA and the Hewlett-Packard UNIX System Administrator certifications. He currently manages Oracle databases at the Boy Scouts of America 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 the Chief Oracle Database Engineering Counsel at Fidelity Information Services, providing technical guidance and leading the Oracle SWAT team. Charles helps appraise and identify Oracle database operational deficiencies and infrastructure improvement needs and works with the Resource Manager of each Oracle database area to define and execute the remedy and mitigation plans. In addition, Charles provides technical leadership in strengthening and standardizing the database infrastructure foundation across all FIS/FTS (Fidelity Technology Solutions) Oracle database areas. In his spare time, Charles runs the dbaexpert.com website, which provides technical solutions to Oracle DBAs and developers.

Product Details

• Paperback: 632 pages
• Publisher: Apress; 1 edition (November 15, 2007)
• Language: English
• ISBN-10: 1590599101
• ISBN-13: 978-1590599105
• Product Dimensions: 9.2 x 7.1 x 1.3 inches
• Shipping Weight: 1.8 pounds (View shipping rates and policies)
• Average Customer Review: 3.9 out of 5 stars  See all reviews (10 customer reviews)
• Amazon Best Sellers Rank: #666,742 in Books (See Top 100 in Books)
  • #74 in Books > Computers & Technology > Databases > Oracle

More About the Author

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

Customer Reviews

Most Helpful Customer Reviews

20 of 22 people found the following review helpful:

3.0 out of 5 stars It's ok. Problems with examples and incorrect information, December 29, 2007

By 

LoveOracleBooks (Probably traveling somewhere, USA) - See all my reviews

This review is from: Oracle Database 11g: New Features for DBAs and Developers (Expert's Voice in Oracle) (Paperback)

I was very excited to get this book. I like to stay current on Oracle database product changes. There is a great deal of information here (I have the other New Features book from Freeman but have not read it yet).

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.

6 of 7 people found the following review helpful:

3.0 out of 5 stars very good book written in a hurry, January 12, 2008

By 

Ahmed Baraka (UAE) - See all my reviews
(REAL NAME)   

This review is from: Oracle Database 11g: New Features for DBAs and Developers (Expert's Voice in Oracle) (Paperback)

I selected this book because it's written by Alapati. I've read excellent books before by this author. Unluckily, this one is not among them.
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.

2 of 2 people found the following review helpful:

3.0 out of 5 stars Kindle version illustrations impossible (nearly) to read, April 11, 2010

By 

Debra Miller (Athens, AL USA) - See all my reviews
(REAL NAME)   

This review is from: Oracle Database 11g: New Features for DBAs and Developers (Expert's Voice in Oracle) (Paperback)

Taking into account the shortcomings of this book detailed in previous reviews, I found that there were really no alternatives to read while travelling if I wanted to prepare for the 11g upgrade exam. The book is OK to read, but since I was on the road, I opted for the Kindle version. I found that there is a technical problem with doing this, as the illustrations that include text (screen shots, report illustrations) are nearly impossible to read on a Kindle! I believe that the text has been reviewed adequately in the previous posts, but I hadn't seen this warning before... so people can keep this in mind when in the same situation I was in and contemplate a Kindle version rather than the hard copy. Also, you don't (obviously) get the referenced CD with the Kindle.