Greenwald R., Stackowiak R., Stern J. Oracle Essentials Oracle Database 11g

4th edition. — O’Reilly, 2007. — 406 p.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. 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. 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. 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. 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) 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)This book is divided into 15 chapters and 2 appendixes, as follows:
Introducing Oracle describes the range of Oracle products and features and provides a brief history of Oracle and relational databases.
Oracle Architecture describes the core concepts and structures (e.g. , files,
processes, and so on) that are the architectural basis of Oracle.
Installing and Running Oracle briefly describes how to install Oracle and how to configure, start up, and shut down the database and Oracle Net.
Oracle Data Structures summarizes the various datatypes supported by Oracle and introduces the Oracle objects (e.g. , tables, views, indexes). This chapter also covers query optimization.
Managing Oracle provides an overview of managing an Oracle system, including the advisors available as part of Oracle Database 11g, using Oracle Enterprise Manager (EM), dealing with database fragmentation and reorganization using current database releases, information lifecycle management, and working with Oracle Support.
Oracle Security Auditing, and Compliance, provides an overview of basic Oracle security, Oracle’s security options, basic auditing capabilities, and ways you can leverage the Oracle Database Vault Option and the Audit Vault Server to meet compliance needs.
Oracle Performance describes the main issues relevant to Oracle performance—especially the major performance characteristics of disk, memory, and CPU tuning. It describes how Oracle Enterprise Manager, the Automatic Workload Repository, and the Automatic Database Diagnostic Monitor are used for performance monitoring and management, as well as parallelism and memory management in Oracle.
Oracle Multiuser Concurrency describes the basic principles of multiuser concurrency (e.g. , transactions, locks, integrity problems) and explains how Oracle handles concurrency.
Oracle and Transaction Processing describes online transaction processing (OLTP) in Oracle.
Oracle Data Warehousing and Business Intelligence describes the basic principles of data warehouses and business intelligence, Oracle database features used for such solutions, Oracle’s business intelligence tools, relevant options such as OLAP and Data Mining, and best practices.
Oracle and High Availability discusses availability concepts, what happens when the Oracle database recovers, protecting against system failure, Oracle’s backup and recovery facilities, and high availability and failover solutions.
Oracle and Hardware Architecture describes your choice of computer architectures, configuration considerations, and deployment strategies for Oracle, including grid computing.
Oracle Distributed Databases and Distributed Data briefly summarizes the Oracle facilities used in distributed processing including two-phase commits and Streams Advanced Queuing and replication.
Oracle Extended Datatypes describes Oracle’s object-oriented features, Java’sTM role, web services support, multimedia extensions to the Oracle datatypes, content management using the database, spatial capabilities, and the extensibility framework.
Chapter 15, Beyond the Oracle Database, describes Oracle Application Express, deploying to the Web using the Oracle Application Server and Fusion Middleware, and the overall use of Oracle in a Service-Oriented Architecture (SOA) environment.
Appendix A, What’s New in This Book for Oracle Database 11g, lists the Oracle Database 11g changes described in this book.
Appendix B, Additional Resources, lists a variety of additional resources—both online and offline—so you can do more detailed reading.