Oracle Essentials: Oracle9i, Oracle8i and Oracle8

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition By Rick Greenwald, Robert Stackowiak, Jonathan Stern
June 2001
Pages: 384

| Table of Contents | Index | Sample Chapter | Colophon

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 Internet Developer Suite
11. Oracle Lite
Chapter 2 Oracle Architecture
1. Instances and Databases
2. The Components of a Database
3. The Components of an Instance
4. The Data Dictionary
Chapter 3 Installing and Running Oracle
1. Installing Oracle
2. Creating a Database
3. Configuring Oracle Net/Net8
4. Starting Up the Database
5. Shutting Down the Database
6. Accessing a Database
7. Oracle at Work
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. Data Dictionary Tables
Chapter 5 Managing Oracle
1. Implementing Security
2. Management Through the Oracle Enterprise Manager
3. Options for Oracle Enterprise Manager
4. Fragmentation and Reorganization
5. Backup and Recovery
6. Working with Oracle Support
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. Avoiding Performance Problemswith Oracle9i
7. Real Application Clustersand Performance
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
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
7. Object Technologies and Distributed Components
Chapter 9 Oracle and Data Warehousing
1. Data Warehousing Basics
2. Data Warehouse Design
3. Query Optimization
4. OLAP in the Database
5. Managing the Data Warehouse
6. Other Data Warehouse Software
7. The Metadata Challenge
8. Best Practices
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
Chapter 11 Oracle and Hardware Architecture
1. System Basics
2. Uniprocessor Systems
3. Symmetric Multiprocessing Systems
4. Clusters
5. Massively Parallel Processing Systems
6. Nonuniform Memory Access Systems
7. Disk Technology
8. Which Hardware Solution?
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
Chapter 13 Extending Oracle Datatypes
1. Object-Oriented Development
2. Extensibility Features and Options
3. Using the Extensibility Framework in Oracle
Chapter 14 Oracle and the Web
1. The Internet Computing Platform
2. Oracle as an Internet Server
3. XML
4. Dynamic Services
5. Oracle Internet Application Server
6. Oracle9iAS Portal

Appendix A What's New in This Book for Oracle9i
1. Chapter 1
2. Chapter 2
3. Chapter 3
4. Chapter 4
5. Chapter 5
6. Chapter 6
7. Chapter 7
8. Chapter 8
9. Chapter 9
10. Chapter 10
11. Chapter 11
12. Chapter 12
13. Chapter 13
14. Chapter 14
Appendix B Additional Resources
1. Web Sites
2. Books and Oracle Documentation
Colophon

Return to Oracle Essentials: Oracle9i, Oracle8i and Oracle8

Table of Contents

Chapter 1 Introducing Oracle

The Evolution of the Relational Database

The Oracle Family

Summary of Oracle Features

Database Application Development Features

Database Connection Features

Distributed Database Features

Data Movement Features

Performance Features

Database Management Features

Oracle Internet Developer Suite

Oracle Lite

Chapter 2 Oracle Architecture

Instances and Databases

The Components of a Database

The Components of an Instance

The Data Dictionary

Chapter 3 Installing and Running Oracle

Installing Oracle

Creating a Database

Configuring Oracle Net/Net8

Starting Up the Database

Shutting Down the Database

Accessing a Database

Oracle at Work

Chapter 4 Data Structures

Datatypes

Basic Data Structures

Additional Data Structures

Data Design

Constraints

Triggers

Query Optimization

Understanding the Execution Plan

Data Dictionary Tables

Chapter 5 Managing Oracle

Implementing Security

Management Through the Oracle Enterprise Manager

Options for Oracle Enterprise Manager

Fragmentation and Reorganization

Backup and Recovery

Working with Oracle Support

Chapter 6 Oracle Performance

Performance Tuning Basics

Oracle and Disk I/O Resources

Oracle and Parallelism

Oracle and Memory Resources

Oracle and CPU Resources

Avoiding Performance Problemswith Oracle9i

Real Application Clustersand Performance

Chapter 7 Multiuser Concurrency

Basics of Concurrent Access

Oracle and Concurrent User Access

Oracle's Isolation Levels

Oracle Concurrency Features

How Oracle Handles Locking

Concurrent Access and Performance

Workspaces

Chapter 8 Oracle and Transaction Processing

OLTP Basics

Oracle's OLTP Heritage

Architectures for OLTP

Oracle Features for OLTP

High Availability

Oracle Advanced Queuing

Object Technologies and Distributed Components

Chapter 9 Oracle and Data Warehousing

Data Warehousing Basics

Data Warehouse Design

Query Optimization

OLAP in the Database

Managing the Data Warehouse

Other Data Warehouse Software

The Metadata Challenge

Best Practices

Chapter 10 Oracle and High Availability

What Is High Availability?

System Crashes

Protecting Against System Crashes