Book description
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
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
Publisher resources
Table of contents
- Dedication
- Preface
-
1. Introducing Oracle
- The Evolution of the Relational Database
- The Oracle Database Family
- Summary of Oracle Database Features
- Database Application Development Features
- Database Connection Features
- Distributed Database Features
- Data Movement Features
- Database Performance Features
- Database Management Features
- Database Security Features
- Oracle Development Tools
- Embedded Databases
- 2. Oracle Architecture
-
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. Oracle Data Structures
- 5. Managing Oracle
-
6. Oracle Security, Auditing, and Compliance
-
Security
- Usernames, Privileges, Groups, and Roles
- Identity Management
- Security Privileges
- Special Roles: DBA, SYSDBA, and SYSOPER
- Policies
- Restricting Data Access
- Label Security Option
- Security and Application Roles and Privileges
- Distributed Database and Multitier Security
- Advanced Security Option
- Encryption
- Secure Backup
- Auditing
- Compliance
-
Security
- 7. Oracle Performance
- 8. Oracle Multiuser Concurrency
- 9. Oracle and Transaction Processing
- 10. Oracle Data Warehousing and Business Intelligence
-
11. Oracle and High Availability
- What Is High Availability?
- System Failure
- Protecting Against System Failure
- Recovering from Failures
- Complete Site Failure
- Data Redundancy Solutions
- Rolling Upgrades
- 12. Oracle and Hardware Architecture
- 13. Oracle Distributed Databases and Distributed Data
- 14. Oracle Extended Datatypes
- 15. Beyond the Oracle Database
-
A. What’s New in This Book for Oracle Database 11g
- Chapter 1: Introducing Oracle
- Chapter 2: Oracle Architecture
- Chapter 3: Installing and Running Oracle
- Chapter 4: Data Structures
- Chapter 5: Managing Oracle
- Chapter 6: Oracle Security, Auditing, and Compliance
- Chapter 7: Oracle Performance
- Chapter 8: Oracle Multiuser Concurrency
- Chapter 9: Oracle and Transaction Processing
- Chapter 10: Oracle Data Warehousing and Business Intelligence
- Chapter 11: Oracle and High Availability
- Chapter 12: Oracle and Hardware Architecture
- Chapter 13: Oracle Distributed Databases and Distributed Data
- Chapter 14: Oracle Extended Datatypes
- Chapter 15: Beyond the Oracle Database
-
B. Additional Resources
- Web Sites
-
Books and Oracle Documentation
- Chapter 1: Introducing Oracle
- Chapter 2: Oracle Architecture
- Chapter 3: Installing and Running Oracle
- Chapter 4: Data Structures
- Chapter 5: Managing Oracle
- Chapter 6: Oracle Security, Auditing, and Compliance
- Chapter 7: Oracle Performance
- Chapter 8: Oracle Multiuser Concurrency
- Chapter 9: Oracle and Transaction Processing
- Chapter 10: Oracle Data Warehousing and Business Intelligence
- Chapter 11: Oracle and High Availability
- Chapter 12: Oracle and Hardware Architecture
- Chapter 13: Oracle Distributed Databases and Distributed Data
- Chapter 14: Oracle Extended Datatypes
- Chapter 15: Beyond the Oracle Database
- Index
- About the Authors
- Colophon
- Copyright
Product information
- Title: Oracle Essentials, 4th Edition
- Author(s):
- Release date: November 2007
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596514549
You might also like
book
Oracle Essentials, 3rd Edition
An enormous system comprising myriad technologies, options, and releases, Oracle's complexities have spawned numerous areas of …
book
Oracle Essentials, 5th Edition
Written by Oracle insiders, this indispensable guide distills an enormous amount of information about the Oracle …
book
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition
The second edition of O'Reilly's bestselling Oracle Essentials has been updated to include the latest Oracle …
book
Oracle
Oracle Performance Survival Guide A Systematic Approach to Database Optimization The fast, complete, start-to-finish guide to …