ORA10g004 - Oracle Database 10g: Implement Parallel SQL and Data Partitioning for Data Warehouses
Course
ORA10g004
Price:
$1,725.00
Software Assurance Value:
Not Eligible
Duration:
3 Days
SQLSoft Course ora10g004 Oracle Database 10g: Parallel SQL
Table of Contents
Introduction
Audience
At Course Completion
Prerequisites
Certified Professional Exams
Student Materials
Course Outline
Introduction
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.
Return to Top
Audience
The target audience for this course is database administrators, data warehouse
administrators, and senior application developers. In fact, managers and any
other information technology or database professionals who will interact with
very large databases (VLDB) would benefit from this course.
Return to Top
At Course Completion
Major subject areas to be considered are:
- The full range of table partitioning options, including range, hash, list,
and composite partitioning schemes.
- The full range of index partitioning options, including local and global
partitioned indexes.
- Discuss the broad conceptual rationales one may base partition schemes
on. These various possibilities are illustrated using two different sample
data models.
- The performance benefits of using database object partitions and monitoring
the execution of SQL statements under the control of the partition-aware Optimizer.
- Understanding the operations within a complex SQL execution plan which
operates in parallel upon partitioned objects.
- General principles of parallel processing and their use in Oracle database
technology.
- The specific feature of parallel SQL execution and the configuration options
available to activate and administer this technology.
Return to Top
Prerequisites
Before attending this course, students must have:
- Completed ora10g008, Oracle Database 10g: Introduction
to SQL I, or equivalent.
- Completed ora10g009, Oracle Database 10g: Introduction
to SQL II, or equivalent.
- Completed ora10g101, Oracle Database 10g: Program
With PL/SQL, or equivalent.
The following prerequisites are recommended:
- Completed ora10g201, Oracle Database 10g: Administration
I, or equivalent.
- Completed ora10g003, Oracle Database 10g: SQL
Tuning, or equivalent.
- Completed ora10g204, Oracle Database 10g: New
Features for Administrators, or equivalent.
- Completed ora10g203, Oracle Database 10g: Data
Warehouse Administration, or equivelent.
Return to Top
Certified Professional Exams
No exam currently exists for this course.
Return to Top
Student Materials
The student kit includes a comprehensive workbook and other necessary materials
for this class.
Return to Top
Course Outline
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
Return to Top
