Parallel Processing in Oracle Database 12c
Duration : 1 Day (8 Hours)
Parallel Processing in Oracle Database 12c Course Overview:
The Parallel Processing in Oracle Database 12c certification revolves around optimizing SQL operations by leveraging multiple CPU cores and diverse storage devices simultaneously, resulting in accelerated computing performance. This approach efficiently handles batch tasks, data warehousing queries, and sizable database requests, markedly reducing response times for data-intensive operations. Oracle’s Parallel Processing intelligently coordinates these tasks, ensuring optimal resource utilization. As a result, businesses can seamlessly execute intricate computations and data manipulations, leading to heightened operational efficiency and productivity gains.
- Database administrators interested in upgrading their Oracle Database skills.
- IT professionals seeking to understand parallel processing in Oracle Database.
- Software engineers working with Oracle Database 12c.
- Data analysts whose work involves large amounts of data processing.
- IT students learning about database management and optimization.
Learning Objectives of Parallel Processing in Oracle Database 12c:
The Parallel Processing in Oracle Database 12c course is structured to provide students with an extensive grasp of parallel processing capabilities and their strategic utilization for streamlined data management within Oracle Database 12c. Learners will develop proficiency in the proficient implementation of parallel processing to enhance database performance, including valuable insights into optimizing parallel operations and effective management of data in parallel processing mode. Additionally, the course covers the utilization of parallel execution to optimize data warehousing applications, encompassing configuration and monitoring of parallel execution servers. Furthermore, participants will gain expertise in administering parallel SQL statement execution and effectively troubleshooting parallel execution performance issues.
Module 1: Parallel execution concepts
- Benefits of parallel processing
- When to use parallel processing?
- Query Coordinator and parallel execution (PX) servers
- Parallel execution communication
- The producer / consumer model
- Execution plan basics
Module 2: Using Manual DOP
- Statements that can be parallelized
- SELECT with single parallel table scan and the explain plan
- SELECT with parallel hash join and the explain plan
- Parallelized SELECT with partition wise join and the advantages
- Parallelized DML operations
Module 3: Using Auto DOP
- Auto DOP versus manual DOP
- Auto DOP parameters
- Auto DOP behavior
- Impact of Auto DOP on other parameters
- SELECT explain plan with Auto DOP
- Auto DOP in RAC environment
Module 4: Using Statement Queuing
- Comparing statement queuing to minimal DOP guarantee
- Setting parameters
- When to choose statement queuing
- Using Database Resource Manager with statement queuing
- Viewing queued statements
Module 5: In-Memory Parallel Execution
- The goal of In-Memory Parallel Execution
- How SELECT works with and without in-memory parallel execution
- Set parameters to use In-Memory parallel execution
- In-memory PX examples
Module 6: Parallel Execution and Data Loading
- DataPump export / import
- External tables: applying parallel execution as best practice
Module 7: Troubleshoot situations when parallel processing does not proceed as desired
- When parallel processing does not proceed as desired
- When no parallel processing occurs
- When Auto DOP computes unexpected DOP
- When Statement Queuing starts unexpectedly
- When performance decreases due to parallel execution
- Tracing parallel execution
Module 8: Managing a Mixed Workload with DBRM
- Take advantage of DBRM to manage concurrent parallel executions with mixed workloads
- Use plan directives to manage concurrent parallel executions
- How to reject queries
- Using dynamic switching
- Understanding how directives interact
Parallel Processing in Oracle Database 12c Course Prerequisites:
• Basic understanding of Oracle Database architecture
• Proficiency in Oracle SQL and PL/SQL
• Knowledge of Database Administration
• Familiarity with data warehousing concepts
• Hands-on experience on Oracle Database 12c
• Understanding of real-time applications of parallel processing
Discover the perfect fit for your learning journey
Choose Learning Modality
This course comes with following benefits:
- Practice Labs.
- Get Trained by Certified Trainers.
- Access to the recordings of your class sessions for 90 days.
- Digital courseware
- Experience 24*7 learner support.
Got more questions? We’re all ears and ready to assist!