Oracle Essentials, 3/e: Oracle Database 10g

Rick Greenwald, Robert Stackowiak, Jonathan Stern

  • 出版商: O'Reilly
  • 出版日期: 2004-02-21
  • 售價: $1,440
  • 貴賓價: 9.5$1,368
  • 語言: 英文
  • 頁數: 400
  • 裝訂: Paperback
  • ISBN: 0596005857
  • ISBN-13: 9780596005856
  • 相關分類: Oracle
  • 已過版



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:


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
     Basic Data Structures
     Additional Data Structures
     Data Design
     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
     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

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