{"id":11852,"date":"2022-10-02T10:48:37","date_gmt":"2022-10-02T01:48:37","guid":{"rendered":"https:\/\/prodskill.com\/?p=11852"},"modified":"2022-10-04T23:53:04","modified_gmt":"2022-10-04T14:53:04","slug":"oracle-dbms-parallel-execute-2-chunk-by-rowid","status":"publish","type":"post","link":"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-2-chunk-by-rowid\/","title":{"rendered":"2. ROWID partitioning parallel processing case (DBMS_PARALLEL_EXECUTE)"},"content":{"rendered":"<p>Let&#039;s take a look at the case of ROWID partitioning method parallel processing using Oracle DBMS_PARALLEL_EXECUTE.<\/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-1-overview\/\">1. Overview of parallel processing of DML jobs (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-2-chunk-by-rowid\/#2_ROWID_%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\" >2. Parallel processing case of ROWID division method<\/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-2-chunk-by-rowid\/#21_ROWID_%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%9E%91%EC%97%85_%EC%83%9D%EC%84%B1\" >2.1. Create ROWID Partitioned Parallel Processing Jobs<\/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-2-chunk-by-rowid\/#22_%EC%9E%91%EC%97%85_%EB%8B%A8%EC%9C%84_%EB%B6%84%ED%95%A0\" >2.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-2-chunk-by-rowid\/#23_%EC%9E%91%EC%97%85_%EC%8B%A4%ED%96%89\" >2.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-2-chunk-by-rowid\/#24_%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\" >2.4. Confirm task completion and delete<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"2._ROWID_\ubd84\ud560_\ubc29\uc2dd\uc758_\ubcd1\ub82c_\ucc98\ub9ac_\uc0ac\ub840\"><span class=\"ez-toc-section\" id=\"2_ROWID_%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>2. Parallel processing case of ROWID division method<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2.1._\uc791\uc5c5_\uc0dd\uc131\"><span class=\"ez-toc-section\" id=\"21_ROWID_%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%9E%91%EC%97%85_%EC%83%9D%EC%84%B1\"><\/span>2.1. Create ROWID Partitioned Parallel Processing Jobs<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>CREATE_TASK( ) to create the task.<\/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  \u200b\u200bDBMS_PARALLEL_EXECUTE.CREATE_TASK(TASK_NAME => 'DPE_TEST(BY ROWID)');\nEND;\n\/<\/pre>\n\n\n\n<p>The result of the job creation can be checked as follows.<\/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 \uc0dd\uc131 \ud655\uc778\nSELECT * FROM USER_PARALLEL_EXECUTE_TASKS;<\/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-43.png\"><img loading=\"lazy\" decoding=\"async\" width=\"715\" height=\"609\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-43.png\" alt=\"1\ub2e8\uacc4: \uc791\uc5c5 \uc0dd\uc131 \ud655\uc778\" class=\"wp-image-11853\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-43.png 715w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-43-300x256.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-43-14x12.png 14w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-43-24x20.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-43-36x31.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-43-48x41.png 48w\" sizes=\"auto, (max-width: 715px) 100vw, 715px\" \/><\/a><figcaption>Step 1: Confirm task creation<\/figcaption><\/figure>\n<\/div>\n\n\n<p>From the above result, it can be confirmed that the Task has been created and the STATUS is CREATED.<\/p>\n\n\n\n<p>For reference, the STATUS of a task has values of CHUNKED, CHUNKING, CHUNKING_FAILED, CRASHED, CREATED, FINISHED, FINISHED_WITH_ERROR, PROCESSING, and each meaning is as follows.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>CHUNKED: chunk created, not yet assigned to a task<\/li><li>CHUNKING: creating chunks<\/li><li>CHUNKING_FAILED: Failed while creating chunk<\/li><li>CRASHED: A database crash or job process crash occurred during task execution, and the error was not recorded and terminated.<\/li><li>REATED: Task created (no chunk created yet)<\/li><li>FINISHED: all chunks completed without errors<\/li><li>FINISHED_WITH_ERROR: All chunks completed, but some errors occurred<\/li><li>PROCESSING: Tosk has started executing, some of the chunks are in progress or complete<\/li><\/ul>\n\n\n\n<p>* Reference: <a href=\"http:\/\/docs.oracle.com\/cd\/E11882_01\/appdev.112\/e40758\/d_parallel_ex.htm#ARPLS67333\" target=\"_blank\" rel=\"noreferrer noopener\">http:\/\/docs.oracle.com\/cd\/E11882_01\/appdev.112\/e40758\/d_parallel_ex.htm#ARPLS67333<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2.2._\uc791\uc5c5_\ub2e8\uc704_\ubd84\ud560\"><span class=\"ez-toc-section\" id=\"22_%EC%9E%91%EC%97%85_%EB%8B%A8%EC%9C%84_%EB%B6%84%ED%95%A0\"><\/span>2.2. Split work unit<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>CREATE_CHUNKS_BY_ROWID( ,<table> ,<table> , , ) to divide the unit of work.<\/p>\n\n\n\n<p>is a BOOLEAN type, if TRUE means row count, and FALSE means block count.<\/p>\n\n\n\n<p>Execute as follows to create chunks that divide the row count of the Z_DPE_TEST_TAB table into 10,000 rows.<\/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_ROWID(TASK_NAME   => 'DPE_TEST(BY ROWID)',\n                                               TABLE_OWNER => USER,\n                                               TABLE_NAME  => 'Z_DPE_TEST_TAB',\n                                               BY_ROW      => TRUE,\n                                               CHUNK_SIZE  => 10000);\nEND;\n\/<\/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  \u200b\u200bFROM USER_PARALLEL_EXECUTE_CHUNKS\n \u200bWHERE TASK_NAME = 'DPE_TEST(BY ROWID)';<\/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-44.png\"><img loading=\"lazy\" decoding=\"async\" width=\"715\" height=\"609\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-44.png\" alt=\"2\ub2e8\uacc4: \uc791\uc5c5 \ubd84\ud560 \uc0c1\ud0dc \ud655\uc778\" class=\"wp-image-11854\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-44.png 715w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-44-300x256.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-44-14x12.png 14w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-44-24x20.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-44-36x31.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-44-48x41.png 48w\" sizes=\"auto, (max-width: 715px) 100vw, 715px\" \/><\/a><figcaption>Step 2: Check task split status<\/figcaption><\/figure>\n<\/div>\n\n\n<p>It can be confirmed that the STATUS of each chunk at the time of division is UNASSIGNED. For reference, the STATUS of the chunk has values of UNASSIGNED, ASSIGNED, PROCESSED, and PROCESSED_WITH_ERROR, and each meaning is as follows.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>UNASSIGNED: chunk created, not yet assigned to a task<\/li><li>ASSIGNED: chunk is assigned to task and running<\/li><li>PROCESSED: The operation completed without errors<\/li><li>PROCESSED_WITH_ERROR: The operation completed, but an error occurred during execution<\/li><\/ul>\n\n\n\n<p>* Reference:&nbsp;<a href=\"http:\/\/docs.oracle.com\/cd\/E11882_01\/appdev.112\/e40758\/d_parallel_ex.htm#ARPLS67333\" target=\"_blank\" rel=\"noreferrer noopener\">http:\/\/docs.oracle.com\/cd\/E11882_01\/appdev.112\/e40758\/d_parallel_ex.htm#ARPLS67333<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2.3._\uc791\uc5c5_\uc2e4\ud589\"><span class=\"ez-toc-section\" id=\"23_%EC%9E%91%EC%97%85_%EC%8B%A4%ED%96%89\"><\/span>2.3. job run<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>RUN_TASK( , , , ) to execute the task.<\/p>\n\n\n\n<p>Here, LANGUAGE_FLAG means the standard version for Oracle to process SQL_STMT, and DBMS_SQL.NATIVE can be used as default.<\/p>\n\n\n\n<p>For reference, the contents of the Oracle Document are as follows:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>V6 (or 0) specifies version 6 behavior<\/li><li>NATIVE (or 1) specifies normal behavior for the database to which the program is connected<\/li><li>V7 (or 2) specifies Oracle database version 7 behavior<\/li><\/ul>\n\n\n\n<p>PARALLEL_LEVEL means the number of jobs to be executed simultaneously, that is, the degree of parallelism (DOP), and may be equal to or smaller than the number of chunks, which are work units. In the same case, one job processes one chunk, and in a small case, one job processes several chunks.<\/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: \uc791\uc5c5 \uc2e4\ud589\uc804\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-45.png\"><img loading=\"lazy\" decoding=\"async\" width=\"715\" height=\"609\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-45.png\" alt=\"3\ub2e8\uacc4: \ub3d9\uc2dc \uc2e4\ud589\ud604\ud669 \ud655\uc778(\uc791\uc5c5 \uc2e4\ud589\uc804)\" class=\"wp-image-11855\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-45.png 715w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-45-300x256.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-45-14x12.png 14w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-45-24x20.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-45-36x31.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-45-48x41.png 48w\" sizes=\"auto, (max-width: 715px) 100vw, 715px\" \/><\/a><figcaption>Step 3: Check Concurrent Execution Status (Before Task Execution)<\/figcaption><\/figure>\n<\/div>\n\n\n<p>If you check the COUNT for each AUDSID before executing the task, you can see that all data is set to null and has not been executed yet.<\/p>\n\n\n\n<p>Now let&#039;s run 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=\"\">-- 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  ROWID BETWEEN :START_ID AND :END_ID';\n\n  DBMS_PARALLEL_EXECUTE.RUN_TASK(TASK_NAME      => 'DPE_TEST(BY ROWID)',\n                                 SQL_STMT       => L_SQL_STMT,\n                                 LANGUAGE_FLAG  => DBMS_SQL.NATIVE,\n                                 PARALLEL_LEVEL => 10);\nEND;\n\/<\/pre>\n\n\n\n<p>Executed SQL specifies the execution scope with two bind variables :START_ID and :END_ID. If this variable name is used differently, an error will occur, so be sure to use this name.<\/p>\n\n\n\n<p>The SQL executed here is written to check which session updated the current row by updating a random value in the VAL column and updating the current SESSIONID value in the AUDSID column for testing.<\/p>\n\n\n\n<p>For reference, the AUDSID column has the same meaning as V$SESSION.AUDSID. If each chunk unit operation takes a long time, session monitoring can be performed by querying V$SESSION with AUDSID.<\/p>\n\n\n\n<p>If you execute the following SQL during execution, you can check how many rows are being updated in how many sessions.<\/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: \uc791\uc5c5 \uc2e4\ud589\uc911\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-large\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-46.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"529\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-46-1024x529.png\" alt=\"3\ub2e8\uacc4: \ub3d9\uc2dc \uc2e4\ud589\ud604\ud669 \ud655\uc778(\uc791\uc5c5 \uc2e4\ud589\uc911)\" class=\"wp-image-11856\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-46-1024x529.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-46-300x155.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-46-768x397.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-46-18x9.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-46-24x12.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-46-36x19.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-46-48x25.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-46.png 1179w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Step 3: Check Concurrent Execution Status (Task Execution)<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Let&#039;s check the progress of each chunk in which the work is divided, not the session unit.<\/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\uc758 Chunk\ubcc4 \uc9c4\ud589\uc0c1\ud669\/\uc644\ub8cc \ud655\uc778\nSELECT *\n  FROM USER_PARALLEL_EXECUTE_CHUNKS\nWHERE TASK_NAME = 'DPE_TEST(BY ROWID)';<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-47.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"529\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-47-1024x529.png\" alt=\"3\ub2e8\uacc4: \uc791\uc5c5\uc758 Chunk\ubcc4 \uc9c4\ud589\uc0c1\ud669\/\uc644\ub8cc \ud655\uc778\" class=\"wp-image-11857\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-47-1024x529.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-47-300x155.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-47-768x397.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-47-18x9.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-47-24x12.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-47-36x19.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-47-48x25.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-47.png 1179w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Step 3: Check the progress\/completion of each chunk of the task<\/figcaption><\/figure>\n<\/div>\n\n\n<p>From the above result, you can see that STATUS is changed to PROCESSED, and START_TS (start time) and END_TS (end time) are managed.<\/p>\n\n\n\n<p>To check the progress by chunk status, execute the following SQL.<\/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 \uc0c1\ud0dc\ubcc4 \uc9c4\ud589\uc0c1\ud669\nSELECT STATUS, COUNT(*)\n  FROM USER_PARALLEL_EXECUTE_CHUNKS\n WHERE TASK_NAME = 'DPE_TEST(BY ROWID)'\nGROUP BY STATUS;<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-48.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"529\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-48-1024x529.png\" alt=\"3\ub2e8\uacc4: Chunk\uc758 \uc0c1\ud0dc\ubcc4 \uc9c4\ud589\uc0c1\ud669 \ud655\uc778\" class=\"wp-image-11858\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-48-1024x529.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-48-300x155.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-48-768x397.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-48-18x9.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-48-24x12.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-48-36x19.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-48-48x25.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-48.png 1179w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Step 3: Check Chunk Progress by Status<\/figcaption><\/figure>\n<\/div>\n\n\n<p>From the above result, it can be confirmed that 172 chunks have been completed in PROCESSED status. Since the image was captured after the job was completed, only one state was recorded. If the operation takes a long time, you can check the number of chunks for each status.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"2.4._\uc791\uc5c5_\uc644\ub8cc_\ud655\uc778_\ubc0f_\uc0ad\uc81c\"><span class=\"ez-toc-section\" id=\"24_%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>2.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<p>For reference, if you do not delete it, an ORA-29497: duplicate task name (DUPLICATE_TASK_NAME) error will occur when creating a task with the same TASK_NAME later.<\/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 \uc644\ub8cc \ud655\uc778\nSELECT *\n  FROM USER_PARALLEL_EXECUTE_TASKS;<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-49.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"529\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-49-1024x529.png\" alt=\"\uc791\uc5c5 \uc644\ub8cc \ud655\uc778\" class=\"wp-image-11859\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-49-1024x529.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-49-300x155.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-49-768x397.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-49-18x9.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-49-24x12.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-49-36x19.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-49-48x25.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-49.png 1179w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Confirm task completion<\/figcaption><\/figure>\n<\/div>\n\n\n<p>From the above result, it can be confirmed that the task&#039;s STATUS has been completed with FINISHED.<\/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\nBEGIN\n  DBMS_PARALLEL_EXECUTE.DROP_TASK(TASK_NAME => 'DPE_TEST(BY ROWID)');\nEND;\n\/<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-50.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"529\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-50-1024x529.png\" alt=\"4 \ub2e8\uacc4: \uc791\uc5c5 \uc644\ub8cc \ud655\uc778 \ubc0f \uc791\uc5c5 \uc0ad\uc81c\" class=\"wp-image-11860\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-50-1024x529.png 1024w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-50-300x155.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-50-768x397.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-50-18x9.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-50-24x12.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-50-36x19.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-50-48x25.png 48w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-50.png 1179w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><figcaption>Step 4: Check Job Completion and Delete Job<\/figcaption><\/figure>\n<\/div>\n\n\n<p>If you check the USER_PARALLEL_EXECUTE_TASKS view again after executing DROP_TASK, you can see that the task has been deleted.<\/p>\n\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 a simple case of ROWID partitioning method parallel processing.<\/p>\n\n\n\n<p>Next, we look at how uniform the work units divided by ROWID are, whether there are no omissions, and how the correlation between the number of chunks and the number of jobs (parallelism) is.<\/p>","protected":false},"excerpt":{"rendered":"<p>Let&#039;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,...<\/p>","protected":false},"author":1,"featured_media":11853,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[243,244,245,246,242],"class_list":["post-11852","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-dbms_parallel_execute","tag-244","tag-dml-parallel-processing","tag-dml-","tag-oracle"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>2. ROWID \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 ROWID \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-2-chunk-by-rowid\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"2. ROWID \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 ROWID \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-2-chunk-by-rowid\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-02T01:48:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-04T14:53:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-43.png\" \/>\n\t<meta property=\"og:image:width\" content=\"715\" \/>\n\t<meta property=\"og:image:height\" content=\"609\" \/>\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=\"6 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-2-chunk-by-rowid\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-chunk-by-rowid\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"2. ROWID \ubd84\ud560 \ubc29\uc2dd \ubcd1\ub82c \ucc98\ub9ac \uc0ac\ub840 (DBMS_PARALLEL_EXECUTE)\",\"datePublished\":\"2022-10-02T01:48:37+00:00\",\"dateModified\":\"2022-10-04T14:53:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-chunk-by-rowid\\\/\"},\"wordCount\":484,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-chunk-by-rowid\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-43.png\",\"keywords\":[\"DBMS_PARALLEL_EXECUTE\",\"\ubcd1\ub82c\ucc98\ub9ac\",\"DML Parallel Processing\",\"DML \ubcd1\ub82c\ucc98\ub9ac\",\"ORACLE\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-chunk-by-rowid\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-chunk-by-rowid\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-chunk-by-rowid\\\/\",\"name\":\"2. ROWID \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-2-chunk-by-rowid\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-chunk-by-rowid\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-43.png\",\"datePublished\":\"2022-10-02T01:48:37+00:00\",\"dateModified\":\"2022-10-04T14:53:04+00:00\",\"description\":\"Oracle DBMS_PARALLEL_EXECUTE \ub97c \ud65c\uc6a9\ud558\uc5ec ROWID \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-2-chunk-by-rowid\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-chunk-by-rowid\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-chunk-by-rowid\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-43.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-43.png\",\"width\":715,\"height\":609},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-chunk-by-rowid\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"2. ROWID \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":"2. ROWID Partitioning Parallel Processing Case (DBMS_PARALLEL_EXECUTE) - Productivity Skill","description":"This article explores the use of Oracle DBMS_PARALLEL_EXECUTE to implement ROWID-partitioned parallel processing. It covers creating tasks, dividing them into units, executing them, checking for completion, and deleting them.","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-2-chunk-by-rowid\/","og_locale":"en_US","og_type":"article","og_title":"2. ROWID \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 ROWID \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-2-chunk-by-rowid\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-10-02T01:48:37+00:00","article_modified_time":"2022-10-04T14:53:04+00:00","og_image":[{"width":715,"height":609,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-43.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Zerom","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-chunk-by-rowid\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-chunk-by-rowid\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"2. ROWID \ubd84\ud560 \ubc29\uc2dd \ubcd1\ub82c \ucc98\ub9ac \uc0ac\ub840 (DBMS_PARALLEL_EXECUTE)","datePublished":"2022-10-02T01:48:37+00:00","dateModified":"2022-10-04T14:53:04+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-chunk-by-rowid\/"},"wordCount":484,"commentCount":2,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-chunk-by-rowid\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-43.png","keywords":["DBMS_PARALLEL_EXECUTE","\ubcd1\ub82c\ucc98\ub9ac","DML Parallel Processing","DML \ubcd1\ub82c\ucc98\ub9ac","ORACLE"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-chunk-by-rowid\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-chunk-by-rowid\/","url":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-chunk-by-rowid\/","name":"2. ROWID 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-2-chunk-by-rowid\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-chunk-by-rowid\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-43.png","datePublished":"2022-10-02T01:48:37+00:00","dateModified":"2022-10-04T14:53:04+00:00","description":"This article explores the use of Oracle DBMS_PARALLEL_EXECUTE to implement ROWID-partitioned parallel processing. It covers creating tasks, dividing them into units, executing them, checking for completion, and deleting them.","breadcrumb":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-chunk-by-rowid\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-chunk-by-rowid\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-chunk-by-rowid\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-43.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-43.png","width":715,"height":609},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-chunk-by-rowid\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"2. ROWID \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\/11852","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=11852"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11852\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11853"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11852"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}