Thursday, October 18, 2012

DBMS_PARALLEL_EXECUTE - base table to be broken down into smaller chunks which can be run in parallel

DBMS_PARALLEL_EXECUTE package contains API's to chunk a table into smaller units and execute those chunks in parallel. The DBMS_PARALLEL_EXECUTE package allows a workload associated with a base table to be broken down into smaller chunks which can be run in parallel. This process involves several distinct stages.

I was forgotten the power of this  "Do-it-yourself (DIY) parallelism by Asktom"  now available as package "DBMS_PARALLEL_EXECUTE "since version 11g



Below examples from oracle-base.com site.