Books & Videos

Table of Contents

  1. Chapter 1 Introducing Oracle

    1. The Evolution of the Relational Database

    2. The Oracle Family

    3. Summary of Oracle Features

    4. Database Application Development Features

    5. Database Connection Features

    6. Distributed Database Features

    7. Data Movement Features

    8. Performance Features

    9. Database Management Features

    10. Oracle Developer Suite

    11. Oracle Lite

  2. Chapter 2 Oracle Architecture

    1. Instances and Databases

    2. The Components of a Database

    3. The Components of an Instance

    4. The Data Dictionary

  3. Chapter 3 Installing and Running Oracle

    1. Installing Oracle

    2. Creating a Database

    3. Configuring Oracle Net

    4. Starting Up the Database

    5. Shutting Down the Database

    6. Accessing a Database

    7. Oracle at Work

  4. Chapter 4 Data Structures

    1. Datatypes

    2. Basic Data Structures

    3. Additional Data Structures

    4. Data Design

    5. Constraints

    6. Triggers

    7. Query Optimization

    8. Understanding the Execution Plan

    9. SQL Tuning Advisor

    10. Data Dictionary Tables

  5. Chapter 5 Managing Oracle

    1. Management and Enterprise Manager

    2. Oracle Database 10g Self-Tuning and Management

    3. Implementing Security

    4. Fragmentation and Reorganization

    5. Backup and Recovery

    6. Working with Oracle Support

  6. Chapter 6 Oracle Performance

    1. Performance Tuning Basics

    2. Oracle and Disk I/O Resources

    3. Oracle and Parallelism

    4. Oracle and Memory Resources

    5. Oracle and CPU Resources

    6. Database Resource Manager

    7. Monitoring

    8. Real Application Clusters and Performance

  7. Chapter 7 Multiuser Concurrency

    1. Basics of Concurrent Access

    2. Oracle and Concurrent User Access

    3. Oracle's Isolation Levels

    4. Oracle Concurrency Features

    5. How Oracle Handles Locking

    6. Concurrent Access and Performance

    7. Workspaces

  8. Chapter 8 Oracle and Transaction Processing

    1. OLTP Basics

    2. Oracle's OLTP Heritage

    3. Architectures for OLTP

    4. Oracle Features for OLTP

    5. High Availability

    6. Oracle Advanced Queuing and Streams

    7. Object Technologies and Distributed Components

  9. Chapter 9 Oracle and Data Warehousing

    1. Business Intelligence Basics

    2. Data Warehouse Design

    3. Query Optimization

    4. Analytics, OLAP, and Data Mining in the Database

    5. Managing the Data Warehouse

    6. Other Data Warehouse Software

    7. The Metadata Challenge

    8. Best Practices

  10. Chapter 10 Oracle and High Availability

    1. What Is High Availability?

    2. System Crashes

    3. Protecting Against System Crashes

    4. Recovering from Disasters

    5. Complete Site Failure

    6. Data Redundancy Solutions

  11. Chapter 11 Oracle and Hardware Architecture

    1. System Basics

    2. Uniprocessor Systems

    3. Symmetric Multiprocessing Systems

    4. Clusters

    5. Massively Parallel Processing Systems

    6. Non-Uniform Memory Access Systems

    7. Grid Computing

    8. Disk Technology

    9. Which Platform Deployment Solution?

  12. Chapter 12 Distributed Databases and Distributed Data

    1. Accessing Multiple Databases as a Single Entity

    2. Two-Phase Commits

    3. Moving Data Between Distributed Systems

    4. Advanced Queuing

    5. Oracle Streams

  13. Chapter 13 Extending Oracle Datatypes

    1. Object-Oriented Development

    2. Extensibility Features and Options

    3. Using the Extensibility Framework in Oracle

  14. Chapter 14 Network Deployment Models

    1. The Impact of the Internet

    2. The Oracle Database and the Internet

    3. Oracle Application Server

    4. Grid Computing

  1. Appendix A What's New in This Book for Oracle Database10g

    1. Chapter 1, Introducing Oracle

    2. Chapter 2, Oracle Architecture

    3. Chapter 3, Installing and Running Oracle

    4. Chapter 4, Data Structures

    5. Chapter 5, Managing Oracle

    6. Chapter 6, Oracle Performance

    7. Chapter 7, Multiuser Concurrency

    8. Chapter 8, Oracle and Transaction Processing

    9. Chapter 9, Oracle and Data Warehousing

    10. Chapter 10, Oracle and High Availability

    11. Chapter 11, Oracle and Hardware Architecture

    12. Chapter 12, Distributed Databases and Distributed Data

    13. Chapter 13, Extending Oracle Datatypes

    14. Chapter 14, Network Deployment Models

  2. Appendix B Additional Resources

    1. Web Sites

    2. Books and Oracle Documentation

  3. Colophon