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 Enterprise
Manager (EM), dealing with database fragmentation and reorganization using
current database releases, information lifecycle management, and working with Oracle
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 performance—
especially the major performance characteristics of disk, memory, and CPU
tuning. It describes how Oracle Enterprise Manager, the Automatic Workload Repository,
and the Automatic Database Diagnostic Monitor are used for performance
monitoring and management, as well as parallelism and memory management in
Chapter 8, Oracle Multiuser Concurrency, describes the basic principles of multiuser
concurrency (e.g., transactions, locks, integrity problems) and explains how Oracle
handles concurrency.
Chapter 9, Oracle and Transaction Processing, describes online transaction processing
(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 HighAvailability , discusses availability concepts, what happens
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
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