Table Of Contents
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
|
Related Books
Oracle Books
Database Books
Load Testing Books
Keywords
10g
8i
9i
data structures
database
database architecture
databases
datatypes
networking
Oracle
Oracle database
Oracle Enterprise Manager
Oracle Essentials
Oracle objects
Oracle security
security
tuning
Related Articles
Security Glossary
Oracle Internal Controls Tool and Financial Hub
Oracle Identity and Access Suite
Oracle Acquires Thor and OctetString
Oracle Buys i-Flex Stake
Security
|
