Oracle Essentials, 3rd Edition

Oracle Essentials, 3rd Edition

by Rick Greenwald, Robert Stackowiak, Jonathan Stern
Released February 2004
Publisher(s): O'Reilly Media, Inc.
ISBN: 9780596005856

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Buy on Amazon
Start your free trial

Book description

An enormous system comprising myriad technologies, options, and releases, Oracle's complexities have spawned numerous areas of specialization. For each area of specialization there are equally specialized how-to books and manuals. O'Reilly's Oracle Essentials claims a unique place among these books. Rather than focusing on one area, the book explains the foundational concepts of the Oracle technology and the core technical and business aspects of using it.The new edition of this classic book, Oracle Essentials, 3rd Edition: Oracle Database 10g, distills a vast amount of knowledge into an easy-to-read volume covering every aspect of the Oracle database. Readers of all levels will learn about Oracle's features and technologies, including the product line, architecture, data structures, networking, concurrency, tuning, and much more.Featuring focused text, abundant illustrations, and helpful hints, the new edition offers a valuable overview of Oracle's Database 10g--the industry's first database to support grid computing. Recent releases such as Oracle 9i and 8i are also covered. The book contains chapters on:

  • Oracle products, options, and overall architecture for Oracle 10g and prior recent releases
  • Installing and running Oracle: how to configure, start up, and shut down the database, and various networking issues
  • Oracle data structures, datatypes, and ways of extending datatypes, with an introduction to Oracle objects (e.g., tables, views, indexes)
  • Managing Oracle: security, the Oracle Enterprise Manager, fragmentation and reorganization, and backup and recovery
  • Oracle performance: characteristics of disk, memory, and CPU tuning
  • Multi-user concurrency, online transaction processing (OLTP), and high availability
  • Hardware architectures (e.g., SMP, MPP, NUMA) and their impact on Oracle
  • Data warehousing and distributed databases
  • Network deployment: using Oracle as an Internet computing platform and for grid computing
  • What's new in Oracle 10g: a summary of the database changes described in the book
Oracle Essentials, 3rd Edition: Oracle Database 10g was written for anyone whose job involves managing or building systems using Oracle DBMS technology or working with staff that uses Oracle technology. This book is the perfect all-in-one source for understanding the complexities and capabilities of Oracle.

Publisher resources

View/Submit Errata

Table of contents

  1. Dedication
  2. Preface
    1. Goals of This Book
    2. Audience for This Book
    3. About the Third Edition (Oracle Database 10g)
    4. Structure of This Book
    5. Conventions Used in This Book
    6. How to Contact Us
    7. Acknowledgments
  3. 1. Introducing Oracle
    1. 1.1. The Evolution of the Relational Database
      1. 1.1.1. Relational Basics
      2. 1.1.2. How Oracle Grew
    2. 1.2. The Oracle Family
      1. 1.2.1. Oracle Standard Edition
      2. 1.2.2. Oracle Enterprise Edition
      3. 1.2.3. Oracle Personal Edition
      4. 1.2.4. Oracle Lite
    3. 1.3. Summary of Oracle Features
    4. 1.4. Database Application Development Features
      1. 1.4.1. Database Programming
        1. 1.4.1.1. SQL
        2. 1.4.1.2. PL/SQL
        3. 1.4.1.3. Java features and options
        4. 1.4.1.4. Large objects
        5. 1.4.1.5. Object-oriented programming
        6. 1.4.1.6. Third-generation languages (3GLs)
        7. 1.4.1.7. Database drivers
        8. 1.4.1.8. The Oracle Call Interface
        9. 1.4.1.9. National Language Support
        10. 1.4.1.10. Availability
      2. 1.4.2. Database Extensibility
        1. 1.4.2.1. Oracle Text and interMedia
        2. 1.4.2.2. Oracle Spatial Option
        3. 1.4.2.3. XML
    5. 1.5. Database Connection Features
      1. 1.5.1. Database Networking
        1. 1.5.1.1. Oracle Net
        2. 1.5.1.2. Oracle Names
        3. 1.5.1.3. Oracle Internet Directory
        4. 1.5.1.4. Oracle Connection Manager
        5. 1.5.1.5. Advanced Security Option
        6. 1.5.1.6. Label Security Option
        7. 1.5.1.7. Availability
      2. 1.5.2. Oracle Application Server
        1. 1.5.2.1. Availability
    6. 1.6. Distributed Database Features
      1. 1.6.1. Distributed Queries and Transactions
      2. 1.6.2. Heterogeneous Services
      3. 1.6.3. Availability
    7. 1.7. Data Movement Features
      1. 1.7.1. Basic Replication
      2. 1.7.2. Advanced Replication
      3. 1.7.3. Transportable Tablespaces
      4. 1.7.4. Advanced Queuing and Streams
      5. 1.7.5. Extraction, Transformation, Loading
      6. 1.7.6. Availability
    8. 1.8. Performance Features
      1. 1.8.1. Database Parallelization
        1. 1.8.1.1. Availability
      2. 1.8.2. Data Warehousing and Business Intelligence
        1. 1.8.2.1. Bitmap indexes
        2. 1.8.2.2. Star query optimization
        3. 1.8.2.3. Materialized views
        4. 1.8.2.4. Analytic functions
        5. 1.8.2.5. OLAP Option
        6. 1.8.2.6. Data Mining Option
        7. 1.8.2.7. Availability
    9. 1.9. Database Management Features
      1. 1.9.1. Oracle Enterprise Manager
        1. 1.9.1.1. EM2Go
      2. 1.9.2. Availability
      3. 1.9.3. Backup and Recovery
        1. 1.9.3.1. Recovery Manager
        2. 1.9.3.2. Incremental backup and recovery
        3. 1.9.3.3. Oracle Storage Manager and Automated Disk Based Backup and Recovery
        4. 1.9.3.4. Availability
      4. 1.9.4. Database Availability
        1. 1.9.4.1. Partitioning option
        2. 1.9.4.2. Data Guard
        3. 1.9.4.3. Fail Safe
        4. 1.9.4.4. Oracle Real Application Clusters
        5. 1.9.4.5. Data Guard and RAC
        6. 1.9.4.6. Automated Storage Management
        7. 1.9.4.7. Availability
    10. 1.10. Oracle Developer Suite
      1. 1.10.1. Oracle Forms Developer
        1. 1.10.1.1. Oracle Reports Developer
        2. 1.10.1.2. Oracle JDeveloper
        3. 1.10.1.3. Oracle Designer
        4. 1.10.1.4. Oracle Discoverer Administration Edition
        5. 1.10.1.5. Oracle Portal
        6. 1.10.1.6. Availability
    11. 1.11. Oracle Lite
  4. 2. Oracle Architecture
    1. 2.1. Instances and Databases
    2. 2.2. The Components of a Database
      1. 2.2.1. Tablespaces
      2. 2.2.2. Physical Files in an Oracle Database
      3. 2.2.3. Control Files
        1. 2.2.3.1. Control file parameters
        2. 2.2.3.2. Multiple control files
      4. 2.2.4. Datafiles
        1. 2.2.4.1. Datafile structure
        2. 2.2.4.2. Extents and segments
      5. 2.2.5. Redo Log Files
        1. 2.2.5.1. Multiplexing redo log files
        2. 2.2.5.2. How Oracle uses the redo logs
        3. 2.2.5.3. Naming conventions for redo logs
        4. 2.2.5.4. Archived redo logs
        5. 2.2.5.5. ARCHIVELOG mode and automatic archiving
    3. 2.3. The Components of an Instance
      1. 2.3.1. Memory Structures for an Instance
        1. 2.3.1.1. Database buffer cache
        2. 2.3.1.2. Shared pool
        3. 2.3.1.3. Redo log buffer
      2. 2.3.2. Background Processes for an Instance
    4. 2.4. The Data Dictionary
  5. 3. Installing and Running Oracle
    1. 3.1. Installing Oracle
      1. 3.1.1. Optimal Flexible Architecture (OFA)
      2. 3.1.2. Supporting Multiple Oracle Versions on a Machine
      3. 3.1.3. Upgrading an Oracle Database
    2. 3.2. Creating a Database
      1. 3.2.1. Planning the Database
      2. 3.2.2. The Value of Estimating
      3. 3.2.3. Tools for Creating Databases
    3. 3.3. Configuring Oracle Net
      1. 3.3.1. Resolving Oracle Net Service Names
      2. 3.3.2. Oracle Net Manager
      3. 3.3.3. Auto-Discovery and Agents
      4. 3.3.4. Oracle Net Configuration Files
    4. 3.4. Starting Up the Database
    5. 3.5. Shutting Down the Database
    6. 3.6. Accessing a Database
      1. 3.6.1. Server Processes and Clients
        1. 3.6.1.1. Server process
        2. 3.6.1.2. Client process
      2. 3.6.2. Application Servers and Web Servers as Clients
      3. 3.6.3. Oracle Net and Establishing Network Connections
      4. 3.6.4. The Shared Server/Multi-Threaded Server
      5. 3.6.5. Session Memory for Shared Server Processes Versus Dedicated Server Processes
      6. 3.6.6. Data Dictionary Information About the Shared Server
    7. 3.7. Oracle at Work
      1. 3.7.1. Oracle and Transactions
      2. 3.7.2. A Transaction, Step by Step
  6. 4. Data Structures
    1. 4.1. Datatypes
      1. 4.1.1. Character Datatypes
      2. 4.1.2. Numeric Datatype
      3. 4.1.3. Date Datatype
      4. 4.1.4. Other Datatypes
      5. 4.1.5. Type Conversion
      6. 4.1.6. Concatenation and Comparisons
      7. 4.1.7. NULLs
    2. 4.2. Basic Data Structures
      1. 4.2.1. Tables
      2. 4.2.2. Views
      3. 4.2.3. Indexes
        1. 4.2.3.1. B*-tree indexes
        2. 4.2.3.2. Reverse key indexes
        3. 4.2.3.3. Bitmap indexes
        4. 4.2.3.4. Function-based indexes
    3. 4.3. Additional Data Structures
      1. 4.3.1. Sequences
      2. 4.3.2. Synonyms
      3. 4.3.3. Clusters
      4. 4.3.4. Hash Clusters
    4. 4.4. Data Design
    5. 4.5. Constraints
    6. 4.6. Triggers
    7. 4.7. Query Optimization
      1. 4.7.1. Rule-Based Optimization
      2. 4.7.2. Cost-Based Optimization
        1. 4.7.2.1. Statistics
        2. 4.7.2.2. Influencing the cost-based optimizer
      3. 4.7.3. Choosing a Mode
        1. 4.7.3.1. Why choose the cost-based optimizer?
        2. 4.7.3.2. Why choose the rule-based optimizer?
      4. 4.7.4. Saving the Optimization
    8. 4.8. Understanding the Execution Plan
    9. 4.9. SQL Tuning Advisor
    10. 4.10. Data Dictionary Tables
  7. 5. Managing Oracle
    1. 5.1. Management and Enterprise Manager
      1. 5.1.1. Oracle Enterprise Manager Architecture
      2. 5.1.2. Oracle Enterprise Manager Consoles
      3. 5.1.3. The HTML Console Interface
      4. 5.1.4. EM2Go
    2. 5.2. Oracle Database 10g Self-Tuning and Management
    3. 5.3. Implementing Security
      1. 5.3.1. Usernames, Privileges, Groups, and Roles
      2. 5.3.2. Security Privileges
      3. 5.3.3. The DBA Role, SYSDBA, and SYSOPER
      4. 5.3.4. Auditing Security, Policies, and Policy Violations
      5. 5.3.5. View-Based Security
      6. 5.3.6. Fine-Grained Access Control
      7. 5.3.7. Label Security Option
      8. 5.3.8. Security and Application Roles and Privileges
      9. 5.3.9. Distributed Database and Multi-Tier Security
      10. 5.3.10. Advanced Security Option
    4. 5.4. Fragmentation and Reorganization
      1. 5.4.1. Resolving Fragmentation
    5. 5.5. Backup and Recovery
      1. 5.5.1. Types of Backup and Recovery Options
      2. 5.5.2. Additional Backup Capabilities
    6. 5.6. Working with Oracle Support
      1. 5.6.1. Reporting Problems
      2. 5.6.2. Automated Patching in Oracle Database 10g
  8. 6. Oracle Performance
    1. 6.1. Performance Tuning Basics
      1. 6.1.1. Defining Performance Problems
      2. 6.1.2. Oracle Server Performance
      3. 6.1.3. Machine Resource Usage
      4. 6.1.4. When All Else Fails
      5. 6.1.5. A Final Note on Performance
    2. 6.2. Oracle and Disk I/O Resources
      1. 6.2.1. I/O Planning Principles for an Oracle Database
      2. 6.2.2. Using RAID Disk Array Technology
        1. 6.2.2.1. Host-based software
        2. 6.2.2.2. Dedicated storage subsystems
        3. 6.2.2.3. Combined host-based and I/O subsystem volume management
      3. 6.2.3. Flexibility, Manageability, and Disk Arrays
      4. 6.2.4. How Oracle I/O and Striped Arrays Interact
    3. 6.3. Oracle and Parallelism
      1. 6.3.1. Block-Range Parallelism
      2. 6.3.2. Parallelism for Tables and Partitions of Tables
      3. 6.3.3. What Can Be Parallelized?
      4. 6.3.4. Controlling Oracle’s Parallel Resource Usage
        1. 6.3.4.1. Setting the degree of parallelism
        2. 6.3.4.2. Intra-operation parallelism
      5. 6.3.5. Adaptive Parallelism
      6. 6.3.6. Partition-Based Parallelism
        1. 6.3.6.1. Parallelism for partitions and subpartitions of a table
        2. 6.3.6.2. Fast full index scans for nonpartitioned tables
        3. 6.3.6.3. Parallel insert for nonpartitioned and partitioned tables
    4. 6.4. Oracle and Memory Resources
      1. 6.4.1. How Oracle Uses the System Global Area
        1. 6.4.1.1. The database buffer cache
        2. 6.4.1.2. The shared pool
        3. 6.4.1.3. The redo log buffer
        4. 6.4.1.4. Automatic sizing for the SGA
      2. 6.4.2. How Oracle Uses the Program Global Area
        1. 6.4.2.1. Memory for SQL statements
        2. 6.4.2.2. Memory for sorting within the PGA
        3. 6.4.2.3. Automatic sizing for the PGA
    5. 6.5. Oracle and CPU Resources
    6. 6.6. Database Resource Manager
    7. 6.7. Monitoring
      1. 6.7.1. Dynamic Performance Views
      2. 6.7.2. Enterprise Manager
      3. 6.7.3. Automatic Workload Repository and Diagnostics
    8. 6.8. Real Application Clusters and Performance
  9. 7. Multiuser Concurrency
    1. 7.1. Basics of Concurrent Access
      1. 7.1.1. Transactions
      2. 7.1.2. Locks
      3. 7.1.3. Concurrency and Contention
      4. 7.1.4. Integrity Problems
      5. 7.1.5. Serialization
    2. 7.2. Oracle and Concurrent User Access
    3. 7.3. Oracle’s Isolation Levels
    4. 7.4. Oracle Concurrency Features
    5. 7.5. How Oracle Handles Locking
      1. 7.5.1. A Simple Write Operation
      2. 7.5.2. A Conflicting Write Operation
      3. 7.5.3. A Read Operation
    6. 7.6. Concurrent Access and Performance
    7. 7.7. Workspaces
  10. 8. Oracle and Transaction Processing
    1. 8.1. OLTP Basics
      1. 8.1.1. What Is a Transaction?
      2. 8.1.2. What Does OLTP Mean?
        1. 8.1.2.1. General characteristics
        2. 8.1.2.2. Online versus batch
      3. 8.1.3. OLTP Versus Decision Support
    2. 8.2. Oracle’s OLTP Heritage
    3. 8.3. Architectures for OLTP
      1. 8.3.1. Traditional Two-Tier Client/Server
      2. 8.3.2. Stored Procedures
      3. 8.3.3. Three-Tier Systems
      4. 8.3.4. Application Servers and Web Servers
      5. 8.3.5. The Grid
    4. 8.4. Oracle Features for OLTP
      1. 8.4.1. General Concurrency and Performance
      2. 8.4.2. Scalability
        1. 8.4.2.1. Multi-Threaded Server/shared server
        2. 8.4.2.2. Database Resource Manager
      3. 8.4.3. Real Application Clusters
    5. 8.5. High Availability
    6. 8.6. Oracle Advanced Queuing and Streams
      1. 8.6.1. Advanced Queuing for System Interfaces
      2. 8.6.2. Oracle and Publish-Subscribe Technology
    7. 8.7. Object Technologies and Distributed Components
  11. 9. Oracle and Data Warehousing
    1. 9.1. Business Intelligence Basics
      1. 9.1.1. The Evolution of Business Intelligence
      2. 9.1.2. A Topology for Business Intelligence
      3. 9.1.3. Data Marts
      4. 9.1.4. Operational Data Store and Enterprise Warehouse
    2. 9.2. Data Warehouse Design
    3. 9.3. Query Optimization
      1. 9.3.1. Bitmap Indexes
      2. 9.3.2. Real Application Clusters
      3. 9.3.3. Summary Tables
      4. 9.3.4. Materialized Views
    4. 9.4. Analytics, OLAP, and Data Mining in the Database
      1. 9.4.1. Functions
      2. 9.4.2. OLAP and Data Mining Options
      3. 9.4.3. Other Capabilities
      4. 9.4.4. Database Extensibility and the Data Warehouse
        1. 9.4.4.1. interMedia
        2. 9.4.4.2. Spatial option
        3. 9.4.4.3. XML
    5. 9.5. Managing the Data Warehouse
    6. 9.6. Other Data Warehouse Software
      1. 9.6.1. Extraction, Transformation, and Loading
      2. 9.6.2. Reporting and Ad-Hoc Query Tools
      3. 9.6.3. OLAP and OLAP Applications Building
      4. 9.6.4. Data Mining
      5. 9.6.5. Business Intelligence Applications
    7. 9.7. The Metadata Challenge
    8. 9.8. Best Practices
      1. 9.8.1. Common Misconceptions
      2. 9.8.2. Effective Strategy
  12. 10. Oracle and High Availability
    1. 10.1. What Is High Availability?
      1. 10.1.1. Measuring and Planning Availability
      2. 10.1.2. Causes of Unplanned Downtime
      3. 10.1.3. System Availability Versus Component Availability
    2. 10.2. System Crashes
      1. 10.2.1. What Is Instance Recovery?
      2. 10.2.2. Phases of Instance Recovery
        1. 10.2.2.1. Rollforward
        2. 10.2.2.2. Fast-start fault recovery and bounded recovery time
        3. 10.2.2.3. Rollback
        4. 10.2.2.4. Deferred rollback
        5. 10.2.2.5. Fast-start rollback
    3. 10.3. Protecting Against System Crashes
      1. 10.3.1. Component Redundancy
        1. 10.3.1.1. Disk redundancy
      2. 10.3.2. Automatic Storage Management
      3. 10.3.3. Simple Hardware Failover
        1. 10.3.3.1. Outage duration for hardware failover
        2. 10.3.3.2. Failover and operating system platform
      4. 10.3.4. Real Application Clusters
        1. 10.3.4.1. Real Application Clusters and hardware failover
        2. 10.3.4.2. Node failure and Real Application Clusters
        3. 10.3.4.3. Parallel Fail Safe / RACGuard
      5. 10.3.5. Oracle Transparent Application Failover
        1. 10.3.5.1. How TAF works
        2. 10.3.5.2. TAF and various Oracle configurations
    4. 10.4. Recovering from Disasters
      1. 10.4.1. Developing a Backup and Recovery Strategy
      2. 10.4.2. Taking Oracle Backups
      3. 10.4.3. Using Backups to Recover
      4. 10.4.4. Read-Only Tablespaces
      5. 10.4.5. Point-in-Time Recovery
      6. 10.4.6. Flashback
      7. 10.4.7. Recovery Manager
    5. 10.5. Complete Site Failure
      1. 10.5.1. Oracle Data Guard: Standby Database for Redundancy
        1. 10.5.1.1. Logical standby database
        2. 10.5.1.2. Oracle Data Guard management
      2. 10.5.2. Possible Causes of Lost Data with a Physical Standby Database
        1. 10.5.2.1. Copying archived redo logs to a standby site
        2. 10.5.2.2. Unarchived redo information and the role of geomirroring
    6. 10.6. Data Redundancy Solutions
      1. 10.6.1. Data Replication: Synchronous and Asynchronous
      2. 10.6.2. Old-Fashioned Data Redundancy
  13. 11. Oracle and Hardware Architecture
    1. 11.1. System Basics
    2. 11.2. Uniprocessor Systems
    3. 11.3. Symmetric Multiprocessing Systems
    4. 11.4. Clusters
    5. 11.5. Massively Parallel Processing Systems
    6. 11.6. Non-Uniform Memory Access Systems
    7. 11.7. Grid Computing
    8. 11.8. Disk Technology
      1. 11.8.1. Disk Deployment Strategies
    9. 11.9. Which Platform Deployment Solution?
      1. 11.9.1. Platform Comparison
      2. 11.9.2. Approaches to Choosing Platforms
  14. 12. Distributed Databases and Distributed Data
    1. 12.1. Accessing Multiple Databases as a Single Entity
      1. 12.1.1. Distributed Data Access Across Multiple Oracle Databases
      2. 12.1.2. Access to and from Non-Oracle Databases
    2. 12.2. Two-Phase Commits
      1. 12.2.1. Transaction Processing Monitors
    3. 12.3. Moving Data Between Distributed Systems
      1. 12.3.1. Advanced Replication
        1. 12.3.1.1. Managing advanced replication
      2. 12.3.2. Transportable Tablespaces
    4. 12.4. Advanced Queuing
      1. 12.4.1. Queue Creation and Management
      2. 12.4.2. Publish-and-Subscribe Capabilities
    5. 12.5. Oracle Streams
      1. 12.5.1. Oracle Streams and Grid Computing
  15. 13. Extending Oracle Datatypes
    1. 13.1. Object-Oriented Development
      1. 13.1.1. Object-Relational Features
        1. 13.1.1.1. Objects in Oracle
        2. 13.1.1.2. Other extensibility features
      2. 13.1.2. Java’s Role
      3. 13.1.3. Enterprise JavaBeans
    2. 13.2. Extensibility Features and Options
      1. 13.2.1. Oracle Time Series
      2. 13.2.2. Oracle interMedia and Oracle Text
      3. 13.2.3. Oracle Spatial Option
    3. 13.3. Using the Extensibility Framework in Oracle
  16. 14. Network Deployment Models
    1. 14.1. The Impact of the Internet
    2. 14.2. The Oracle Database and the Internet
      1. 14.2.1. Oracle HTTP Server
      2. 14.2.2. Standards Support
        1. 14.2.2.1. Java in the database
          1. 14.2.2.1.1. PL/SQL and Java
          2. 14.2.2.1.2. JDBC and SQLJ: Java’s 3GL interfaces
        2. 14.2.2.2. XML
          1. 14.2.2.2.1. XML standards
          2. 14.2.2.2.2. XML DB
      3. 14.2.3. Simplified HTML Applications Development
    3. 14.3. Oracle Application Server
      1. 14.3.1. Editions
      2. 14.3.2. Installation
      3. 14.3.3. Components
        1. 14.3.3.1. HTTP Server
        2. 14.3.3.2. Containers for J2EE (OC4J)
        3. 14.3.3.3. TopLink
        4. 14.3.3.4. Development tools
        5. 14.3.3.5. Development servers
        6. 14.3.3.6. Portal
        7. 14.3.3.7. Wireless
        8. 14.3.3.8. Security
        9. 14.3.3.9. Integration
        10. 14.3.3.10. Business intelligence
      4. 14.3.4. System Services
        1. 14.3.4.1. Management
        2. 14.3.4.2. Caching
          1. 14.3.4.2.1. Web Cache
          2. 14.3.4.2.2. Java Object Cache
        3. 14.3.4.3. Clustering and load balancing
    4. 14.4. Grid Computing
      1. 14.4.1. Features for Grid Computing
        1. 14.4.1.1. Provisioning
        2. 14.4.1.2. Resilience
        3. 14.4.1.3. Integration
        4. 14.4.1.4. Management
      2. 14.4.2. A Final Thought on Grid Computing
  17. A. What’s New in This Book for Oracle Database10g
    1. A.1. Chapter 1, Introducing Oracle
    2. A.2. Chapter 2, Oracle Architecture
    3. A.3. Chapter 3, Installing and Running Oracle
    4. A.4. Chapter 4, Data Structures
    5. A.5. Chapter 5, Managing Oracle
    6. A.6. Chapter 6, Oracle Performance
    7. A.7. Chapter 7, Multiuser Concurrency
    8. A.8. Chapter 8, Oracle and Transaction Processing
    9. A.9. Chapter 9, Oracle and Data Warehousing
    10. A.10. Chapter 10, Oracle and High Availability
    11. A.11. Chapter 11, Oracle and Hardware Architecture
    12. A.12. Chapter 12, Distributed Databases and Distributed Data
    13. A.13. Chapter 13, Extending Oracle Datatypes
    14. A.14. Chapter 14, Network Deployment Models
  18. B. Additional Resources
    1. B.1. Web Sites
    2. B.2. Books and Oracle Documentation
      1. B.2.1. Chapter 1, Introducing Oracle
      2. B.2.2. Chapter 2, Oracle Architecture
      3. B.2.3. Chapter 3, Installing and Running Oracle
      4. B.2.4. Chapter 4, Data Structures
      5. B.2.5. Chapter 5, Managing Oracle
      6. B.2.6. Chapter 6, Oracle Performance
      7. B.2.7. Chapter 7, Multiuser Concurrency
      8. B.2.8. Chapter 8, Oracle and Transaction Processing
      9. B.2.9. Chapter 9, Oracle and Data Warehousing
      10. B.2.10. Chapter 10, Oracle and High Availability
      11. B.2.11. Chapter 11, Oracle and Hardware Architecture
      12. B.2.12. Chapter 12, Distributed Databases and Distributed Data
      13. B.2.13. Chapter 13, Extending Oracle Datatypes
      14. B.2.14. Chapter 14, Network Deployment Models
  19. Index
  20. About the Authors
  21. Colophon
  22. Copyright

Product information

  • Title: Oracle Essentials, 3rd Edition
  • Author(s): Rick Greenwald, Robert Stackowiak, Jonathan Stern
  • Release date: February 2004
  • Publisher(s): O'Reilly Media, Inc.
  • ISBN: 9780596005856