Oracle Essentials, 3/e: Oracle Database 10g

An enormous system comprising myriad technologies, options, and releases, Oracle's complexities have spawned numerous areas of specialization. For each area of specialization there are equally specialized how-to books and manuals. O'Reilly's Oracle Essentials claims a unique place among these books. Rather than focusing on one area, the book explains the foundational concepts of the Oracle technology and the core technical and business aspects of using it.

The new edition of this classic book, Oracle Essentials, 3rd Edition: Oracle Database 10g, distills a vast amount of knowledge into an easy-to-read volume covering every aspect of the Oracle database. Readers of all levels will learn about Oracle's features and technologies, including the product line, architecture, data structures, networking, concurrency, tuning, and much more.

Featuring focused text, abundant illustrations, and helpful hints, the new edition offers a valuable overview of Oracle's Database 10g--the industry's first database to support grid computing. Recent releases such as Oracle 9i and 8i are also covered. The book contains chapters on:

• Oracle products, options, and overall architecture for Oracle 10g and prior recent releases
  
• Installing and running Oracle: how to configure, start up, and shut down the database, and various networking issues
  
• Oracle data structures, datatypes, and ways of extending datatypes, with an introduction to Oracle objects (e.g., tables, views, indexes)
  
• Managing Oracle: security, the Oracle Enterprise Manager, fragmentation and reorganization, and backup and recovery
  
• Oracle performance: characteristics of disk, memory, and CPU tuning
  
• Multi-user concurrency, online transaction processing (OLTP), and high availability
  
• Hardware architectures (e.g., SMP, MPP, NUMA) and their impact on Oracle
  
• Data warehousing and distributed databases
  
• Network deployment: using Oracle as an Internet computing platform and for grid computing
  
• What's new in Oracle 10g: a summary of the database changes described in the book

Oracle Essentials, 3rd Edition: Oracle Database 10g was written for anyone whose job involves managing or building systems using Oracle DBMS technology or working with staff that uses Oracle technology. This book is the perfect all-in-one source for understanding the complexities and capabilities of Oracle.

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