See more Amazon Details

Contents Listing

Preface

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 Developer Suite
Oracle Lite

2. Oracle Architecture
Instances and Databases
The Components of a Database
The Components of an Instance
The Data Dictionary

3. Installing and Running Oracle
Installing Oracle
Creating a Database
Configuring Oracle Net
Starting Up the Database
Shutting Down the Database
Accessing a Database
Oracle at Work

4. Data Structures
Datatypes
Basic Data Structures
Additional Data Structures
Data Design
Constraints
Triggers
Query Optimization
Understanding the Execution Plan
SQL Tuning Advisor
Data Dictionary Tables

5. Managing Oracle
Management and Enterprise Manager
Oracle Database 10g Self-Tuning and Management
Implementing Security
Fragmentation and Reorganization
Backup and Recovery
Working with Oracle Support

6. Oracle Performance
Performance Tuning Basics
Oracle and Disk I/O Resources
Oracle and Parallelism
Oracle and Memory Resources
Oracle and CPU Resources
Database Resource Manager
Monitoring
Real Application Clusters and Performance

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

8. Oracle and Transaction Processing
OLTP Basics
Oracle's OLTP Heritage
Architectures for OLTP
Oracle Features for OLTP
High Availability
Oracle Advanced Queuing and Streams
Object Technologies and Distributed Components

9. Oracle and Data Warehousing
Business Intelligence Basics
Data Warehouse Design
Query Optimization
Analytics, OLAP, and Data Mining in the Database
Managing the Data Warehouse
Other Data Warehouse Software
The Metadata Challenge
Best Practices

10. Oracle and High Availability
What Is High Availability?
System Crashes
Protecting Against System Crashes
Recovering from Disasters
Complete Site Failure
Data Redundancy Solutions

11. Oracle and Hardware Architecture
System Basics
Uniprocessor Systems
Symmetric Multiprocessing Systems
Clusters
Massively Parallel Processing Systems
Non-Uniform Memory Access Systems
Grid Computing
Disk Technology
Which Platform Deployment Solution?

12. Distributed Databases and Distributed Data
Accessing Multiple Databases as a Single Entity
Two-Phase Commits
Moving Data Between Distributed Systems
Advanced Queuing
Oracle Streams

13. Extending Oracle Datatypes
Object-Oriented Development
Extensibility Features and Options
Using the Extensibility Framework in Oracle

14. Network Deployment Models
The Impact of the Internet
The Oracle Database and the Internet
Oracle Application Server
Grid Computing

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

B. Additional Resources

Index