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
Java Programming
Print PageOracle Database 10g: Implement Partitioning
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
View other Oracle Courses available
- 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:
Oracle Database 10g: Introduction To SQL – Complete Library And 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 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
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
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
Expaining 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
Expaining a Parallel Execution Plan
ADVANCED TUNING OF PARALLEL EXECUTION: