{"id":11873,"date":"2022-10-02T18:32:15","date_gmt":"2022-10-02T09:32:15","guid":{"rendered":"https:\/\/prodskill.com\/?p=11873"},"modified":"2022-10-04T23:55:33","modified_gmt":"2022-10-04T14:55:33","slug":"oracle-dbms-parallel-execute-3-chunk-by-number-column","status":"publish","type":"post","link":"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/","title":{"rendered":"3. NUMBER Column Split Method Parallel Processing Case (DBMS_PARALLEL_EXECUTE)"},"content":{"rendered":"<p>Let&#039;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.<\/p>\n\n\n\n<p>This is a continuation of the previous article.<\/p>\n\n\n\n<p><a href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\/\">2.5. Detailed check of unit of work partitioning (DBMS_PARALLEL_EXECUTE)<\/a><\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">&lt;&lt;Table of Contents&gt;&gt;<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/#3_NUMBER_Column_%EB%B6%84%ED%95%A0_%EB%B0%A9%EC%8B%9D_%EB%B3%91%EB%A0%AC_%EC%B2%98%EB%A6%AC_%EC%82%AC%EB%A1%80\" >3. NUMBER Column Split Method Parallel Processing Case<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/#31_%EC%9E%91%EC%97%85_%EC%83%9D%EC%84%B1\" >3.1. create job<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/#32_%EC%9E%91%EC%97%85_%EB%8B%A8%EC%9C%84_%EB%B6%84%ED%95%A0\" >3.2. Split work unit<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/#33_%EC%9E%91%EC%97%85_%EC%8B%A4%ED%96%89\" >3.3. job run<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/#34_%EC%9E%91%EC%97%85_%EC%99%84%EB%A3%8C_%ED%99%95%EC%9D%B8_%EB%B0%8F_%EC%82%AD%EC%A0%9C\" >3.4. Confirm task completion and delete<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"3._NUMBER_Column_\ubd84\ud560_\ubc29\uc2dd\uc758_\ubcd1\ub82c_\ucc98\ub9ac_\uc0ac\ub840\"><span class=\"ez-toc-section\" id=\"3_NUMBER_Column_%EB%B6%84%ED%95%A0_%EB%B0%A9%EC%8B%9D_%EB%B3%91%EB%A0%AC_%EC%B2%98%EB%A6%AC_%EC%82%AC%EB%A1%80\"><\/span>3. NUMBER Column Split Method Parallel Processing Case<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Let&#039;s look at an example of partitioning by NUMBER Column. It is almost similar to the ROWID method, only the following items are slightly different.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Use the CREATE_CHUNKS_BY_NUMBER_COL procedure when dividing work units<\/li><li>NUMBER column is used in the WHERE clause of the SQL statement when executing the job.<\/li><\/ul>\n\n\n\n<p>* Reference Oracle documentation: <a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/appdev.112\/e40758\/d_parallel_ex.htm#ARPLS67355\" target=\"_blank\" rel=\"noreferrer noopener\">DBMS_PARALLEL_EXECUTE \u2013 CREATE_CHUNKS_BY_NUMBER_COL Procedure<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"3.1._\uc791\uc5c5_\uc0dd\uc131\"><span class=\"ez-toc-section\" id=\"31_%EC%9E%91%EC%97%85_%EC%83%9D%EC%84%B1\"><\/span>3.1. create job<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>There is no difference in how the task is created.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">-- 1\ub2e8\uacc4: \uc791\uc5c5\uc0dd\uc131\nBEGIN\n  DBMS_PARALLEL_EXECUTE.CREATE_TASK(TASK_NAME => 'DPE_TEST(BY NUMBER)');\nEND;\n\/\n\n-- \uc791\uc5c5 \uc0dd\uc131 \ud655\uc778\nSELECT *\n  FROM USER_PARALLEL_EXECUTE_TASKS\n WHERE TASK_NAME = 'DPE_TEST(BY NUMBER)';<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"3.2._\uc791\uc5c5_\ub2e8\uc704_\ubd84\ud560\"><span class=\"ez-toc-section\" id=\"32_%EC%9E%91%EC%97%85_%EB%8B%A8%EC%9C%84_%EB%B6%84%ED%95%A0\"><\/span>3.2. Split work unit<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>CREATE_CHUNKS_BY_NUMBER_COL( ,<table> ,<table> ,<table> , ) to divide the unit of work.<\/p>\n\n\n\n<p>Execute as follows to create chunks that are divided into 10,000 cases based on the \u201cID\u201d column of the Z_DPE_TEST_TAB table.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">-- 2\ub2e8\uacc4: \uc791\uc5c5 \ub2e8\uc704 \ubd84\ud560\nBEGIN\n  DBMS_PARALLEL_EXECUTE.CREATE_CHUNKS_BY_NUMBER_COL (\n            TASK_NAME    => 'DPE_TEST(BY NUMBER)',\n            TABLE_OWNER  => USER,\n            TABLE_NAME   => 'Z_DPE_TEST_TAB',\n            TABLE_COLUMN => 'ID',\n            CHUNK_SIZE   => 10000);\nEND;<\/pre>\n\n\n\n<p>Let&#039;s check the division state of the unit of work.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">-- \uc791\uc5c5 \ubd84\ud560 \uc0c1\ud0dc \ud655\uc778\nSELECT *\n  FROM USER_PARALLEL_EXECUTE_CHUNKS\n WHERE TASK_NAME = 'DPE_TEST(BY NUMBER)'\n ORDER BY START_ID;<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-57.png\"><img loading=\"lazy\" decoding=\"async\" width=\"883\" height=\"537\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-57.png\" alt=\"\uc791\uc5c5 \ubd84\ud560 \uc0c1\ud0dc\" class=\"wp-image-11874\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-57.png 883w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-57-300x182.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-57-768x467.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-57-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-57-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-57-36x22.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-57-48x29.png 48w\" sizes=\"auto, (max-width: 883px) 100vw, 883px\" \/><\/a><figcaption>work split status<\/figcaption><\/figure>\n<\/div>\n\n\n<p>As you can see roughly from the above result, each chunk is divided into 10,000 rows. (The example table generated sequential numbers from 1 to 1 million as ID values)<\/p>\n\n\n\n<p>For reference, when ROWID split (CREATE_CHUNKS_BY_ROWID procedure), values are created in START_ROWID and END_ROWID, and when NUMBER column split (CREATE_CHUNKS_BY_NUMBER_COL), values are created in START_ID and END_ID.<\/p>\n\n\n\n<p>Let&#039;s check if the work units (chunks) are evenly distributed.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">-- \uc791\uc5c5 \ubd84\ud560 \uade0\ub4f1 \ud655\uc778\n-- Chunk\uc758 START_ID, END_ID range\ub85c \ucd94\ucd9c\ud55c Row Count\nSELECT  B.CHUNK_ID, COUNT(A.ID) ROW_COUNT\n  FROM  Z_DPE_TEST_TAB A,\n        (\n        SELECT  CHUNK_ID, START_ID, END_ID\n          FROM  USER_PARALLEL_EXECUTE_CHUNKS\n         WHERE  TASK_NAME = 'DPE_TEST(BY NUMBER)'\n        ) B\n WHERE  A.ID BETWEEN B.START_ID AND B.END_ID\n GROUP  BY B.CHUNK_ID\n ORDER  BY B.CHUNK_ID;<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-58.png\"><img loading=\"lazy\" decoding=\"async\" width=\"883\" height=\"537\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-58.png\" alt=\"\uc791\uc5c5 \ubd84\ud560 \uade0\ub4f1 \ud655\uc778\" class=\"wp-image-11875\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-58.png 883w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-58-300x182.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-58-768x467.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-58-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-58-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-58-36x22.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-58-48x29.png 48w\" sizes=\"auto, (max-width: 883px) 100vw, 883px\" \/><\/a><figcaption>Work Split Equal Check<\/figcaption><\/figure>\n<\/div>\n\n\n<p>If you check the number of table cases with START_ID and END_ID of each chunk, it is well divided into 10,000 cases.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">-- Chunk\uc758 START_ID, END_ID range\ub85c \ucd94\ucd9c\ud55c Row \uc804\uccb4 Count\nSELECT  SUM(COUNT(A.ID)) ROW_COUNT\n  FROM  Z_DPE_TEST_TAB A,\n        (\n        SELECT  CHUNK_ID, START_ID, END_ID\n          FROM  USER_PARALLEL_EXECUTE_CHUNKS\n         WHERE  TASK_NAME = 'DPE_TEST(BY NUMBER)'\n        ) B\n WHERE  A.ID BETWEEN B.START_ID AND B.END_ID\nGROUP  BY B.CHUNK_ID;<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-59.png\"><img loading=\"lazy\" decoding=\"async\" width=\"731\" height=\"489\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-59.png\" alt=\"chunk row count \ud569\uacc4 \ud655\uc778\" class=\"wp-image-11876\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-59.png 731w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-59-300x201.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-59-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-59-24x16.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-59-36x24.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-59-48x32.png 48w\" sizes=\"auto, (max-width: 731px) 100vw, 731px\" \/><\/a><figcaption>check chunk row count sum<\/figcaption><\/figure>\n<\/div>\n\n\n<p>The sum of row counts of all chunks is 1,000,000, which is consistent with the total number of data.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"3.3._\uc791\uc5c5_\uc2e4\ud589\"><span class=\"ez-toc-section\" id=\"33_%EC%9E%91%EC%97%85_%EC%8B%A4%ED%96%89\"><\/span>3.3. job run<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>RUN_TASK( , , , ) to execute the task. The task execution method is the same as the ROWID method.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">-- 3\ub2e8\uacc4: \uc791\uc5c5 \uc2e4\ud589\nDECLARE\n  L_SQL_STMT VARCHAR2(32767);\nBEGIN\n  L_SQL_STMT := 'UPDATE  Z_DPE_TEST_TAB\n                    SET  VAL = ROUND(DBMS_RANDOM.VALUE(1,10000))\n                        ,AUDSID = SYS_CONTEXT(''USERENV'',''SESSIONID'')\n                  WHERE  ID BETWEEN :START_ID AND :END_ID';\n\n  DBMS_PARALLEL_EXECUTE.RUN_TASK(TASK_NAME      => 'DPE_TEST(BY NUMBER)',\n                                 SQL_STMT       => L_SQL_STMT,\n                                 LANGUAGE_FLAG  => DBMS_SQL.NATIVE,\n                                 PARALLEL_LEVEL => 10);\nEND;\n\/<\/pre>\n\n\n\n<p>The SQL to be executed is almost the same as the case of ROWID partitioning, but the difference is that the condition column in the WHERE clause is not \u201cROWID\u201d but the designated NUMBER column \u201cID\u201d.<\/p>\n\n\n\n<p>Let&#039;s look at the chunk state changes during execution.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">-- Chunk \uc0c1\ud0dc\ubcc4 Count\nSELECT STATUS, COUNT\n  FROM USER_PARALLEL_EXECUTE_CHUNKS\n WHERE TASK_NAME = 'DPE_TEST(BY NUMBER)'\nGROUP BY STATUS;<\/pre>\n\n\n\n<p>When a task is in progress, the state of the chunk is changed from UNASSIGNED -&gt; ASSIGNED -&gt; PROCESSED as follows.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-60.png\"><img loading=\"lazy\" decoding=\"async\" width=\"731\" height=\"428\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-60.png\" alt=\"\uc791\uc5c5 \uc2e4\ud589\uc911 chunk \uc0c1\ud0dc \ud655\uc778\" class=\"wp-image-11877\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-60.png 731w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-60-300x176.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-60-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-60-24x14.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-60-36x21.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-60-48x28.png 48w\" sizes=\"auto, (max-width: 731px) 100vw, 731px\" \/><\/a><figcaption>Check chunk status while running jobs<\/figcaption><\/figure>\n<\/div>\n\n\n<p>When the task is complete, the status of all chunks appears as PROCESSED.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-61.png\"><img loading=\"lazy\" decoding=\"async\" width=\"731\" height=\"428\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-61.png\" alt=\"\uc791\uc5c5 \uc644\ub8cc chunk \uc0c1\ud0dc \ud655\uc778\" class=\"wp-image-11878\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-61.png 731w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-61-300x176.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-61-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-61-24x14.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-61-36x21.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-61-48x28.png 48w\" sizes=\"auto, (max-width: 731px) 100vw, 731px\" \/><\/a><figcaption>Check task completion chunk status<\/figcaption><\/figure>\n<\/div>\n\n\n<p>You can check how many rows were updated in how many sessions by executing the following SQL after the task is completed.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">-- \ub3d9\uc2dc \uc2e4\ud589\ud604\ud669 \ud655\uc778\nSELECT AUDSID, COUNT(*)\n  FROM Z_DPE_TEST_TAB\n GROUP BY AUDSID\n ORDER BY AUDSID;<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-62.png\"><img loading=\"lazy\" decoding=\"async\" width=\"731\" height=\"536\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-62.png\" alt=\"\uc138\uc158\ubcc4 \ucc98\ub9ac\ud55c \ub370\uc774\ud130 \uac74\uc218 \ud655\uc778\" class=\"wp-image-11879\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-62.png 731w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-62-300x220.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-62-16x12.png 16w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-62-24x18.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-62-36x26.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-62-48x35.png 48w\" sizes=\"auto, (max-width: 731px) 100vw, 731px\" \/><\/a><figcaption>Check the number of data processed per session<\/figcaption><\/figure>\n<\/div>\n\n\n<p>From the above, it can be seen that:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>A total of 10 Job Sessions have been executed<\/li><li>Each Job Session received and executed most of 10 Chunks of 10,000 Chunks.<\/li><li>AUDSID: 71767 Job Session was executed after being allocated 9 Chunks (90,000 cases), AUDSID: 71773 Job Session was executed after being allocated 11 Chunks (110,000 cases)<\/li><li>That is, the number of RUN_TASK is higher than the total number of chunks (100 in this case). When the number of chunks is small, a job is assigned several chunks and executed, and the number of executions may vary even if the degree of division of chunks is uniform.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"3.4._\uc791\uc5c5_\uc644\ub8cc_\ud655\uc778_\ubc0f_\uc0ad\uc81c\"><span class=\"ez-toc-section\" id=\"34_%EC%9E%91%EC%97%85_%EC%99%84%EB%A3%8C_%ED%99%95%EC%9D%B8_%EB%B0%8F_%EC%82%AD%EC%A0%9C\"><\/span>3.4. Confirm task completion and delete<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>DROP_TASK( ) to delete the job.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\" data-no-auto-translation=\"\">-- 4\ub2e8\uacc4: \uc791\uc5c5 \uc644\ub8cc \ud655\uc778 \ubc0f \uc791\uc5c5 \uc0ad\uc81c\n-- \uc791\uc5c5 \uc644\ub8cc \ud655\uc778\nSELECT * FROM USER_PARALLEL_EXECUTE_TASKS;\n\n-- \uc791\uc5c5 \uc0ad\uc81c\nBEGIN\n  DBMS_PARALLEL_EXECUTE.DROP_TASK(TASK_NAME => 'DPE_TEST(BY NUMBER)');\nEND;\n\/<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-63.png\"><img loading=\"lazy\" decoding=\"async\" width=\"731\" height=\"402\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-63.png\" alt=\"\uc791\uc5c5 \uc644\ub8cc \ud655\uc778\" class=\"wp-image-11880\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-63.png 731w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-63-300x165.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-63-18x10.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-63-24x13.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-63-36x20.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-63-48x26.png 48w\" sizes=\"auto, (max-width: 731px) 100vw, 731px\" \/><\/a><figcaption>Confirm task completion<\/figcaption><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<p>So far, we have looked at the case of parallel processing of the NUMBER Column division method. The following is an example of partitioning based on user-defined SQL.<\/p>","protected":false},"excerpt":{"rendered":"<p>Let&#039;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&#039;s look at an example of division method by NUMBER column. ROWID method and almost...<\/p>","protected":false},"author":1,"featured_media":11874,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[242,243,244,245,246],"class_list":["post-11873","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-oracle","tag-dbms_parallel_execute","tag-244","tag-dml-parallel-processing","tag-dml-"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>3. NUMBER Column \ubd84\ud560 \ubc29\uc2dd \ubcd1\ub82c \ucc98\ub9ac \uc0ac\ub840 (DBMS_PARALLEL_EXECUTE) - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"Oracle DBMS_PARALLEL_EXECUTE \ub97c \ud65c\uc6a9\ud558\uc5ec NUMBER Column \ubd84\ud560 \ubc29\uc2dd \ubcd1\ub82c \ucc98\ub9ac \uc0ac\ub840\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc791\uc5c5 \uc0dd\uc131, \uc791\uc5c5 \ub2e8\uc704 \ubd84\ud560, \uc791\uc5c5 \uc2e4\ud589, \uc791\uc5c5 \uc644\ub8cc \ud655\uc778 \ubc0f \uc0ad\uc81c\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc774\ub2e4.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"3. NUMBER Column \ubd84\ud560 \ubc29\uc2dd \ubcd1\ub82c \ucc98\ub9ac \uc0ac\ub840 (DBMS_PARALLEL_EXECUTE) - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"Oracle DBMS_PARALLEL_EXECUTE \ub97c \ud65c\uc6a9\ud558\uc5ec NUMBER Column \ubd84\ud560 \ubc29\uc2dd \ubcd1\ub82c \ucc98\ub9ac \uc0ac\ub840\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc791\uc5c5 \uc0dd\uc131, \uc791\uc5c5 \ub2e8\uc704 \ubd84\ud560, \uc791\uc5c5 \uc2e4\ud589, \uc791\uc5c5 \uc644\ub8cc \ud655\uc778 \ubc0f \uc0ad\uc81c\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc774\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-02T09:32:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-04T14:55:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-57.png\" \/>\n\t<meta property=\"og:image:width\" content=\"883\" \/>\n\t<meta property=\"og:image:height\" content=\"537\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Zerom\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Zerom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-3-chunk-by-number-column\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-3-chunk-by-number-column\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"3. NUMBER Column \ubd84\ud560 \ubc29\uc2dd \ubcd1\ub82c \ucc98\ub9ac \uc0ac\ub840 (DBMS_PARALLEL_EXECUTE)\",\"datePublished\":\"2022-10-02T09:32:15+00:00\",\"dateModified\":\"2022-10-04T14:55:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-3-chunk-by-number-column\\\/\"},\"wordCount\":293,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-3-chunk-by-number-column\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-57.png\",\"keywords\":[\"ORACLE\",\"DBMS_PARALLEL_EXECUTE\",\"\ubcd1\ub82c\ucc98\ub9ac\",\"DML Parallel Processing\",\"DML \ubcd1\ub82c\ucc98\ub9ac\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-3-chunk-by-number-column\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-3-chunk-by-number-column\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-3-chunk-by-number-column\\\/\",\"name\":\"3. NUMBER Column \ubd84\ud560 \ubc29\uc2dd \ubcd1\ub82c \ucc98\ub9ac \uc0ac\ub840 (DBMS_PARALLEL_EXECUTE) - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-3-chunk-by-number-column\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-3-chunk-by-number-column\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-57.png\",\"datePublished\":\"2022-10-02T09:32:15+00:00\",\"dateModified\":\"2022-10-04T14:55:33+00:00\",\"description\":\"Oracle DBMS_PARALLEL_EXECUTE \ub97c \ud65c\uc6a9\ud558\uc5ec NUMBER Column \ubd84\ud560 \ubc29\uc2dd \ubcd1\ub82c \ucc98\ub9ac \uc0ac\ub840\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc791\uc5c5 \uc0dd\uc131, \uc791\uc5c5 \ub2e8\uc704 \ubd84\ud560, \uc791\uc5c5 \uc2e4\ud589, \uc791\uc5c5 \uc644\ub8cc \ud655\uc778 \ubc0f \uc0ad\uc81c\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc774\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-3-chunk-by-number-column\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-3-chunk-by-number-column\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-3-chunk-by-number-column\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-57.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-57.png\",\"width\":883,\"height\":537},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-3-chunk-by-number-column\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"3. NUMBER Column \ubd84\ud560 \ubc29\uc2dd \ubcd1\ub82c \ucc98\ub9ac \uc0ac\ub840 (DBMS_PARALLEL_EXECUTE)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\",\"url\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\",\"name\":\"\uc0dd\uc0b0\uc131 Skill\",\"description\":\"Meta Thinking, Meta Working\",\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\",\"name\":\"Zerom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\",\"width\":512,\"height\":512,\"caption\":\"Zerom\"},\"logo\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/09\\\/productivity_clockgear.png\"},\"url\":\"https:\\\/\\\/prodskill.com\\\/en\\\/author\\\/proda\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"3. NUMBER Column Partitioning Parallel Processing Case (DBMS_PARALLEL_EXECUTE) - Productivity Skill","description":"Let&#039;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.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/","og_locale":"en_US","og_type":"article","og_title":"3. NUMBER Column \ubd84\ud560 \ubc29\uc2dd \ubcd1\ub82c \ucc98\ub9ac \uc0ac\ub840 (DBMS_PARALLEL_EXECUTE) - \uc0dd\uc0b0\uc131 Skill","og_description":"Oracle DBMS_PARALLEL_EXECUTE \ub97c \ud65c\uc6a9\ud558\uc5ec NUMBER Column \ubd84\ud560 \ubc29\uc2dd \ubcd1\ub82c \ucc98\ub9ac \uc0ac\ub840\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf8\ub2e4. \uc791\uc5c5 \uc0dd\uc131, \uc791\uc5c5 \ub2e8\uc704 \ubd84\ud560, \uc791\uc5c5 \uc2e4\ud589, \uc791\uc5c5 \uc644\ub8cc \ud655\uc778 \ubc0f \uc0ad\uc81c\uc5d0 \ub300\ud55c \ub0b4\uc6a9\uc774\ub2e4.","og_url":"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-10-02T09:32:15+00:00","article_modified_time":"2022-10-04T14:55:33+00:00","og_image":[{"width":883,"height":537,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-57.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Zerom","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"3. NUMBER Column \ubd84\ud560 \ubc29\uc2dd \ubcd1\ub82c \ucc98\ub9ac \uc0ac\ub840 (DBMS_PARALLEL_EXECUTE)","datePublished":"2022-10-02T09:32:15+00:00","dateModified":"2022-10-04T14:55:33+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/"},"wordCount":293,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-57.png","keywords":["ORACLE","DBMS_PARALLEL_EXECUTE","\ubcd1\ub82c\ucc98\ub9ac","DML Parallel Processing","DML \ubcd1\ub82c\ucc98\ub9ac"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/","url":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/","name":"3. NUMBER Column Partitioning Parallel Processing Case (DBMS_PARALLEL_EXECUTE) - Productivity Skill","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-57.png","datePublished":"2022-10-02T09:32:15+00:00","dateModified":"2022-10-04T14:55:33+00:00","description":"Let&#039;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.","breadcrumb":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-57.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-57.png","width":883,"height":537},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-3-chunk-by-number-column\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"3. NUMBER Column \ubd84\ud560 \ubc29\uc2dd \ubcd1\ub82c \ucc98\ub9ac \uc0ac\ub840 (DBMS_PARALLEL_EXECUTE)"}]},{"@type":"WebSite","@id":"https:\/\/prodskill.com\/ko\/#website","url":"https:\/\/prodskill.com\/ko\/","name":"Productivity Skills","description":"Meta Thinking, Meta Working","publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/prodskill.com\/ko\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd","name":"Zerom","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png","width":512,"height":512,"caption":"Zerom"},"logo":{"@id":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/09\/productivity_clockgear.png"},"url":"https:\/\/prodskill.com\/en\/author\/proda\/"}]}},"_links":{"self":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11873","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/comments?post=11873"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11873\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11874"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11873"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11873"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11873"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}