Company Profile Newsletter IT Training Business Training Coaching Consulting Schedule Accreditations Contact Us
Popular Topics:
SharePoint Training Crystal Reports Training Photoshop Training Oracle Training Microsoft Excel Training
Project Management Training Finance Training Effective Management Training
Oracle Database 11g: SQL Fundamentals I 
Print PageOracle Database 10g: Implement Parallel SQL & Partitioning For Data Warehouses
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.
- Cost: Price on application
- Duration: 3 Days
- This course is not available as part of our public schedule but can be provided on a customised client specific basis.
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
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
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
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
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
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
PARTITION-AWARE OPTIMIZATION
PARALLEL PROCESSING WITHIN THE ORACLE DATABASE :
HARDWARE CONFIGURATIONS
ORACLE INSTANCE PARALLEL PROCESSING
ABOUT DATABASE PARALLEL SQL EXECUTION
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
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 :