Oracle Database 10g: Parallelism and Scalability Overview Seminar


--------------------------------------------------------------------------------
What you will learn

The seminar starts with an introduction to parallelism and scalability, and the architecture that supports the speed up or scale up of certain types of application workloads. Students also learn about the internals of parallel execution, the parallel slave pool, the parallel execution coordinator, parallel execution plans, and row distribution.



The seminar discusses the types of operations that may be done in parallel both for DBA and for developers as well as methods for tuning memory requirements and the use of the parallel slaves. Diagnostic and administrative v$ views are also discussed in detail in support of these objectives. The seminar will also include discussion of certain parallel hints and initialization parameters.

Learn To:
Determine when partition wise join is used
Describe locking behavior for parallel DML operations
Set initialization parameters relating to parallel operations tuning
Tune PDML operations



Audience
Database Administrators
Sales Consultants
Support Engineer
Technical Administrator
Technical Consultant


Prerequisites
Knowledge of basic database administration
Oracle Database 10g: Administration Workshop I Release 2


Course Objectives
Understand the benefit of using parallel operations
Describe system conditions under which to use parallel operations
Describe how parallel operations work
Query dynamic performance views relation to parallel operations tuning
Determine your memory requirement needs


--------------------------------------------------------------------------------

Course Topics

Parallelism Concepts
Introduction to Parallel Execution
System Conditions to Implement Parallelism
Operations That Can Be Parallelized
Parallelization Rules
How Parallel Execution Works
Parallel Operations
Parallel Execution with Real Application Clusters
Using Parallelization Hints

Types of Parallel Operations
Parallel Partitioned Table & Index Scan
Partition wise Joins
Non-Partition-Wise, Partial Partition-Wise & Full Partition-Wise Join Example
Space Management for Parallel DDL
Fragmentation and Parallelism
Creating Indexes in Parallel
When to Use Parallel DML
Performance Benefits of Parallel DML

Monitoring and Tuning Parallel Operations
Tuning Parameters for Parallel Execution
Balancing the Workload
Resource Manager and the DOP
Data Warehousing Scenario
Data Distribution and V$PQ_TQSTAT
Using Other Dynamic Performance Views


--------------------------------------------------------------------------------

ppt

值得一读

多谢楼主分享！！！

谢谢！

thanks