Written by one the world's most widely-read Oracle script developers and author of 14 best-selling Oracle books, Mike Ault targets his substantial knowledge of Oracle tuning in this concise eBook.  With decades of experience using Oracle, Mike Ault shares secrets for Oracle data warehouse management.

This fantastic eBook discusses how to tune data warehouse applications and includes a discussion of the dbms_summary package, bitmap indexes and other critical data warehouse techniques.

About the Author:

Table of Contents:

 

Data Systems Architectures  Data Warehouse Concepts  Objectives:  Data Warehouse Terminology  Data Warehouse Storage Structures  Data Warehouse Aggregate Operations  Data Warehouse Structure  Objectives:  Schema Structures For Data Warehousing  Oracle and Data Warehousing    Oracle Features  Objectives:  Oracle Data Warehouse related Features  Oracle Features  Objectives:  Partitioned Tables and Indexes  Oracle Enhanced Parallel DML  Oracle Enhanced Optimizer Features  Oracle Enhanced Index Structures  Oracle Enhanced Internals Features  Backup and Recovery Using RMAN  Data Warehousing

Oracle Features  Objectives:  Oracle8i SQL Enhancements for Data Warehouses  Oracle8i Data Warehouse Table Options  Oracle8i and Tuning of Data Warehouses using Small Test Databases  Procedures in DBMS_STATS  Stabilizing Execution Plans in a Data Warehouse in Oracle  Oracle Materialized Views, Summaries and Data Warehousing  The DBMS_SUMMARY Package in Oracle  DIMENSION Objects in Oracle  Managing CPU Utilization for Data Warehouses in Oracle  Restricting Access by Rows in an Oracle Data Warehouse  DBMS_RLS Package    Data Warehouse Loading  IMPORT-EXPORT  Data Warehouse Tools  An Overview of Oracle Express Server  An Overview of Oracle Discoverer