Oracle Essentials: Oracle Database 10g

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