My Oracle Support Banner

Example for Concurrent Execution of Union All, a 12c Feature (Doc ID 1586225.1)

Last updated on NOVEMBER 07, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Goal

This article provides example for Concurrent Execution of Union All feature in 12c.

Solution

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
Goal
Solution
 Background
 Example script
 
 Output
 Concurrent union all with local serial and parallel branches
 Sequential union all with local serial branches
 Concurrent union all with local and remote serial and parallel branches
 NOT Concurrent union all with local and remote serial and parallel branches
 NOT Concurrent union when optimizer_features_enable is set to less than 12
 Concurrent union all forced with PQ_CONCURRENT_UNION hint when when optimizer_features_enable is set to less than 12
References

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