Mastering Oracle Parallel Execution with Randolf Geist

Total time

Mastering Oracle Parallel Execution with Randolf Geist

Oracle University
Logo Oracle University
Provider rating: starstar_borderstar_borderstar_borderstar_border 2 Oracle University has an average rating of 2 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.
  • View related products with starting dates: Oracle.

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…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Oracle, CompTIA A+ / Network+ / Security+, IT Security, Retail (Management), and Security.

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

There are no reviews yet.
  • View related products with reviews: Oracle.

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.