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 guides and manuals. This tutorial claims a unique place among them. Rather than focusing on one area, the tutorial explains the foundational concepts of the Oracle technology and the core technical and business aspects of using it. This tutorial distills a vast amount of knowledge into easy-to-read lessons 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 tutorial 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 tutorial contains lessons 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
This tutorial is the perfect all-in-one source for understanding the complexities and capabilities of Oracle.
|
