Home   FAQs   New Arrivals   Specials   Pricing & Shipping   Location   Corporate Services   Why Choose Bookware?  
Call our store: 9955 5567 (from within Sydney) or 1800 734 567 (from outside Sydney)
 View Cart   Check Out   
Browse by Subject
 TAFE Accounting
 TAFE I.T./Computing
 TAFE - Other
 Windows 8
 Adobe CS6
 CCNA 2012
 CCNP 2012
 Web Design
 Project Management
 Mobile Devices
 Windows Server 2012
 SQL Server 2012
Economics and Business
 Business Information Systems
 Human Resources

Oracle Essentials 3rd Edition: Oracle Database 10g - For the 4th edition, please refer to ISBN: 0596514549 -

by: Rick Greenwald, Robert Stackow

Notify me when in stock

On-line Price: $59.95 (includes GST)

Paperback package 400

20%Off Retail Price

You save: $15.00

This item is available to backorder. Usually ships within 7 - 10 working days

Retail Price: $74.95

Publisher: O'REILLY,2004/03/01

Category: ORACLE Level:

ISBN: 0596005857
ISBN13: 9780596005856

Add to Shopping Cart

Full Description

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