Oracle Essentials: Oracle Database 11g

Oracle Essentials: Oracle Database 11g

Rick Greenwald, Robert Stackowiak

Language: English

Pages: 408

ISBN: 0596514549

Format: PDF / Kindle (mobi) / ePub

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















provide the best example of how high availability can be implemented with hardware. Disk redundancy Although the mean time to failure of an individual disk drive is very high, the ever-increasing number of disks used for today's very large databases results in more frequent failures. Protection from disk failure is usually accomplished using RAID (Redundant Array of Inexpensive Disks) technology. The use of redundant storage has become common for systems of all sizes and types for two

leverage TAF by writing "failover-aware" applications that resubmit transactions that were lost when the client's primary instance failed, further reducing the impact of failure. Note that unlike query resubmission, TAF itself doesn't automatically resubmit the transactions that were in-flight. Rather, it provides a framework for a seamless failover that can be leveraged by application developers. How TAF works TAF is implemented in the Oracle Call Interface (OCI) layer, a low-level API

relational database engine to support the storage and manipulation of these nontraditional datatypes through the introduction of additional features and options. Oracle has also extended the types of data, the SQL that manipulates that data, and the basic Oracle service framework so that you can modify the data and extend its capabilities even further. Object-Oriented Development An object-oriented approach to software development shifts the focus from building computing procedures that

and Paul Manning, EMC Corporation, 1998. Oracle Database Backup and Recovery Basics. Redwood Shores, CA: Oracle Corporation, 2007. Oracle Database Concepts. Redwood Shores, CA: Oracle Corporation, 2007. Oracle Data Guard Concepts and Administration. Redwood Shores, CA: Oracle Corporation, 2007. Oracle High Availability Overview. Redwood Shores, CA: Oracle Corporation, 2007. Oracle Streams Replication Administrator's Guide. Redwood Shores, CA: Oracle Corporation, 2007. Chapter 12: Oracle

indexes Java, Java, Installing Oracle JServer, Java's Role and Web Services materialized views, Views Objects and Extensibility features, Object-Oriented Development OLTP enhancements, Architectures for OLTP redo log archiving, Oracle Data Guard management TAF (Transparent Application Failover) enhancements, Oracle Transparent Application Failover transportable tablespaces, Data Movement Features triggers, Java, Query Optimization Oracle9i, SQL, National Language Support, Oracle

Download sample