Oracle Database 10g: Implement Partitioning

Request more details:

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 target audience for this course is database administrators, data warehouse administrators, and senior application developers.

View other Oracle Courses available
Prerequisites:
Oracle Database 10g: Introduction To SQL Complete Library And 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 Index
Create Local partirioned Indexes
Create Global Partitioned Indexes
Table Maintenance Impact on Index Partitions
Managing Index Partitrions and Sub Partitions
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
Expaining a Parallel Execution Plan
ADVANCED TUNING OF PARALLEL EXECUTION: