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. 

• Create a task

• Split the workload into chunks

• CREATE_CHUNKS_BY_ROWID

• CREATE_CHUNKS_BY_NUMBER_COL

• CREATE_CHUNKS_BY_SQL

• Run the task

• RUN_TASK

• User-defined framework

• Task control

• Check the task status

• Drop the task