Productivity Skills

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 Tasks 1.1. DML Parallel Processing Method 1.2. DBMS_PARALLEL_EXECUTE concept 1.3. Create table and data for DBMS_PARALLEL_EXECUTE test 2. ROWID Partitioning Method Parallel Processing Example 2.1. ROWID Partitioning Parallel Processing...

Let's take a look at the case of user-defined SQL partitioning parallelism using Oracle DBMS_PARALLEL_EXECUTE. It covers writing user-defined SQL, test environment, job creation, job division, job execution, job completion confirmation and deletion. This is a continuation of the previous article. 3. NUMBER...

Let's take a look at the case of NUMBER Column partitioning parallel processing using Oracle DBMS_PARALLEL_EXECUTE. It covers job creation, job unit division, job execution, job completion confirmation, and deletion. This is a continuation of the previous article. 2.5. Check the details of work unit division (DBMS_PARALLEL_EXECUTE) 3. Parallel processing example of NUMBER column division method Let's look at an example of division method by NUMBER column. ROWID method and almost...

This is related to checking the details of work unit division. Examine the degree to which the result of dividing work units (chunks) by ROWID is evenly divided, whether the sum of work units is the same as the whole, and whether there are no omissions, and the correlation between the number of work units and the number of jobs. This is a continuation of the previous article. 2. Parallel processing case of ROWID division method 2.5. Split work unit...

Let's take a look at the case of ROWID partitioning method parallel processing using Oracle DBMS_PARALLEL_EXECUTE. This is a continuation of the previous article. 1. Overview of Parallel Processing of DML Tasks (DBMS_PARALLEL_EXECUTE) 2. Example of ROWID Partitioning Parallel Processing 2.1. Create a ROWID partitioning parallel processing task CREATE_TASK( ) to create the task. The result of the job creation can be checked as follows. From the above result, it can be confirmed that the Task has been created and the STATUS is CREATED. Note that,...

Introduces DBMS_PARALLEL_EXECUTE, which can be used from Oracle 11g R2, and examines use cases. Image source: https://blogs.oracle.com/warehousebuilder/parallel-processing-with-dbmsparallelexecute 1. Overview of Parallel Processing of DML Tasks 1.1. DML Parallel Processing Method Parallel Processing is used when you want to quickly process one DML (INSERT, UPDATE, DELETE) job in the database by using as many resources as possible. There are two main methods of parallel processing. first...