Oracle Database 10g: Implement Parallel SQL & Partitioning For Data Warehouses

Course Description

As the size of databases and data warehouses increases, one cannot rely upon the default features of the Oracle database to sufficiently process such massive volumes of information. One must employ advanced features intended for such environments. In fact, these features are at the same time, among the most powerful tuning options available within the Oracle database yet some of the least understood and utilized. The purpose of this course is to equip database professionals with the skills to utilize such advanced features.

View other Oracle Courses available

3 Days
Contact us for pricing
Contact us for dates
Contact us for dates

Prerequisites

The following courses are mandatory prerequisites for taking this course:
The Sideris course ORACLE DATABASE 10G: INTRODUCTION TO SQL 1 and 2.
The Sideris course ORACLE DATABASE 10G: SQL TUNING

ABOUT PARTITIONING & PARALLELIZATION

ABOUT THE ARCHITECTURE
METHODS OF PARTITIONING

CREATING PARTITIONED TABLES

CREATE A RANGE PARTITIONED TABLE
CREATE A HASH PARTITIONED TABLE
CREATE A LIST PARTITIONED TABLE
CREATE A RANGE-HASH PARTITIONED TABLE
CREATE A RANGE-LIST PARTITIONED TABLE
PARTITION SCENARIOS

MANAGING TABLE PARTITIONS

USING SUBPARTITION TEMPLATES
MANAGING TABLE PARTITIONS & SUBPARTITIONS

CREATING & MANAGING PARTITIONED INDEXES

ABOUT PARTITIONED INDEXES
CREATE LOCAL PARTITIONED INDEXES
CREATE GLOBAL PARTITIONED INDEXES
TABLE MAINTENANCE IMPACT ON INDEX PARTITIONS
MANAGING INDEX PARTITIONS & SUBPARTITIONS
EQUI-PARTITIONING OF TABLES

THE PARTITION-AWARE OPTIMIZER

SETUP FOR OPTIMIZATION MONITORING
PARTITION-AWARE OPTIMIZATION

PARALLEL PROCESSING WITHIN THE ORACLE DATABASE

HARDWARE CONFIGURATIONS
ORACLE INSTANCE PARALLEL PROCESSING
ABOUT DATABASE PARALLEL SQL EXECUTION

ENABLING & TUNING PARALLEL SQL EXECUTION

ENABLING PARALLEL EXECUTION
CONTROLLING THE DEGREE OF PARALLELISM
MANUALLY TUNING PARALLEL OPERATIONS
About PARALLEL_THREADS_PER_CPU & The Default DOP
PARALLEL PROCESSING OPTIMIZER HINTS
[NO]PARALLEL
[NO]APPEND
[NO]PARALLEL_INDEX
EXPLAINING A PARALLEL EXECUTION PLAN

ADVANCED TUNING OF PARALLEL EXECUTION