Oracle Essentials Oracle Database 11g

Oracle is an enormous system, with myriad technologies, options, and releases. Most users-even experienced developers and database administrators-find it difficult to get a handle on the full scope of the Oracle database. And, as each new Oracle version is released, users find themselves under increasing pressure to learn about a whole range of new technologies. The latest challenge is Oracle Database 11g.

This book distills an enormous amount of information about Oracle into a compact, easy-to-read volume filled with focused text, illustrations, and helpful hints. It contains chapters on:

• Oracle products, options, data structures, and overall architecture for Oracle Database 11g, as well as earlier releases (Oracle Database 10g, Oracle9i, and Oracle8i)



• Installing, running, managing, monitoring, networking, and tuning Oracle, including Enterprise Manager (EM) and Oracle's self-tuning and management capabilities; and using Oracle security, auditing, and compliance (a new chapter in this edition)



• Multiuser concurrency, data warehouses, distributed databases, online transaction processing (OLTP), high availability, and hardware architectures (e.g., SMP, clusters, NUMA, and grid computing)



• Features beyond the Oracle database: Oracle Application Express, Fusion Middleware (including Oracle Application Server), and database SOA support as a Web services provider

The latest Oracle Database 11g features: query result set caching, Automatic Memory Management, the Real Application Testing, Advanced Compression, Total Recall, and Active Data Guard Option Options, changes to the OLAP Option (transparently accessed and managed as materialized views), the Flashback transaction command, transparent data encryption, the Support Workbench (and diagnosability infrastructure), and partitioning enhancements (including interval and new composite types)

For new Oracle users, DBAs, developers, and managers, Oracle Essentials provides an invaluable, all-in-one introduction to the full range of Oracle features and technologies, including the just-released Oracle Database 11g features. But even if you already have a library full of Oracle documentation, you'll find that this compact book is the one you turn to, again and again, as your one-stop, truly essential reference.

"Oracle Essentials gives a clear explanation of the key database concepts and architecture underlying the Oracle database. It's a great reference for anyone doing development or management of Oracle databases."

--Andrew Mendelsohn, Senior Vice President, Database Server Technologies, Oracle Corporation

Table of Contents

1. Chapter 1 Introducing Oracle

   1. The Evolution of the Relational Database

   2. The Oracle Database Family

   3. Summary of Oracle Database Features

   4. Database Application Development Features

   5. Database Connection Features

   6. Distributed Database Features

   7. Data Movement Features

   8. Database Performance Features

   9. Database Management Features

   10. Database Security Features

   11. Oracle Development Tools

   12. Embedded Databases

2. Chapter 2 Oracle Architecture

   1. Databases and Instances

   2. Deploying Physical Components

   3. Instance Memory and Processes

   4. The Data Dictionary

3. Chapter 3 Installing and Running Oracle

   1. Installing Oracle

   2. Creating a Database

   3. Configuring Oracle Net

   4. Starting Up the Database

   5. Shutting Down the Database

   6. Accessing a Database

   7. Oracle at Work

4. Chapter 4 Oracle Data Structures

   1. Datatypes

   2. Basic Data Structures

   3. Additional Data Structures

   4. Extended Logic for Data

   5. Data Design

   6. Constraints

   7. Triggers

   8. Query Optimization

   9. Understanding the Execution Plan

   10. SQL Advisors

   11. Data Dictionary Tables

5. Chapter 5 Managing Oracle

   1. Manageability Features

   2. Oracle Enterprise Manager

   3. Fragmentation and Reorganization

   4. Backup and Recovery

   5. Working with Oracle Support

6. Chapter 6 Oracle Security, Auditing, and Compliance

   1. Security

   2. Auditing

   3. Compliance

7. Chapter 7 Oracle Performance

   1. Performance Tuning Basics

   2. Oracle and Disk I/O Resources

   3. Oracle and Parallelism

   4. Oracle and Memory Resources

   5. Oracle and CPU Resources

   6. Database Resource Manager

8. Chapter 8 Oracle Multiuser Concurrency

   1. Basics of Concurrent Access

   2. Oracle and Concurrent User Access

   3. Oracle's Isolation Levels

   4. Oracle Concurrency Features

   5. How Oracle Handles Locking

   6. Concurrent Access and Performance

   7. Workspaces

9. Chapter 9 Oracle and Transaction Processing

   1. OLTP Basics

   2. Oracle's OLTP Heritage

   3. Architectures for OLTP

   4. Oracle Features for OLTP

   5. High Availability

   6. Oracle Streams and Advanced Queuing

   7. Object Technologies and Distributed Components

10. Chapter 10 Oracle Data Warehousing and Business Intelligence

    1. Business Intelligence Basics

    2. Data Warehouse Design

    3. Query Optimization

    4. Analytics, OLAP, and Data Mining in the Database

    5. Managing the Data Warehouse

    6. Other Software for the Data Warehouse

    7. The Metadata Challenge

    8. Best Practices

11. Chapter 11 Oracle and High Availability

    1. What Is High Availability?

    2. System Failure

    3. Protecting Against System Failure

    4. Recovering from Failures

    5. Complete Site Failure

    6. Data Redundancy Solutions

    7. Rolling Upgrades

12. Chapter 12 Oracle and Hardware Architecture

    1. System Basics

    2. Uniprocessor Systems

    3. Symmetric Multiprocessing Systems

    4. Clusters

    5. Non-Uniform Memory Access Systems

    6. Grid Computing

    7. Disk and Storage Technology

    8. Which Platform Deployment Solution?

13. Chapter 13 Oracle Distributed Databases and Distributed Data

    1. Accessing Multiple Databases As a Single Entity

    2. Moving Data Between Distributed Systems

14. Chapter 14 Oracle Extended Datatypes

    1. Object-Oriented Development

    2. Extensibility Features and Options

    3. Using the Extensibility Framework in Oracle

15. Chapter 15 Beyond the Oracle Database

    1. Application Express

    2. Oracle Fusion Middleware

    3. Oracle SOA Suite

1. Appendix What's New in This Book for Oracle Database 11g

   1. : Introducing Oracle

   2. : Oracle Architecture

   3. : Installing and Running Oracle

   4. : Data Structures

   5. : Managing Oracle

   6. : Oracle Security, Auditing, and Compliance

   7. : Oracle Performance

   8. : Oracle Multiuser Concurrency

   9. : Oracle and Transaction Processing

   10. : Oracle Data Warehousing and Business Intelligence

   11. : Oracle and High Availability

   12. : Oracle and Hardware Architecture

   13. : Oracle Distributed Databases and Distributed Data

   14. : Oracle Extended Datatypes

   15. : Beyond the Oracle Database

2. Appendix Additional Resources

   1. Web Sites

   2. Books and Oracle Documentation

      
      
      
      
      http://www.mediafire.com/?u52ctlilyta6c0y