Oracle Essentials: Oracle Database 11g (Paperback)

by Rick Greenwald (Author), Robert Stackowiak (Author), Jonathan Stern (Author)
Key Phrases: web cache, cache fusion, heterogeneous services, Oracle Database, Real Application Clusters, Oracle Net (more...)

Editorial Reviews

Product Description
Oracle is an enormous system, with myriad technologies, options, and releases. Most users-even experienced developers and database administrators-find it difficult to get a handle on the full scope of the Oracle database. And, as each new Oracle version is released, users find themselves under increasing pressure to learn about a whole range of new technologies. The latest challenge is Oracle Database 11g. This book distills an enormous amount of information about Oracle into a compact, easy-to-read volume filled with focused text, illustrations, and helpful hints. It contains chapters on: Oracle products, options, data structures, and overall architecture for Oracle Database 11g, as well as earlier releases (Oracle Database 10g, Oracle9i, and Oracle8i) Installing, running, managing, monitoring, networking, and tuning Oracle, including Enterprise Manager (EM) and Oracle's self-tuning and management capabilities; and using Oracle security, auditing, and compliance (a new chapter in this edition) Multiuser concurrency, data warehouses, distributed databases, online transaction processing (OLTP), high availability, and hardware architectures (e.g., SMP, clusters, NUMA, and grid computing) Features beyond the Oracle database: Oracle Application Express, Fusion Middleware (including Oracle Application Server), and database SOA support as a Web services provider The latest Oracle Database 11g features: query result set caching, Automatic Memory Management, the Real Application Testing, Advanced Compression, Total Recall, and Active Data Guard Option Options, changes to the OLAP Option (transparently accessed and managed as materialized views), the Flashback transaction command, transparentdata encryption, the Support Workbench (and diagnosability infrastructure), and partitioning enhancements (including interval and new composite types) For new Oracle users, DBAs, developers, and managers, Oracle Essentials provides an invaluable, all-in-one introduction to the full range of Oracle features and technologies, including the just-released Oracle Database 11g features. But even if you already have a library full of Oracle documentation, you'll find that this compact book is the one you turn to, again and again, as your one-stop, truly essential reference. "Oracle Essentials gives a clear explanation of the key database concepts and architecture underlying the Oracle database. It's a great reference for anyone doing development or management of Oracle databases." --Andrew Mendelsohn, Senior Vice President, Database Server Technologies, Oracle Corporation

About the Author
Rick Greenwald has been active in the world of computer software for nearly two decades, including stints with Data General, Cognos, and Gupta. He is currently an analyst with Oracle Corporation. He has published six books and countless articles on a variety of technical topics, and has spoken at conferences and training sessions across six continents.

Robert Stackowiak is Senior Director of E-Business Intelligence for Oracle Corporation's Enterprise Technology Center. He works with Oracle's largest customers in North America, providing insight into the company's products and data warehousing strategy. In addition, he frequently assists Oracle Corporate in developing product strategy and training. Articles written by Bob have appeared in publications including The Journal of Data Warehousing, Informix Tech Notes, and AIXcellence Magazine.

Jonathan Stern has more than 13 years of IT experience, including senior positions in consulting, systems architecture, and technical sales. He has authored papers and presented at internal and external conferences on topics such as scaling with Oracle's dynamic parallelism and the role of reorganizing segments in an Oracle database. He is the Technical Director at Ariba, Inc., the leading vendor of value chain solutions for electronic commerce.

Product Details

• Paperback: 406 pages
• Publisher: O'Reilly Media, Inc.; 4 edition (November 1, 2007)
• Language: English
• ISBN-10: 0596514549
• ISBN-13: 978-0596514549
• Product Dimensions: 8.9 x 7 x 1 inches
• Shipping Weight: 1.4 pounds (View shipping rates and policies)
• Average Customer Review: 4.4 out of 5 stars See all reviews (11 customer reviews)
• Amazon.com Sales Rank: #29,210 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #11 in	Books > Computers & Internet > Databases > Relational Databases
  #22 in	Books > Computers & Internet > Databases > Oracle
  #27 in	Books > Computers & Internet > Databases > Data Mining

Customer Reviews

Most Helpful Customer Reviews

19 of 19 people found the following review helpful:

5.0 out of 5 stars everything oracle, May 2, 2004

By	Jeanne Boyarsky (New York, NY) - See all my reviews

This review is from: Oracle Essentials, 3e: Oracle Database 10g (Paperback)

As with most O'Reilly books, Oracle Essentials is crammed full of information. The book is geared for DBA's, system admins and developers. The book assumes some general knowledge of databases, but most concepts are explained as they come up. For example, there are sidebars for normalization and RAID.

The third edition is updated for Oracle 10g. Since the authors point out which features are specific to Oracle 8i, 9i and 10g, this book is just as useful for older versions of Oracle. For readers of previous editions, the book has an appendix directing the reader to the new 10g content.

For developers, using Java with Oracle is explained. There are good sections on SQLJ, JDBC, EJBs and Java stored procedures. For DBA's and system admins, the book covers architecture, failover and deployment.

The book uses a good mix of text, diagrams and examples. Many cutting-edge topics are explained with a non-platform specific background of the topic and examples. These topics include OLTP, Data Warehousing, Business Intelligence and of course - Grid Computing.

I found the list of major technologies to be extremely useful. Chapter 1 has a paragraph on Oracle features in the database, application server and standalone development tools. The rest of the book focuses on the database itself. This book covers almost everything you would want to know about Oracle and provides references for more detail on each topic. If you are only going to buy one Oracle book, this is the one to buy.

16 of 16 people found the following review helpful:

5.0 out of 5 stars Effective quick introduction to Oracle, January 31, 2005

By	Paul Filipski (Boston, MA USA) - See all my reviews (REAL NAME)

This review is from: Oracle Essentials, 3e: Oracle Database 10g (Paperback)

I've used a number of different database systems before, but never had the pleasure of working with Oracle's software. I installed a development version of 10g and was somewhat taken aback when the installer proudly announced "169 products installed." I glumly thought "Gee, hope the database server is in there somewhere."

I picked up a copy of Oracle Essentials and found it to be an excellent introduction to Oracle. The book is short enough to read end-to-end, but it is packed with information about Oracle's architecture and most of those 169 products. The authors write lucidly, in an easily accessible style. Even though the book is eminently readable, it doesn't "talk down" to the reader, nor skimp on details. There is surprising depth in so short a book with such broad scope!

As another reviewer mentioned, there is essentially nothing about SQL and PL/SQL in this book. That's okay with me - there are plenty of excellent texts on those two topics.

Oracle Essentials claims it is "What you need to know about Oracle Database architecture and features." I agree completely!

9 of 9 people found the following review helpful:

4.0 out of 5 stars Excellent theory, but no details, May 6, 2005

By	Ron (Cleveland, OH United States) - See all my reviews

This review is from: Oracle Essentials, 3e: Oracle Database 10g (Paperback)

I agree with the good things my fellow reviewers have to say about this book - it is an excellent introduction to the Oracle architecture. But be advised that although the book is rich in theory, there is virtually no hands-on, how-to information. As a result I sometimes spent hours researching how to implement a feature described in the book, when the author could have explained it in a couple of sentences. I highly recommend it - but if you plan on working with the database yourself you will need to supplement it with a good hands-on book, the Oracle on-line documentation, and a lot of trial and error.