Oracle Essentials
Oracle Database 11g
Other Oracle resources from O’Reilly
Related titles Mastering Oracle SQL Oracle DBA Pocket Guide
Optimizing Oracle Oracle in a Nutshell
Performance Oracle PL/SQL Programming
Oracle Application Server 10g Oracle SQL*Plus: The Defini-
Essentials tive Guide
Oracle Books oracle.oreilly.com is a complete catalog of O’Reilly’s books on
Resource Center Oracle and related technologies, including sample chapters and
code examples.
oreillynet.com is the essential portal for developers interested in
open and emerging technologies, including new platforms, pro-
gramming languages, and operating systems.
Conferences O’Reilly brings diverse innovators together to nurture the ideas
that spark revolutionary industries. We specialize in document-
ing the latest tools and systems, translating the innovator’s
knowledge into useful skills for those in the trenches. Visit
conferences.oreilly.com for our upcoming events.
Safari Bookshelf (safari.oreilly.com) is the premier online refer-
ence library for programmers and IT professionals. Conduct
searches across more than 1,000 books. Subscribers can zero in
on answers to time-critical questions in a matter of seconds.
Read the books on your Bookshelf from cover to cover or sim-
ply flip to the page you need. Try it today for free.
FOURTH EDITION
Oracle Essentials
Oracle Database 11g
Rick Greenwald, Robert Stackowiak, and
Jonathan Stern
Beijing • Cambridge • Farnham • Köln • Paris • Sebastopol • Taipei • Tokyo
Oracle Essentials: Oracle Database 11g, Fourth Edition
by Rick Greenwald, Robert Stackowiak, and Jonathan Stern
Copyright © 2008 O’Reilly Media, Inc. All rights reserved.
Printed in the United States of America.
Published by O’Reilly Media, Inc., 1005 Gravenstein Highway North, Sebastopol, CA 95472.
O’Reilly books may be purchased for educational, business, or sales promotional use. Online editions
are also available for most titles (safari.oreilly.com). For more information, contact our
corporate/institutional sales department: (800) 998-9938 or
[email protected].
Editors: Colleen Gorman and Deborah Russell Interior Designer: David Futato
Production Editor: Sumita Mukherji Cover Designer: Karen Montgomery
Production Services: Tolman Creek Design Illustrator: Robert Romano
Printing History:
October 1999: First Edition. Originally published under the title
Oracle Essentials: Oracle8 and Oracle8i
June 2001: Second Edition. Originally published under the title
Oracle Essentials: Oracle9i, Oracle8i and Oracle8
February 2004: Third Edition. Originally published under the title
Oracle Essentials: Oracle Database 10g
November 2007: Fourth Edition.
Nutshell Handbook, the Nutshell Handbook logo, and the O’Reilly logo are registered trademarks of
O’Reilly Media, Inc. Oracle Essentials: Oracle Database 11g, the image of cicadas, and related trade
dress are trademarks of O’Reilly Media, Inc.
Oracle® and all Oracle-based trademarks and logos are trademarks or registered trademarks of Oracle
Corporation, Inc. in the United States and other countries. O’Reilly Media, Inc. is independent of
Oracle Corporation. Java™ and all Java-based trademarks and logos are trademarks or registered
trademarks of Sun Microsystems, Inc. in the United States and other countries. O’Reilly Media, Inc. is
independent of Sun Microsystems. .NET is a registered trademark of Microsoft Corporation.
Many of the designations used by manufacturers and sellers to distinguish their products are claimed as
trademarks. Where those designations appear in this book, and O’Reilly Media, Inc. was aware of a
trademark claim, the designations have been printed in caps or initial caps.
While every precaution has been taken in the preparation of this book, the publisher and authors
assume no responsibility for errors or omissions, or for damages resulting from the use of the
information contained herein.
This book uses RepKover™ a durable and flexible lay-flat binding.
,
ISBN-10: 0-596-51454-9
ISBN-13: 978-0-596-51454-9
[M]
In memory of Jonathan
Table of Contents
Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xi
1. Introducing Oracle . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
The Evolution of the Relational Database 2
The Oracle Database Family 7
Summary of Oracle Database Features 9
Database Application Development Features 9
Database Connection Features 13
Distributed Database Features 17
Data Movement Features 18
Database Performance Features 20
Database Management Features 23
Database Security Features 27
Oracle Development Tools 28
Embedded Databases 31
2. Oracle Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33
Databases and Instances 33
Deploying Physical Components 38
Instance Memory and Processes 48
The Data Dictionary 54
3. Installing and Running Oracle . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56
Installing Oracle 56
Creating a Database 59
Configuring Oracle Net 63
vii
Starting Up the Database 68
Shutting Down the Database 69
Accessing a Database 70
Oracle at Work 77
4. Oracle Data Structures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82
Datatypes 82
Basic Data Structures 90
Additional Data Structures 98
Extended Logic for Data 100
Data Design 102
Constraints 104
Triggers 107
Query Optimization 108
Understanding the Execution Plan 118
SQL Advisors 120
Data Dictionary Tables 120
5. Managing Oracle . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122
Manageability Features 124
Oracle Enterprise Manager 126
Fragmentation and Reorganization 132
Backup and Recovery 133
Working with Oracle Support 137
6. Oracle Security, Auditing, and Compliance . . . . . . . . . . . . . . . . . . . . . . . . . . . 139
Security 139
Auditing 150
Compliance 151
7. Oracle Performance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 154
Performance Tuning Basics 154
Oracle and Disk I/O Resources 160
Oracle and Parallelism 169
Oracle and Memory Resources 176
Oracle and CPU Resources 182
Database Resource Manager 184
viii | Table of Contents
8. Oracle Multiuser Concurrency . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 186
Basics of Concurrent Access 187
Oracle and Concurrent User Access 190
Oracle’s Isolation Levels 191
Oracle Concurrency Features 192
How Oracle Handles Locking 194
Concurrent Access and Performance 197
Workspaces 198
9. Oracle and Transaction Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 201
OLTP Basics 201
Oracle’s OLTP Heritage 205
Architectures for OLTP 206
Oracle Features for OLTP 211
High Availability 217
Oracle Streams and Advanced Queuing 218
Object Technologies and Distributed Components 221
10. Oracle Data Warehousing and Business Intelligence . . . . . . . . . . . . . . . . . . . 222
Business Intelligence Basics 223
Data Warehouse Design 227
Query Optimization 230
Analytics, OLAP, and Data Mining in the Database 233
Managing the Data Warehouse 236
Other Software for the Data Warehouse 236
The Metadata Challenge 248
Best Practices 249
11. Oracle and High Availability . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 253
What Is High Availability? 254
System Failure 257
Protecting Against System Failure 262
Recovering from Failures 275
Complete Site Failure 281
Data Redundancy Solutions 285
Rolling Upgrades 289
Table of Contents | ix
12. Oracle and Hardware Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 290
System Basics 290
Uniprocessor Systems 292
Symmetric Multiprocessing Systems 293
Clusters 295
Non-Uniform Memory Access Systems 298
Grid Computing 299
Disk and Storage Technology 300
Which Platform Deployment Solution? 302
13. Oracle Distributed Databases and Distributed Data . . . . . . . . . . . . . . . . . . . . 305
Accessing Multiple Databases As a Single Entity 305
Moving Data Between Distributed Systems 310
14. Oracle Extended Datatypes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 318
Object-Oriented Development 318
Extensibility Features and Options 324
Using the Extensibility Framework in Oracle 329
15. Beyond the Oracle Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 331
Application Express 331
Oracle Fusion Middleware 332
Oracle SOA Suite 345
A. What’s New in This Book for Oracle Database 11g . . . . . . . . . . . . . . . . . . . . . 349
B. Additional Resources . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 356
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 365
x | Table of Contents
-
Preface 1
We dedicate this book to the memory of one of our original coauthors, Jonathan
Stern. Jonathan unexpectedly passed away in March of 2007. Yet his memory lives
on for those of us who knew him and, in many ways, for those who will read this
book. Let us explain.
The original outline for this book was first assembled at the ubiquitous coffee shop
located in the Sears Tower in Chicago. It was 1998 and the authors had gathered
there with a common goal. We were all Oracle employees working in technical sales
roles and had visited many organizations and companies. We found that many IT
managers, Oracle database administrators (DBAs), and Oracle developers were quite
adept at reading Oracle’s documentation, but seemed to be missing an understand-
ing of the overall Oracle footprint and how to practically apply what they were
reading. It was as if they had a recipe book, but were unclear on how to gather the
right ingredients and mix them together successfully. This bothered all of us, but it
particularly frustrated Jonathan.
Jonathan was the kind of person who sought to understand how things worked.
Nothing delighted Jonathan more than gaining such an understanding, then spend-
ing hours thinking of ways to translate his understanding into something that would
be more meaningful to others. He believed that a key role for himself while at Oracle
was the transfer of such knowledge to others. He continued to perform similar roles
later at other companies at which he worked.
Writing the first edition of Oracle Essentials was a lengthy process. Jonathan wrote
several of the original chapters, and he also reviewed some of the other original work
and was quick to identify where he thought something was wrong. For Jonathan,
“wrong” meant that the text could be misinterpreted and that further clarity was
needed to make sure the right conclusion was drawn. The first edition became much
more useful through Jonathan’s efforts. He was always quite proud of that effort.
Even as the book changed with succeeding editions and Jonathan moved on to other
companies, he continued to feel that this book remained an important accomplish-
ment in his life.
xi
Some explanations of how Oracle works are fundamental to the database and have
not changed in subsequent editions of the book, so some of Jonathan’s original work
remains here, although much of the surrounding text is now considerably different.
Of course, some entire sections describing the complex steps that were once needed
to manage and deploy older releases of the database are no longer relevant and thus
are no longer included. Jonathan would probably view Oracle’s self-managing and
self-tuning improvements as incredible achievements, but would also wonder
whether it is a good thing that people can know even less today about how the data-
base works but still deploy it.
So, we introduce you to the fourth edition of Oracle Essentials. We have made many
changes in this edition. Some, of course, result from changes in features in Oracle
Database 11g and the ways that you can now use and deploy the latest release of the
database. But we have also made a considerable effort to go back and rewrite parts of
the book that we did not believe possessed the clarity needed by our readers—clarity
that Jonathan would want in such a book. So, he influences us still.
Goals of This Book
Our main goal is to give you a foundation for using the Oracle database effectively
and efficiently. Therefore, we wrote with these principles in mind:
Focus
We’ve tried to concentrate on the most important Oracle issues. Every topic pro-
vides a comprehensive but concise discussion of how Oracle handles an issue
and the repercussions of that action.
Brevity
One of the first decisions we made was to concentrate on principles rather than
syntax. There simply isn’t room for myriad syntax diagrams and examples in this
book.
Uniqueness
We’ve tried to make this an ideal first Oracle book for a wide spectrum of Oracle
users—but not the last! You will very likely have to refer to Oracle documenta-
tion or other, more specific books for more details about using Oracle. However,
we hope this book will act as an accelerator for you. Using the foundation you
get from this book, you can take detailed information from other sources and
put it to the best use.
This book is the result of more than 45 combined years of experience with Oracle
and other databases. We hope you’ll benefit from that experience.
xii | Preface
Audience for This Book
We wrote this book for people possessing all levels of Oracle expertise. Our target
audiences include DBAs who spend most of their workday managing Oracle, appli-
cation developers who build their systems on the data available in an Oracle
database, and system administrators who are concerned with how Oracle will affect
their computing environments. Of course, IT managers and business users interact
more peripherally with the actual Oracle product. On the one hand, anticipating the
appropriate technical level of all our potential readers presented difficulties; on the
other hand, we’ve tried to build a solid foundation from the ground up and believe
that some introductory material benefits everyone. We’ve also tried to ensure that
every reader receives all the fundamental information necessary to truly understand
the topics presented.
If you’re an experienced Oracle user, you may be tempted to skip over material in
this book with which you are already familiar. But experience has shown that some
of the most basic Oracle principles can be overlooked, even by experts. We’ve also
seen how the same small “gotchas” trip up even the most experienced Oracle practi-
tioners and cause immense damage if they go unnoticed. After all, an ounce of
prevention, tempered by understanding, is worth a pound of cure, especially when
you are trying to keep your systems running optimally. So we hope that even experi-
enced Oracle users will find valuable information in every chapter of this book—
information that will save hours in their busy professional lives.
Our guiding principle has been to present this information compactly without mak-
ing it overly tutorial. We think that the most important ratio in a book like this is the
amount of useful information you get balanced against the time it takes you to get it.
We sincerely hope this volume provides a terrific bang for the buck.
About the Fourth Edition (Oracle Database 11g)
The first three editions of this book, covering the Oracle database up to the Oracle
Database 10g version, have been well received, and we were pleased that O’Reilly
Media agreed to publish this fourth edition. In this update to the book, we have
added information describing the latest release of Oracle, Oracle Database 11g.
For the most part, the task of preparing this fourth edition was fairly clear-cut,
because the Oracle Database 11g release is primarily incremental—the new features
in the release extend existing features of the database. We’ve added the information
about these extensions to each of the chapters, wherever this information was most
relevant and appropriate. However, manageability has greatly changed over the
release, and is reflected in many of the most significant changes to content.
Preface | xiii
Of course, this fourth edition cannot possibly cover everything that is new in Oracle
Database 11g. In general, we have followed the same guidelines for this edition that
we did for the first three editions. If a new feature does not seem to be broadly
important, we have not necessarily delved into it. As with earlier editions we have
not tried to produce a laundry list of every characteristic of the Oracle database. In
addition, if a feature falls into an area outside the scope of the earlier editions, we
have not attempted to cover it in this edition unless it has assumed new importance.
Structure of This Book
This book is divided into 15 chapters and 2 appendixes, as follows:
Chapter 1, Introducing Oracle, describes the range of Oracle products and features
and provides a brief history of Oracle and relational databases.
Chapter 2, Oracle Architecture, describes the core concepts and structures (e.g., files,
processes, and so on) that are the architectural basis of Oracle.
Chapter 3, Installing and Running Oracle, briefly describes how to install Oracle and
how to configure, start up, and shut down the database and Oracle Net.
Chapter 4, Oracle Data Structures, summarizes the various datatypes supported by
Oracle and introduces the Oracle objects (e.g., tables, views, indexes). This chapter
also covers query optimization.
Chapter 5, Managing Oracle, provides an overview of managing an Oracle system,
including the advisors available as part of Oracle Database 11g, using Oracle Enter-
prise Manager (EM), dealing with database fragmentation and reorganization using
current database releases, information lifecycle management, and working with Ora-
cle Support.
Chapter 6, Oracle Security, Auditing, and Compliance, provides an overview of basic
Oracle security, Oracle’s security options, basic auditing capabilities, and ways you
can leverage the Oracle Database Vault Option and the Audit Vault Server to meet
compliance needs.
Chapter 7, Oracle Performance, describes the main issues relevant to Oracle perfor-
mance—especially the major performance characteristics of disk, memory, and CPU
tuning. It describes how Oracle Enterprise Manager, the Automatic Workload Repos-
itory, and the Automatic Database Diagnostic Monitor are used for performance
monitoring and management, as well as parallelism and memory management in
Oracle.
Chapter 8, Oracle Multiuser Concurrency, describes the basic principles of multiuser
concurrency (e.g., transactions, locks, integrity problems) and explains how Oracle
handles concurrency.
xiv | Preface
Chapter 9, Oracle and Transaction Processing, describes online transaction process-
ing (OLTP) in Oracle.
Chapter 10, Oracle Data Warehousing and Business Intelligence, describes the basic
principles of data warehouses and business intelligence, Oracle database features
used for such solutions, Oracle’s business intelligence tools, relevant options such as
OLAP and Data Mining, and best practices.
Chapter 11, Oracle and High Availability, discusses availability concepts, what hap-
pens when the Oracle database recovers, protecting against system failure, Oracle’s
backup and recovery facilities, and high availability and failover solutions.
Chapter 12, Oracle and Hardware Architecture, describes your choice of computer
architectures, configuration considerations, and deployment strategies for Oracle,
including grid computing.
Chapter 13, Oracle Distributed Databases and Distributed Data, briefly summarizes
the Oracle facilities used in distributed processing including two-phase commits and
Streams Advanced Queuing and replication.
Chapter 14, Oracle Extended Datatypes, describes Oracle’s object-oriented features,
Java’s™ role, web services support, multimedia extensions to the Oracle datatypes,
content management using the database, spatial capabilities, and the extensibility
framework.
Chapter 15, Beyond the Oracle Database, describes Oracle Application Express,
deploying to the Web using the Oracle Application Server and Fusion Middleware,
and the overall use of Oracle in a Service-Oriented Architecture (SOA) environment.
Appendix A, What’s New in This Book for Oracle Database 11g, lists the Oracle
Database 11g changes described in this book.
Appendix B, Additional Resources, lists a variety of additional resources—both
online and offline—so you can do more detailed reading.
Conventions Used in This Book
The following typographical conventions are used in this book:
Italic
Used for file and directory names, emphasis, and the first occurrence of terms
Constant width
Used for code examples and literals
Constant width italic
In code examples, indicates an element (for example, a parameter) that you supply
Preface | xv
UPPERCASE
Generally indicates Oracle keywords
lowercase
In code examples, generally indicates user-defined items such as variables
This icon indicates a tip, suggestion, or general note. For example,
we’ll tell you if you need to use a particular version of Oracle or if an
operation requires certain privileges.
This icon indicates a warning or caution. For example, we’ll tell you if
Oracle doesn’t behave as you’d expect or if a particular operation neg-
atively impacts performance.
How to Contact Us
Please address comments and questions concerning this book to the publisher:
O’Reilly Media, Inc.
1005 Gravenstein Highway North
Sebastopol, CA 95472
800-998-9938 (in the United States or Canada)
707-829-0515 (international/local)
707-829-0104 (fax)
There is a web page for this book, which lists errata, the text of several helpful tech-
nical papers, and any additional information. You can access this page at:
http://www.oreilly.com/catalog/9780596514549
To comment or ask technical questions about this book, send email to:
[email protected]
For more information about books, conferences, software, Resource Centers, and the
O’Reilly Network, see the O’Reilly web site at:
http://www.oreilly.com
Using Code Examples
This book is here to help you get your job done. In general, you may use the code in
this book in your programs and documentation. You do not need to contact us for
permission unless you’re reproducing a significant portion of the code. For example,
writing a program that uses several chunks of code from this book does not require
permission. Selling or distributing a CD-ROM of examples from O’Reilly books does
require permission. Answering a question by citing this book and quoting example
xvi | Preface
code does not require permission. Incorporating a significant amount of example
code from this book into your product’s documentation does require permission.
We appreciate, but do not require, attribution. An attribution usually includes the
title, author, publisher, and ISBN. For example: “Oracle Essentials: Oracle Database
11g, Fourth Edition, by Rick Greenwald, Robert Stackowiak, and Jonathan Stern.
Copyright 2008 O’Reilly Media Inc., 978-0-596-51454-9.”
If you feel your use of code examples falls outside fair use or the permission given
above, feel free to contact us at
[email protected].
Safari® Books Online
When you see a Safari® Books Online icon on the cover of your
favorite technology book, that means the book is available online
through the O’Reilly Network Safari Bookshelf.
Safari offers a solution that’s better than e-books. It’s a virtual library that lets you
easily search thousands of top tech books, cut and paste code samples, download
chapters, and find quick answers when you need the most accurate, current informa-
tion. Try it for free at http://safari.oreilly.com.
Acknowledgments
Each of the authors has arrived at this collaboration through a different path, but we
would all like to thank the team at O’Reilly for making this book both possible and a
joy to write. We’d like to thank our first editor for this edition, Colleen Gorman, and
the rest of the O’Reilly crew, especially Sumita Mukherji, the production editor; Rob
Romano, who developed the figures; and Shan Young, who wrote the index. Also,
we’d like to thank our editor from the first three editions, Debby Russell, who was
among the first to see the value in such a book and who stepped in to perform final
editing on the fourth edition as well. It’s incredible how all of these folks were able to
strike the perfect balance—always there when we needed something, but leaving us
alone when we didn’t.
We’re all grateful to each other. Giving birth to a book is a difficult process, but it
can be harrowing when split three ways. Everyone hung in there and did their best
throughout this process. We’d also like to give our sincere thanks to the technical
reviewers for the fourth edition of this book: Darryl Hurley, Dwayne King, Arup
Nanda, and Bert Scalzo. Thanks as well to reviewers of previous editions: Craig Shal-
lahamer of OraPub, Domenick Ficarella, Jonathan Gennick, Jenny Gelhausen, and
Dave Klein. This crucially important work really enhanced the value of the book
you’re reading. And thanks as well to Lance Ashdown for clarifying Oracle database
writes.
Preface | xvii
Rick thanks the incredibly bright and gifted people who have shared their wealth of
knowledge with him over the years, including Bruce Scott, Earl Stahl, Jerry Chang,
and Jim Milbery. In particular, he thanks the two individuals who have been his
technical mentors over the course of his entire career: Ed Hickland and Dave Klein,
who have repeatedly spent time explaining to and discussing with him some of the
broader and finer points of database technology.
For the later editions of this book, Rick would also like to thank all those colleagues
at Oracle who helped him in his time of need, checking on those last-minute clarifi-
cations, including John Lang, Bruce Lowenthal, Alice Watson, Dave Leroy, Sushil
Kumar, Mughees Minhas, Daniela Hansell, Penny Avril, Mark Townsend, and Mark
Drake. And a special thank-you to Jenny Tsai-Smith, who always seemed to have the
time and knowledge to clear up any Oracle database problem. And last, but cer-
tainly not least, his primary coauthor, Bob Stackowiak, who has become a good
friend over the years of collaboration.
Bob acknowledges all his friends over the years around the world at Oracle Corpora-
tion, and from earlier stints at IBM, Harris Computer Systems, and the U.S. Army
Corps of Engineers. Through personal relationships and email, they have shared a lot
and provided him with incredible opportunities for learning. At Oracle, he especially
thanks members of Andy Mendelsohn’s team who have always been helpful in pro-
viding material ahead of releases, including Mark Townsend, Raymond Roccaforte,
George Lumpkin, Hermann Baer, and many others. Bob also extends special thanks
to his team in Oracle’s Technology Business Unit that includes Louis Nagode, Jim
Bienski, Gayl Czaplicki, Alan Manewitz, Joan Maiorana, Sandrine Ost, and Max Riv-
era. His management continues to recognize the value of such projects, including
Mark Salser and Paul Cross. He’d also like to thank his customers, who have always
had the most practical experience using the products and tools he has worked with
and from whom he continues to learn. Finally, both Bob and Rick would like to
thank Sheila Cepero for adding them to the Oracle Database 11g beta program, an
important factor in enabling this book to appear so shortly after the initial release of
the new database version.
In earlier editions, Jonathan thanked many of his professional contacts in previous
editions, including Murray Golding, Sam Mele, and the Oracle Server Technologies
members and their teams, including Juan Tellez, Ron Weiss, Juan Loaiza, and Carol
Colrain for their help during his years at Oracle. And we thank him for all that he
gave us in too short a life.
xviii | Preface
Chapter 1 CHAPTER 1
Introducing Oracle 1
Where do we start? One of the problems in comprehending a massive product such
as the Oracle database is getting a good sense of how the product works without
getting lost in the details. This book aims to provide a thorough grounding in the
concepts and technologies that form the foundation of Oracle’s Database Server,
currently known as Oracle Database 11g. The book is intended for a wide range of
Oracle database administrators, developers, and users, from the novice to the experi-
enced. It is our hope that once you have this basic understanding of the product,
you’ll be able to connect the dots when using Oracle’s voluminous feature set, docu-
mentation, and the many other books and publications that describe the database.
Oracle also offers an Application Server and Fusion Middleware, business intelli-
gence tools, and business applications (the E-Business Suite, PeopleSoft, JD
Edwards, Siebel, Hyperion, and Project Fusion). Since this book is focused on the
database, we will touch on these as they relate to specific Oracle database topics
covered.
This first chapter lays the groundwork for the rest of the book. Of all the chapters, it
covers the broadest range of topics. Most of these topics are discussed later in more
depth, but some of the basics—for example, the brief history of Oracle and the con-
tents of the different “flavors” of the Oracle database products—are unique to this
chapter.
Over the past 30 years, Oracle grew from being one of many vendors that developed
and sold a database product to being widely recognized as the database market
leader. Although early products were typical of a startup company, the Oracle data-
base quality and depth grew such that its technical capabilities are now often viewed
as the most advanced in the industry. With each database release, Oracle has
improved the scalability, functionality, and manageability of the database.
1