Mastering Oracle Parallel Execution with Randolf Geist
Starting dates and places
Description
In order to process large amounts of data as quickly as possible and leverage the capabilities of today's hardware Oracle offers its Parallel Execution feature as part of the Enterprise Edition license. However as with most features there's no "go_faster = true" switch, and Parallel Execution is no exception to this rule. There might be a lot of cases where simply adding parallelism to a statement execution doesn't deliver the expected reduction in runtime. It's therefore crucial to understand how Oracle Parallel Execution works, what its building blocks are, what kind of diagnostic possibilities are offered to systematically analyze Parallel Execution performance and how to apply appropriat…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
In order to process large amounts of data as quickly as possible and leverage the capabilities of today's hardware Oracle offers its Parallel Execution feature as part of the Enterprise Edition license. However as with most features there's no "go_faster = true" switch, and Parallel Execution is no exception to this rule. There might be a lot of cases where simply adding parallelism to a statement execution doesn't deliver the expected reduction in runtime. It's therefore crucial to understand how Oracle Parallel Execution works, what its building blocks are, what kind of diagnostic possibilities are offered to systematically analyze Parallel Execution performance and how to apply appropriate measures.
Audience
- Developer
- Database Administrators
Course Topics Introduction to Oracle's runtime engine: How Oracle executes a SQL statement Execution plans: How to read and understand execution plans Introduction to Oracle's Parallel Execution feature How Oracle executes a statement in parallel How to read parallel execution plans The importance of Distribution Methods Parallel Execution and the Partitioning option Understanding and using Parallel Execution statistics Parallel Execution and the Resource Manager
Course Objectives
- Understand the building blocks of Parallel Execution
- Identify potentially inefficient Parallel Execution plans
- Identify poorly performing Parallel Execution plans
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.