Oracle Database Release 11.2.0.2 introduced several new features directly related to parallelization of SQL statements, including Auto Degree of Parallelism (ADOP) and In-Memory Parallel Execution (IMPE). Oracle DBA and Oracle University instructor Jim Czuprynski will demonstrate how to implement these latest parallelism features to provide maximum performance benefits - for DML as well as queries - within your Oracle 11gR2 database environments.
Through presentations and online demonstrations, this session will:
- Explore the new parallelism features, especially ADOP and IMPE, in Oracle Database 11.2.0.2
- Explain how to implement the appropriate initialization parameters, hints, and object decoration to influence parallelism for maximum effectiveness
- Demonstrate how to use the feature set of the DBMS_PARALLEL_EXECUTE package to apply these new parallelism features to DML statements
1. Parallelism in Oracle 11.2.0.2: A Whole New Ballgame
2. Object “Decoration”
3. Policies for Parallelism
a. PARALLEL_DEGREE_POLICY and PARALLEL_MIN_TIME_THRESHOLD
b. PARALLEL_THREADS_PER_CPU
c. PARALLLEL_TARGET_PERCENTAGE and PARALLEL_DEGREE_LIMIT
d. PARALLEL_SERVERS_TARGET and PARALLEL_QUEUE_TIMEOUT
4. Putting It All Together: Some Practical Demonstrations
5. Parallelizing Batch Operations
a. DBMS_PARALLEL_EXECUTE
b. “Chunking” Batch Operations in Parallel
6. Monitoring Parallel Execution
7. Conclusions