Oracle Essentials: Oracle9i, Oracle8i and Oracle8

Dedication;
Preface;
Goals of This Book;
Audience for This Book;
About the Second Edition (Oracle9i);
Structure of This Book;
Conventions Used in This Book;
How to Contact Us;
Acknowledgments;
Chapter 1: Introducing Oracle;
1.1 The Evolution of the Relational Database;
1.2 The Oracle Family;
1.3 Summary of Oracle Features;
1.4 Database Application Development Features;
1.5 Database Connection Features;
1.6 Distributed Database Features;
1.7 Data Movement Features;
1.8 Performance Features;
1.9 Database Management Features;
1.10 Oracle Internet Developer Suite;
1.11 Oracle Lite;
Chapter 2: Oracle Architecture;
2.1 Instances and Databases;
2.2 The Components of a Database;
2.3 The Components of an Instance;
2.4 The Data Dictionary;
Chapter 3: Installing and Running Oracle;
3.1 Installing Oracle;
3.2 Creating a Database;
3.3 Configuring Oracle Net/Net8;
3.4 Starting Up the Database;
3.5 Shutting Down the Database;
3.6 Accessing a Database;
3.7 Oracle at Work;
Chapter 4: Data Structures;
4.1 Datatypes;
4.2 Basic Data Structures;
4.3 Additional Data Structures;
4.4 Data Design;
4.5 Constraints;
4.6 Triggers;
4.7 Query Optimization;
4.8 Understanding the Execution Plan;
4.9 Data Dictionary Tables;
Chapter 5: Managing Oracle;
5.1 Implementing Security;
5.2 Management Through the Oracle Enterprise Manager;
5.3 Options for Oracle Enterprise Manager;
5.4 Fragmentation and Reorganization;
5.5 Backup and Recovery;
5.6 Working with Oracle Support;
Chapter 6: Oracle Performance;
6.1 Performance Tuning Basics;
6.2 Oracle and Disk I/O Resources;
6.3 Oracle and Parallelism;
6.4 Oracle and Memory Resources;
6.5 Oracle and CPU Resources;
6.6 Avoiding Performance Problemswith Oracle9i;
6.7 Real Application Clustersand Performance;
Chapter 7: Multiuser Concurrency;
7.1 Basics of Concurrent Access;
7.2 Oracle and Concurrent User Access;
7.3 Oracle’s Isolation Levels;
7.4 Oracle Concurrency Features;
7.5 How Oracle Handles Locking;
7.6 Concurrent Access and Performance;
7.7 Workspaces;
Chapter 8: Oracle and Transaction Processing;
8.1 OLTP Basics;
8.2 Oracle’s OLTP Heritage;
8.3 Architectures for OLTP;
8.4 Oracle Features for OLTP;
8.5 High Availability;
8.6 Oracle Advanced Queuing;
8.7 Object Technologies and Distributed Components;
Chapter 9: Oracle and Data Warehousing;
9.1 Data Warehousing Basics;
9.2 Data Warehouse Design;
9.3 Query Optimization;
9.4 OLAP in the Database;
9.5 Managing the Data Warehouse;
9.6 Other Data Warehouse Software;
9.7 The Metadata Challenge;
9.8 Best Practices;
Chapter 10: Oracle and High Availability;
10.1 What Is High Availability?;
10.2 System Crashes;
10.3 Protecting Against System Crashes;
10.4 Recovering from Disasters;
10.5 Complete Site Failure;
10.6 Data Redundancy Solutions;
Chapter 11: Oracle and Hardware Architecture;
11.1 System Basics;
11.2 Uniprocessor Systems;
11.3 Symmetric Multiprocessing Systems;
11.4 Clusters;
11.5 Massively Parallel Processing Systems;
11.6 Nonuniform Memory Access Systems;
11.7 Disk Technology;
11.8 Which Hardware Solution?;
Chapter 12: Distributed Databases and Distributed Data;
12.1 Accessing Multiple Databases as a Single Entity;
12.2 Two-Phase Commits;
12.3 Moving Data Between Distributed Systems;
12.4 Advanced Queuing;
Chapter 13: Extending Oracle Datatypes;
13.1 Object-Oriented Development;
13.2 Extensibility Features and Options;
13.3 Using the Extensibility Framework in Oracle;
Chapter 14: Oracle and the Web;
14.1 The Internet Computing Platform;
14.2 Oracle as an Internet Server;
14.3 XML;
14.4 Dynamic Services;
14.5 Oracle Internet Application Server;
14.6 Oracle9iAS Portal;
What’s New in This Book for Oracle9i;
Chapter 1;
Chapter 2;
Chapter 3;
Chapter 4;
Chapter 5;
Chapter 6;
Chapter 7;
Chapter 8;
Chapter 9;
Chapter 10;
Chapter 11;
Chapter 12;
Chapter 13;
Chapter 14;
Additional Resources;
Web Sites;
Books and Oracle Documentation;
Colophon;