Oracle Essentials: Oracle Database 11g

Front Cover
"O'Reilly Media, Inc.", Nov 1, 2007 - Computers - 408 pages
4 Reviews

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, transparent data 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

What people are saying - Write a review

Review: Oracle Essentials: Oracle Database 11g

User Review  - Joe Haynes - Goodreads

I am only about a fourth of the way in and have to say that this is one of the best introductory Oracle books that I have read year. Read full review


Introducing Oracle
Oracle Architecture
Installing and Running Oracle
Oracle Data Structures
Managing Oracle
Oracle Security Auditing and Compliance
Oracle Performance
Oracle and Transaction Processing
Oracle and High Availability
Oracle and Hardware Architecture
Oracle Distributed Databases and Distributed Data
Oracle Extended Datatypes
Beyond the Oracle Database
A Whats New in This BookforOracle Database 11g
B Additional Resources

Oracle Data Warehousing and Business Intelligence

Other editions - View all

Common terms and phrases

Popular passages

Page 357 - Kreines, David, and Brian Laskey. Oracle Database Administration: The Essential Reference. Sebastopol, CA: O'Reilly Media, Inc., 1999.

About the author (2007)

Robert (Bob) Stackowiak is Vice President, Enterprise Solutions at Oracle. He has coauthored several books on Oracle technologies. Stackowiak's papers regarding data warehousing and computer and software technology have appeared in publications such as The Data Warehousing Institute's "Journal of Data Warehousing" and "Data Warehousing Trends and Applications".

Rick Greenwald is Director of Oracle Partner Enablement at Oracle where he has worked for more than 10 years. He is also the author or coauthor of several books on Oracle technologies.

Maqsood Alam, OCP, is Senior Manager, Product Development at Oracle. He is focused on evangelizing Oracle Exadata, performing competitive benchmarks, promoting best practices for migrations into Oracle Exadata from Oracle and non-Oracle databases, and providing support to customers undergoing large Oracle Exadata implementations.

Mans Bhuller, Director, Enterprise Solutions, Oracle, has worked at the forefront of emerging technologies at Oracle Corporation for the last 13 years. He currently runs the Database, Grid, and Systems Management architecture practice within Oracle's Enterprise Solutions Group where he has been paving the way for the Sun Oracle database machine and other foundational technologies.

Robert Stackowiak has more than 25 years of experience in data warehousing and business intelligence architecture, software development, new database and systems product introduction, and technical sales and sales consulting. During the writing of this edition of Oracle Essentials, he is Vice President of Big Data and Analytics Architecture in Oracle's Enterprise Solutions Group. He has spoken on related Oracle topics at a wide variety of conferences including Gartner Group's BI Summit, TDWI, ComputerWorld's BI & Analytics Perspectives, Oracle OpenWorld, and numerous IOUG events. Among the other books he co-authored are the following: Achieving Extreme Performance with Oracle Exadata (McGraw-Hill Oracle Press), Professional Oracle Programming (WROX), and Oracle Data Warehousing and Business Intelligence Solutions (Wiley). He can be followed on Twitter @rstackow.

Jonathan Stern used more than 13 years of experience in contributing to the original edition of this book. His background included senior positions in consulting, systems architecture, and technical sales at Oracle and other companies. He demonstrated in-depth knowledge of the Oracle Database across major open systems hardware and operating systems. His expertise included Database tuning, scaling, parallelism, clustering, and high availability for transaction processing systems and data warehousing implementations. Some of the fundamentals of Oracle that he originally contributed to the first edition live on in this edition of Oracle Essentials though much has changed in the Oracle Database since Jonathan passed on. Each edition of this book is a reminder of the talent and attention to detail that he possessed.

Bibliographic information