DBMS_PARALLEL_EXECUTE Description Table of Contents

The table of contents of the DBMS_PARALLEL_EXECUTE description that can be used from Oracle 11g R2 is compiled and uploaded. Clicking on each table of contents will take you to that article.

• 1. Overview of Parallel Processing of DML Jobs
  • 1.1. DML Parallel Processing Method
  • 1.2. DBMS_PARALLEL_EXECUTE concept
  • 1.3. Create tables and data for DBMS_PARALLEL_EXECUTE test
• 2. Parallel processing case of ROWID division method
  • 2.1. Create ROWID Partitioned Parallel Processing Jobs
  • 2.2. Split work unit
  • 2.3. job run
  • 2.4. Confirm task completion and delete
  • 2.5. Work unit division details check
    • 2.5.1. Uniformity of work units partitioned by ROWID
    • 2.5.2. Check that there are no missing units of work divided by ROWID
    • 2.5.3. Correlation between the number of work units (chunks) and the PARALLEL_LEVEL (the number of jobs to be executed)
• 3. NUMBER Column Split Method Parallel Processing Case
  • 3.1. create job
  • 3.2. Split work unit
  • 3.3. job run
  • 3.4. Confirm task completion and delete
• 4. User Defined SQL Partitioning Parallel Processing Case
  • 4.1. Overview of custom SQL partitioning methods
  • 4.2. Writing custom SQL
  • 4.3. Create test environment and test table
  • 4.4. create job
    • 4.4.1. create job
    • 4.4.2. Split work unit
  • 4.5. job run
  • 4.6. Confirm task completion and delete
• 5. Considerations

This is information that can be helpful to those who have worked as DBAs or data migrations, and those who plan to do so in the future. In particular, it is a method worth considering when parallel hints cannot be applied when processing large amounts of data. In addition, I think that the user-defined SQL partitioning method can be applied in various ways.

Related articles:

Oracle Character Set Conversion(8): 6. How to Convert User Implemented Character Set (1) Oracle Character Set Conversion (7): 5.4. KO16MSWIN949 Environment CSSCAN Execution Result Oracle Character Set Conversion(1): 1. Necessity, Correct Oracle Character Set Setup Guide 4. User-defined SQL partitioning method parallel processing case (DBMS_PARALLEL_EXECUTE) 3. NUMBER Column Split Method Parallel Processing Case (DBMS_PARALLEL_EXECUTE) 2.5. Detailed check of unit of work partitioning (DBMS_PARALLEL_EXECUTE) 2. ROWID partitioning parallel processing case (DBMS_PARALLEL_EXECUTE) 1. Overview of parallel processing of DML jobs (DBMS_PARALLEL_EXECUTE)