In this article I will explain what DBMS_PARALLEL_EXECUTE is and give an example of it’s use. DBMS_PARALLEL_EXECUTE is an Oracle Supplied package which was introduced with Oracle Database 11g Release 2. It allows you to execute a SQL or PLSQL statement in parallel. At a high level DBMS_PARALLEL_EXECUTE works by performing the following steps: Group …

Continue reading