This book is divided into 15 chapters and 2 appendixes, as follows:
Chapter 1, Introducing Oracle, describes the range of Oracle products and features
and provides a brief history of Oracle and relational databases.
Chapter 2, Oracle Architecture, describes the core concepts and structures (e.g., files,
processes, and so on) that are the architectural basis of Oracle.
Chapter 3, Installing and Running Oracle, briefly describes how to install Oracle and
how to configure, start up, and shut down the database and Oracle Net.
Chapter 4, 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.
Chapter 5, 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
Chapter 6, Oracle Security, Auditing, and Compliance, provides an overview of basic
Oracle security, Oracle셲 security options, basic auditing capabilities, and ways you
can leverage the Oracle Database Vault Option and the Audit Vault Server to meet
compliance needs.
Chapter 7, 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
Chapter 8, Oracle Multiuser Concurrency, describes the basic principles of multiuser
concurrency (e.g., transactions, locks, integrity problems) and explains how Oracle
handles concurrency.
Chapter 9, Oracle and Transaction Processing, describes online transaction processing
(OLTP) in Oracle.
Chapter 10, Oracle Data Warehousing and Business Intelligence, describes the basic
principles of data warehouses and business intelligence, Oracle database features
used for such solutions, Oracle셲 business intelligence tools, relevant options such as
OLAP and Data Mining, and best practices.
Chapter 11, Oracle and HighAvailability , discusses availability concepts, what happens
when the Oracle database recovers, protecting against system failure, Oracle셲
backup and recovery facilities, and high availability and failover solutions.
Chapter 12, Oracle and Hardware Architecture, describes your choice of computer
architectures, configuration considerations, and deployment strategies for Oracle,
including grid computing.
Chapter 13, 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.
Chapter 14, Oracle Extended Datatypes, describes Oracle셲 object-oriented features,
Java셲꽓 role, web services support, multimedia extensions to the Oracle datatypes,
content management using the database, spatial capabilities, and the extensibility
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셲 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봟oth
online and offline봲o you can do more detailed reading
Related Documents
  1. [Ebook] Teach Yourself Oracle 8 In 21 Days (6616)
  2. [Ebook] Mastering Oracle SQL (4993)
  3. MySQL Tutorial (5334)
  4. MySQL Performance testing blog (1535)
  5. Looking for resources for Upgrade Testing of MySQL? (1802)
  6. How Database Testing works (3171)
  7. [Free] DTM Data Comparer : compare 2 database (4073)
  8. [Ebook] The Data Warehouse ETL Toolkit (9996)
  9. SQL Server Performance Testing articles (2026)
  10. [Free] SQL check : SQL Server Performance testing tool (2713)
  11. [Ebook] Beginning Database Design: From Novice to Professional (5593)
  12. Database Interview Questions (109 Questions) (4295)
  13. 2011-04-11, MySQL Conference & Expo @ USA (9084)
  14. [Free] MSSQL.DataMask : Quickly Anonymize Production Data into Test Data (4759)
  15. SQL Structured Test Data (2617)
  16. RDBMS Concepts for Database Testing (3051)
  17. SQL Function "Joins" for Database testing (3385)
  18. Oracle Database 10g : PL/SQL Fundamentals (990)
  19. Test Data v횪 Initial Data (3437)
  20. What is Test Data ? Why is it Important? (2577)