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