Oracle Essentials | O'Reilly Media

Oracle Essentials, Fourth Edition Oracle Database 11g By Rick Greenwald, Robert Stackowiak, Jonathan Stern
November 2007
Pages: 406

| Table of Contents | Index | Sample Chapter | Colophon

Chapter 1 Introducing Oracle
1. The Evolution of the Relational Database
2. The Oracle Database Family
3. Summary of Oracle Database Features
4. Database Application Development Features
5. Database Connection Features
6. Distributed Database Features
7. Data Movement Features
8. Database Performance Features
9. Database Management Features
10. Database Security Features
11. Oracle Development Tools
12. Embedded Databases
Chapter 2 Oracle Architecture
1. Databases and Instances
2. Deploying Physical Components
3. Instance Memory and Processes
4. The Data Dictionary
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
Chapter 4 Oracle Data Structures
1. Datatypes
2. Basic Data Structures
3. Additional Data Structures
4. Extended Logic for Data
5. Data Design
6. Constraints
7. Triggers
8. Query Optimization
9. Understanding the Execution Plan
10. SQL Advisors
11. Data Dictionary Tables
Chapter 5 Managing Oracle
1. Manageability Features
2. Oracle Enterprise Manager
3. Fragmentation and Reorganization
4. Backup and Recovery
5. Working with Oracle Support
Chapter 6 Oracle Security, Auditing, and Compliance
1. Security
2. Auditing
3. Compliance
Chapter 7 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
Chapter 8 Oracle 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 9 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 Streams and Advanced Queuing
7. Object Technologies and Distributed Components
Chapter 10 Oracle Data Warehousing and Business Intelligence
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 Software for the Data Warehouse
7. The Metadata Challenge
8. Best Practices
Chapter 11 Oracle and High Availability
1. What Is High Availability?
2. System Failure
3. Protecting Against System Failure
4. Recovering from Failures
5. Complete Site Failure
6. Data Redundancy Solutions
7. Rolling Upgrades
Chapter 12 Oracle and Hardware Architecture
1. System Basics
2. Uniprocessor Systems
3. Symmetric Multiprocessing Systems
4. Clusters
5. Non-Uniform Memory Access Systems
6. Grid Computing
7. Disk and Storage Technology
8. Which Platform Deployment Solution?
Chapter 13 Oracle Distributed Databases and Distributed Data
1. Accessing Multiple Databases As a Single Entity
2. Moving Data Between Distributed Systems
Chapter 14 Oracle Extended Datatypes
1. Object-Oriented Development
2. Extensibility Features and Options
3. Using the Extensibility Framework in Oracle
Chapter 15 Beyond the Oracle Database
1. Application Express
2. Oracle Fusion Middleware
3. Oracle SOA Suite

Appendix What's New in This Book for Oracle Database 11g
1. : Introducing Oracle
2. : Oracle Architecture
3. : Installing and Running Oracle
4. : Data Structures
5. : Managing Oracle
6. : Oracle Security, Auditing, and Compliance
7. : Oracle Performance
8. : Oracle Multiuser Concurrency
9. : Oracle and Transaction Processing
10. : Oracle Data Warehousing and Business Intelligence
11. : Oracle and High Availability
12. : Oracle and Hardware Architecture
13. : Oracle Distributed Databases and Distributed Data
14. : Oracle Extended Datatypes
15. : Beyond the Oracle Database
Appendix Additional Resources
1. Web Sites
2. Books and Oracle Documentation
Colophon

Return to Oracle Essentials

Table of Contents

Chapter 1 Introducing Oracle

The Evolution of the Relational Database

The Oracle Database Family

Summary of Oracle Database Features

Database Application Development Features

Database Connection Features

Distributed Database Features

Data Movement Features

Database Performance Features

Database Management Features

Database Security Features

Oracle Development Tools

Embedded Databases

Chapter 2 Oracle Architecture

Databases and Instances

Deploying Physical Components

Instance Memory and Processes

The Data Dictionary

Chapter 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

Chapter 4 Oracle Data Structures

Datatypes

Basic Data Structures

Additional Data Structures

Extended Logic for Data

Data Design

Constraints

Triggers

Query Optimization

Understanding the Execution Plan

SQL Advisors

Data Dictionary Tables

Chapter 5 Managing Oracle

Manageability Features

Oracle Enterprise Manager

Fragmentation and Reorganization

Backup and Recovery

Working with Oracle Support

Chapter 6 Oracle Security, Auditing, and Compliance

Security

Auditing

Compliance

Chapter 7 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

Chapter 8 Oracle 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 9 Oracle and Transaction Processing

OLTP Basics

Oracle's OLTP Heritage

Architectures for OLTP

Oracle Features for OLTP

High Availability

Oracle Streams and Advanced Queuing

Object Technologies and Distributed Components

Chapter 10 Oracle Data Warehousing and Business Intelligence

Business Intelligence Basics

Data Warehouse Design

Query Optimization

Analytics, OLAP, and Data Mining in the Database

Managing the Data Warehouse

Other Software for the Data Warehouse

The Metadata Challenge