My Oracle Support Banner

11.2 New Feature : Using DBMS_PARALLEL_EXECUTE to Update Large Tables in Parallel (Doc ID 1066555.1)

Last updated on NOVEMBER 24, 2019

Applies to:

PL/SQL - Version 11.2.0.1.0 and later
Information in this document applies to any platform.
*** Checked for relevance on 23rd Jan 2019 ***

Purpose

The purpose of this article is to introduce the 11.2.0.x database new package DBMS_PARALLEL_EXECUTE and how it can used to update large tables in parallel using different chunking mechanism.

Scope

This is intended for PL/SQL programmers

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Overview
 Different ways of chunking method that the DBMS_PARALLEL_EXECUTE package offers:
 Pre-requisites before using the DBMS_PARALLEL_EXECUTE package:
 1. Sample code to create the chunks using the CREATE_CHUNKS_BY_ROWID procedure: 
 2. Sample code to create the chunks using the CREATE_CHUNKS_BY_NUMBER_COL procedure:
 3. Sample code to create the chunks using the CREATE_CHUNKS_BY_SQL procedure:

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.