{"id":11864,"date":"2022-10-02T17:05:36","date_gmt":"2022-10-02T08:05:36","guid":{"rendered":"https:\/\/prodskill.com\/?p=11864"},"modified":"2022-10-04T23:53:57","modified_gmt":"2022-10-04T14:53:57","slug":"oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify","status":"publish","type":"post","link":"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\/","title":{"rendered":"2.5. Detailed check of unit of work partitioning (DBMS_PARALLEL_EXECUTE)"},"content":{"rendered":"<p>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.<\/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-chunk-by-rowid\/\">2. Parallel processing case of ROWID division method<\/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-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\/#25_%EC%9E%91%EC%97%85_%EB%8B%A8%EC%9C%84_%EB%B6%84%ED%95%A0_%EC%83%81%EC%84%B8_%ED%99%95%EC%9D%B8\" >2.5. Work unit division details check<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\/#251_ROWID%EB%A1%9C_%EB%B6%84%ED%95%A0%ED%95%9C_%EC%9E%91%EC%97%85_%EB%8B%A8%EC%9C%84%EB%93%A4%EC%9D%98_%EA%B7%A0%EC%9D%BC%ED%95%9C_%EC%A0%95%EB%8F%84\" >2.5.1. Uniformity of work units partitioned by ROWID<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\/#252_ROWID%EB%A1%9C_%EB%B6%84%ED%95%A0%ED%95%9C_%EC%9E%91%EC%97%85_%EB%8B%A8%EC%9C%84%EB%93%A4%EC%9D%B4_%EB%88%84%EB%9D%BD_%EC%97%86%EC%9D%8C_%ED%99%95%EC%9D%B8\" >2.5.2. Check that there are no missing units of work divided by ROWID<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\/#253_%EC%9E%91%EC%97%85_%EB%8B%A8%EC%9C%84Chunk%EC%9D%98_%EC%88%98%EC%99%80_%EC%9E%91%EC%97%85%EC%9D%98_PARALLEL_LEVEL_%EC%8B%A4%ED%96%89%ED%95%98%EB%8A%94_Job%EC%9D%98_%EA%B0%9C%EC%88%98%EA%B0%84%EC%9D%98_%EC%83%81%EA%B4%80%EA%B4%80%EA%B3%84\" >2.5.3. Correlation between the number of work units (chunks) and the PARALLEL_LEVEL (the number of jobs to be executed)<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h3 class=\"wp-block-heading\" id=\"2.5._\uc791\uc5c5_\ub2e8\uc704_\ubd84\ud560_\uc0c1\uc138_\ud655\uc778\"><span class=\"ez-toc-section\" id=\"25_%EC%9E%91%EC%97%85_%EB%8B%A8%EC%9C%84_%EB%B6%84%ED%95%A0_%EC%83%81%EC%84%B8_%ED%99%95%EC%9D%B8\"><\/span>2.5. Work unit division details check<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Let&#039;s take a look at the following to see if the unit of work is well-divided.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Uniformity of work units partitioned by ROWID<\/li><li>Check that there are no missing units of work divided by ROWID<\/li><li>Correlation between the number of work units (chunks) and the PARALLEL_LEVEL (the number of jobs to be executed)<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"2.5.1._ROWID\ub85c_\ubd84\ud560\ud55c_\uc791\uc5c5_\ub2e8\uc704\ub4e4\uc758_\uade0\uc77c\ud55c_\uc815\ub3c4\"><span class=\"ez-toc-section\" id=\"251_ROWID%EB%A1%9C_%EB%B6%84%ED%95%A0%ED%95%9C_%EC%9E%91%EC%97%85_%EB%8B%A8%EC%9C%84%EB%93%A4%EC%9D%98_%EA%B7%A0%EC%9D%BC%ED%95%9C_%EC%A0%95%EB%8F%84\"><\/span>2.5.1. Uniformity of work units partitioned by ROWID<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>The following division means to divide the Z_DPE_TEST_TAB table into 10,000 work units based on ROW Count.<\/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 see if it really splits by 10,000.<\/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\ub2e8\uc704 \uac1c\uc218 \ud655\uc778 --> 115\nSELECT COUNT(*)\n  FROM USER_PARALLEL_EXECUTE_CHUNKS\nWHERE TASK_NAME = 'DPE_TEST(BY ROWID)';<\/pre>\n\n\n\n<p>Since the total number of rows is 1,000,000, it seems that it should be divided into 100 chunks if it is divided into 10,000 rows, but in reality it is divided into 115 chunks.<\/p>\n\n\n\n<p>If you calculate the row count for each chunk,<\/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=\"\">SELECT  B.CHUNK_ID, COUNT(A.ID), MIN(A.ID) MIN_ID, MAX(A.ID) MAX_ID\n  FROM  Z_DPE_TEST_TAB A,\n        (\n        SELECT  CHUNK_ID, START_ROWID, END_ROWID\n          FROM  USER_PARALLEL_EXECUTE_CHUNKS\n         WHERE  TASK_NAME = 'DPE_TEST(BY ROWID)'\n        ) B\n WHERE  A.ROWID BETWEEN B.START_ROWID AND B.END_ROWID\n GROUP  BY B.CHUNK_ID\n ORDER  BY B.CHUNK_ID;<\/pre>\n\n\n\n<p>You can see that it is divided into various Counts, such as 1334, 2064, and 1886, not 10,000.<\/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-51.png\"><img loading=\"lazy\" decoding=\"async\" width=\"883\" height=\"644\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-51.png\" alt=\"chunk\ubcc4 row count\" class=\"wp-image-11865\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-51.png 883w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-51-300x219.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-51-768x560.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-51-16x12.png 16w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-51-24x18.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-51-36x26.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-51-48x35.png 48w\" sizes=\"auto, (max-width: 883px) 100vw, 883px\" \/><\/a><figcaption>row count per chunk<\/figcaption><\/figure>\n<\/div>\n\n\n<p>The number of rows contained in the chunk is 14 in the 1,000-2,000 section, 2 in the 2,000 row section, 33 in the 6,000 row section, 64 in the 11,000 row section, and 2 in the 12,000 row section. (It may not give the same result every time.)<\/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-52.png\"><img loading=\"lazy\" decoding=\"async\" width=\"573\" height=\"347\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-52.png\" alt=\"Row\uc218 \uad6c\uac04\ubcc4 chunk\uc218\" class=\"wp-image-11866\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-52.png 573w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-52-300x182.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-52-18x12.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-52-24x15.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-52-36x22.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-52-48x29.png 48w\" sizes=\"auto, (max-width: 573px) 100vw, 573px\" \/><\/a><figcaption>Number of Rows Number of chunks per section<\/figcaption><\/figure>\n<\/div>\n\n\n<p>As such, it is not divided into a completely equal number of rows. This seems to be because the ROWID partitioning method is based on DBA_EXTENTS, and the number of blocks included in each EXTENT and the ROW Count of each block can be different. For reference, if there are unused BLOCKs in the table by DELETE, etc., a ROWID section where no data actually exists may be created as a chunk. This is also expected to occur when data is deleted after being allocated to DBA_EXTENT, or when there are EXTENTs that have been allocated but do not contain actual data.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"2.5.2._ROWID\ub85c_\ubd84\ud560\ud55c_\uc791\uc5c5_\ub2e8\uc704\ub4e4\uc774_\ub204\ub77d_\uc5c6\uc74c_\ud655\uc778\"><span class=\"ez-toc-section\" id=\"252_ROWID%EB%A1%9C_%EB%B6%84%ED%95%A0%ED%95%9C_%EC%9E%91%EC%97%85_%EB%8B%A8%EC%9C%84%EB%93%A4%EC%9D%B4_%EB%88%84%EB%9D%BD_%EC%97%86%EC%9D%8C_%ED%99%95%EC%9D%B8\"><\/span>2.5.2. Check that there are no missing units of work divided by ROWID<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>Could there be missing data when the START_ROWID and END_ROWID sections of each chunk are expanded?<\/p>\n\n\n\n<p>First, let&#039;s check the row count.<\/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 RowID range\ub85c \ucd94\ucd9c\ud55c Row Count\nSELECT  COUNT(A.ID) ROW_COUNT\n  FROM  Z_DPE_TEST_TAB A,\n        (\n        SELECT  CHUNK_ID, START_ROWID, END_ROWID\n          FROM  USER_PARALLEL_EXECUTE_CHUNKS\n         WHERE  TASK_NAME = 'DPE_TEST(BY ROWID)'\n        ) B\n WHERE  A.ROWID BETWEEN B.START_ROWID AND B.END_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-53.png\"><img loading=\"lazy\" decoding=\"async\" width=\"883\" height=\"644\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-53.png\" alt=\"row count \uc77c\uce58 \ud655\uc778\" class=\"wp-image-11867\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-53.png 883w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-53-300x219.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-53-768x560.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-53-16x12.png 16w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-53-24x18.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-53-36x26.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-53-48x35.png 48w\" sizes=\"auto, (max-width: 883px) 100vw, 883px\" \/><\/a><figcaption>Check row count matches<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Matching the total row count of 1,000,000, once confirmed that the count was not missing, and then, based on the data extracted in the range of START_ROWID to END_ROWID of Chunk, when the original data was LEFT OUTER JOINed, missing (missing) ) to see if the data exists.<\/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 RowID\ub85c \ucd94\ucd9c\ud55c \ub370\uc774\ud130\uc758 \ub204\ub77d\uc5c6\uc74c \ud655\uc778\nSELECT  *\n  FROM  Z_DPE_TEST_TAB A LEFT OUTER JOIN\n        (\n        SELECT  A.ID  -- Chunk\uc758 RowID range\ub85c \ucd94\ucd9c\ud55c \ub370\uc774\ud130\n          FROM  Z_DPE_TEST_TAB A,\n                (\n                SELECT  CHUNK_ID, START_ROWID, END_ROWID\n                  FROM  USER_PARALLEL_EXECUTE_CHUNKS\n                 WHERE  TASK_NAME = 'DPE_TEST(BY ROWID)'\n                ) B\n         WHERE  A.ROWID BETWEEN B.START_ROWID AND B.END_ROWID\n        ) B ON (A.ID = B.ID)\n WHERE  B.ID IS NULL;<\/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-54.png\"><img loading=\"lazy\" decoding=\"async\" width=\"883\" height=\"644\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-54.png\" alt=\"\ub370\uc774\ud130 \ub204\ub77d \uc5c6\uc74c \ud655\uc778\" class=\"wp-image-11868\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-54.png 883w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-54-300x219.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-54-768x560.png 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-54-16x12.png 16w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-54-24x18.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-54-36x26.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-54-48x35.png 48w\" sizes=\"auto, (max-width: 883px) 100vw, 883px\" \/><\/a><figcaption>Make sure no data is missing<\/figcaption><\/figure>\n<\/div>\n\n\n<p>From the above results, it can be seen that there is no missing data.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"2.5.3._\uc791\uc5c5_\ub2e8\uc704(Chunk)\uc758_\uc218\uc640_\uc791\uc5c5\uc758_PARALLEL_LEVEL_(\uc2e4\ud589\ud558\ub294_Job\uc758_\uac1c\uc218)\uac04\uc758_\uc0c1\uad00\uad00\uacc4\"><span class=\"ez-toc-section\" id=\"253_%EC%9E%91%EC%97%85_%EB%8B%A8%EC%9C%84Chunk%EC%9D%98_%EC%88%98%EC%99%80_%EC%9E%91%EC%97%85%EC%9D%98_PARALLEL_LEVEL_%EC%8B%A4%ED%96%89%ED%95%98%EB%8A%94_Job%EC%9D%98_%EA%B0%9C%EC%88%98%EA%B0%84%EC%9D%98_%EC%83%81%EA%B4%80%EA%B4%80%EA%B3%84\"><\/span>2.5.3. Correlation between the number of work units (chunks) and the PARALLEL_LEVEL (the number of jobs to be executed)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>&lt;2.3. In Task Execution&gt;, there was the following content.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><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><\/blockquote>\n\n\n\n<p>* Reference: <a 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. Parallel processing case of ROWID division method_2.3. job run<\/a><\/p>\n\n\n\n<p>Consider the following cases regarding the number of chunks and the number of jobs.<\/p>\n\n\n\n<p><strong>\u25bc When the number of chunks and the number of jobs are the same (Chunk = Job)<\/strong><\/p>\n\n\n\n<p>When one job completes the execution of the assigned chunk, it ends because there are no more jobs to run.<\/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-55.png\"><img loading=\"lazy\" decoding=\"async\" width=\"637\" height=\"252\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-55.png\" alt=\"Chunk\uc218\uc640 Job\uc218\uac00 \ub3d9\uc77c\ud55c \uacbd\uc6b0\" class=\"wp-image-11869\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-55.png 637w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-55-300x119.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-55-18x7.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-55-24x9.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-55-36x14.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-55-48x19.png 48w\" sizes=\"auto, (max-width: 637px) 100vw, 637px\" \/><\/a><figcaption>When the number of chunks and the number of jobs are the same<\/figcaption><\/figure>\n<\/div>\n\n\n<p><strong>\u25bc When the number of jobs is less than the number of chunks (Chunk &gt; Job)<\/strong><\/p>\n\n\n\n<p>When the job of the chunk to which the job is assigned is completed, the chunk that has not yet been executed is allocated and executed continuously. Below is an example when there are 3 jobs.<\/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-56.png\"><img loading=\"lazy\" decoding=\"async\" width=\"648\" height=\"252\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-56.png\" alt=\"Chunk\uc218\ubcf4\ub2e4 Job\uc218\uac00 \uc801\uc740 \uacbd\uc6b0 (Chunk &gt; Job)\" class=\"wp-image-11870\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-56.png 648w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-56-300x117.png 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-56-18x7.png 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-56-24x9.png 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-56-36x14.png 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-56-48x19.png 48w\" sizes=\"auto, (max-width: 648px) 100vw, 648px\" \/><\/a><figcaption>When the number of jobs is less than the number of chunks (Chunk &gt; Job)<\/figcaption><\/figure>\n<\/div>\n\n\n<p>In addition, if the number of jobs is greater than the number of chunks (Chunk &lt; Job), it is also possible, but it is better not to apply it because chunks are not allocated and unnecessary resources can be used by maintaining the running state.<\/p>\n\n\n\n<p>* Reference: <a href=\"https:\/\/docs.oracle.com\/cd\/E11882_01\/appdev.112\/e40758\/d_parallel_ex.htm#ARPLS67339\" target=\"_blank\" rel=\"noreferrer noopener\">DBMS_PARALLEL_EXECUTE Chunk by ROWID Example<\/a><\/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 the ROWID partitioning method. Next, look at the NUMBER column partitioning method.<\/p>","protected":false},"excerpt":{"rendered":"<p>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...<\/p>","protected":false},"author":1,"featured_media":11866,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[246,242,243,244,245],"class_list":["post-11864","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-dml-","tag-oracle","tag-dbms_parallel_execute","tag-244","tag-dml-parallel-processing"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>2.5. \uc791\uc5c5 \ub2e8\uc704 \ubd84\ud560 \uc0c1\uc138 \ud655\uc778 (DBMS_PARALLEL_EXECUTE) - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"\uc791\uc5c5 \ub2e8\uc704 \ubd84\ud560 \uc0c1\uc138 \ud655\uc778 \uad00\ub828 \ub0b4\uc6a9\uc774\ub2e4. ROWID\ub85c \uc791\uc5c5 \ub2e8\uc704(chunk)\ub97c \ubd84\ud560\ud55c \uacb0\uacfc\uac00 \uc5b4\ub290 \uc815\ub3c4\ub85c \uade0\uc77c\ud558\uac8c \ubd84\ud560\ub418\ub294\uc9c0, \uc791\uc5c5 \ub2e8\uc704\uc758 \ud569\uc774 \uc804\uccb4\uc640 \ub3d9\uc77c\ud558\uac8c \ub204\ub77d\uc774 \uc5c6\ub294\uc9c0, \uc791\uc5c5\ub2e8\uc704 \uc218\uc640 job \uac1c\uc218\uc758 \uc0c1\uad00\uad00\uacc4\ub97c \uc0b4\ud3b4\ubcf8\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-5-chunk-by-rowid-verify\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"2.5. \uc791\uc5c5 \ub2e8\uc704 \ubd84\ud560 \uc0c1\uc138 \ud655\uc778 (DBMS_PARALLEL_EXECUTE) - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"\uc791\uc5c5 \ub2e8\uc704 \ubd84\ud560 \uc0c1\uc138 \ud655\uc778 \uad00\ub828 \ub0b4\uc6a9\uc774\ub2e4. ROWID\ub85c \uc791\uc5c5 \ub2e8\uc704(chunk)\ub97c \ubd84\ud560\ud55c \uacb0\uacfc\uac00 \uc5b4\ub290 \uc815\ub3c4\ub85c \uade0\uc77c\ud558\uac8c \ubd84\ud560\ub418\ub294\uc9c0, \uc791\uc5c5 \ub2e8\uc704\uc758 \ud569\uc774 \uc804\uccb4\uc640 \ub3d9\uc77c\ud558\uac8c \ub204\ub77d\uc774 \uc5c6\ub294\uc9c0, \uc791\uc5c5\ub2e8\uc704 \uc218\uc640 job \uac1c\uc218\uc758 \uc0c1\uad00\uad00\uacc4\ub97c \uc0b4\ud3b4\ubcf8\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-02T08:05:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-04T14:53:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-52.png\" \/>\n\t<meta property=\"og:image:width\" content=\"573\" \/>\n\t<meta property=\"og:image:height\" content=\"347\" \/>\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-2-5-chunk-by-rowid-verify\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"2.5. \uc791\uc5c5 \ub2e8\uc704 \ubd84\ud560 \uc0c1\uc138 \ud655\uc778 (DBMS_PARALLEL_EXECUTE)\",\"datePublished\":\"2022-10-02T08:05:36+00:00\",\"dateModified\":\"2022-10-04T14:53:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\\\/\"},\"wordCount\":249,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-52.png\",\"keywords\":[\"DML \ubcd1\ub82c\ucc98\ub9ac\",\"ORACLE\",\"DBMS_PARALLEL_EXECUTE\",\"\ubcd1\ub82c\ucc98\ub9ac\",\"DML Parallel Processing\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\\\/\",\"name\":\"2.5. \uc791\uc5c5 \ub2e8\uc704 \ubd84\ud560 \uc0c1\uc138 \ud655\uc778 (DBMS_PARALLEL_EXECUTE) - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-52.png\",\"datePublished\":\"2022-10-02T08:05:36+00:00\",\"dateModified\":\"2022-10-04T14:53:57+00:00\",\"description\":\"\uc791\uc5c5 \ub2e8\uc704 \ubd84\ud560 \uc0c1\uc138 \ud655\uc778 \uad00\ub828 \ub0b4\uc6a9\uc774\ub2e4. ROWID\ub85c \uc791\uc5c5 \ub2e8\uc704(chunk)\ub97c \ubd84\ud560\ud55c \uacb0\uacfc\uac00 \uc5b4\ub290 \uc815\ub3c4\ub85c \uade0\uc77c\ud558\uac8c \ubd84\ud560\ub418\ub294\uc9c0, \uc791\uc5c5 \ub2e8\uc704\uc758 \ud569\uc774 \uc804\uccb4\uc640 \ub3d9\uc77c\ud558\uac8c \ub204\ub77d\uc774 \uc5c6\ub294\uc9c0, \uc791\uc5c5\ub2e8\uc704 \uc218\uc640 job \uac1c\uc218\uc758 \uc0c1\uad00\uad00\uacc4\ub97c \uc0b4\ud3b4\ubcf8\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-52.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-52.png\",\"width\":573,\"height\":347},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"2.5. \uc791\uc5c5 \ub2e8\uc704 \ubd84\ud560 \uc0c1\uc138 \ud655\uc778 (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.5. Detailed check of work unit division (DBMS_PARALLEL_EXECUTE) - Productivity Skill","description":"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.","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-5-chunk-by-rowid-verify\/","og_locale":"en_US","og_type":"article","og_title":"2.5. \uc791\uc5c5 \ub2e8\uc704 \ubd84\ud560 \uc0c1\uc138 \ud655\uc778 (DBMS_PARALLEL_EXECUTE) - \uc0dd\uc0b0\uc131 Skill","og_description":"\uc791\uc5c5 \ub2e8\uc704 \ubd84\ud560 \uc0c1\uc138 \ud655\uc778 \uad00\ub828 \ub0b4\uc6a9\uc774\ub2e4. ROWID\ub85c \uc791\uc5c5 \ub2e8\uc704(chunk)\ub97c \ubd84\ud560\ud55c \uacb0\uacfc\uac00 \uc5b4\ub290 \uc815\ub3c4\ub85c \uade0\uc77c\ud558\uac8c \ubd84\ud560\ub418\ub294\uc9c0, \uc791\uc5c5 \ub2e8\uc704\uc758 \ud569\uc774 \uc804\uccb4\uc640 \ub3d9\uc77c\ud558\uac8c \ub204\ub77d\uc774 \uc5c6\ub294\uc9c0, \uc791\uc5c5\ub2e8\uc704 \uc218\uc640 job \uac1c\uc218\uc758 \uc0c1\uad00\uad00\uacc4\ub97c \uc0b4\ud3b4\ubcf8\ub2e4.","og_url":"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-10-02T08:05:36+00:00","article_modified_time":"2022-10-04T14:53:57+00:00","og_image":[{"width":573,"height":347,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-52.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-2-5-chunk-by-rowid-verify\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"2.5. \uc791\uc5c5 \ub2e8\uc704 \ubd84\ud560 \uc0c1\uc138 \ud655\uc778 (DBMS_PARALLEL_EXECUTE)","datePublished":"2022-10-02T08:05:36+00:00","dateModified":"2022-10-04T14:53:57+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\/"},"wordCount":249,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-52.png","keywords":["DML \ubcd1\ub82c\ucc98\ub9ac","ORACLE","DBMS_PARALLEL_EXECUTE","\ubcd1\ub82c\ucc98\ub9ac","DML Parallel Processing"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\/","url":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\/","name":"2.5. Detailed check of work unit division (DBMS_PARALLEL_EXECUTE) - Productivity Skill","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-52.png","datePublished":"2022-10-02T08:05:36+00:00","dateModified":"2022-10-04T14:53:57+00:00","description":"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.","breadcrumb":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-52.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-52.png","width":573,"height":347},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-2-5-chunk-by-rowid-verify\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"2.5. \uc791\uc5c5 \ub2e8\uc704 \ubd84\ud560 \uc0c1\uc138 \ud655\uc778 (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\/11864","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=11864"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11864\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11866"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}