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

Request more details:

submit request
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

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 :