{"id":11896,"date":"2022-10-02T21:19:54","date_gmt":"2022-10-02T12:19:54","guid":{"rendered":"https:\/\/prodskill.com\/?p=11896"},"modified":"2022-10-04T23:57:42","modified_gmt":"2022-10-04T14:57:42","slug":"oracle-dbms-parallel-execute-5-toc","status":"publish","type":"post","link":"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-5-toc\/","title":{"rendered":"DBMS_PARALLEL_EXECUTE Description Table of Contents"},"content":{"rendered":"<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1-edited.jpeg\"><img loading=\"lazy\" decoding=\"async\" width=\"960\" height=\"540\" src=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1-edited.jpeg\" alt=\"\" class=\"wp-image-11898\" srcset=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1-edited.jpeg 960w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1-edited-300x169.jpeg 300w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1-edited-768x432.jpeg 768w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1-edited-18x10.jpeg 18w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1-edited-24x14.jpeg 24w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1-edited-36x20.jpeg 36w, https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1-edited-48x27.jpeg 48w\" sizes=\"auto, (max-width: 960px) 100vw, 960px\" \/><\/a><figcaption>source: <a href=\"https:\/\/pixabay.com\/ko\/photos\/%ea%b1%b0%ec%a7%93%eb%a7%90%ed%95%98%eb%8b%a4-%ec%97%ad-%ea%b1%b4%ec%b6%95%ed%95%99-%ea%b1%b4%eb%ac%bc-213494\/\" target=\"_blank\" rel=\"noreferrer noopener\">Lie Station Architecture - Free photo on Pixabay<\/a><\/figcaption><\/figure>\n<\/div>\n\n\n<p>The table of contents of the DBMS_PARALLEL_EXECUTE description that can be used from Oracle 11g R2 is compiled and uploaded. Clicking on each table of contents will take you to that article.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-1-overview\/#1_DML_%EC%9E%91%EC%97%85%EC%9D%98_%EB%B3%91%EB%A0%AC_%EC%B2%98%EB%A6%AC_%EA%B0%9C%EC%9A%94\">1. Overview of Parallel Processing of DML Jobs<\/a><ul><li><a href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-1-overview\/#11_DML_%EB%B3%91%EB%A0%AC%EC%B2%98%EB%A6%AC_%EB%B0%A9%EB%B2%95\">1.1. DML Parallel Processing Method<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-1-overview\/#12_DBMS_PARALLEL_EXECUTE_%EA%B0%9C%EB%85%90\">1.2. DBMS_PARALLEL_EXECUTE concept<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-1-overview\/#13_DBMS_PARALLEL_EXECUTE_%ED%85%8C%EC%8A%A4%ED%8A%B8%EB%A5%BC_%EC%9C%84%ED%95%9C_%ED%85%8C%EC%9D%B4%EB%B8%94%EA%B3%BC_%EB%8D%B0%EC%9D%B4%ED%84%B0_%EC%83%9D%EC%84%B1\">1.3. Create tables and data for DBMS_PARALLEL_EXECUTE test<\/a><\/li><\/ul><\/li><li><a 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><li><a 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><a 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><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.3. job run<\/a><\/li><li><a 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><li><a 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><li><a 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><a 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><a 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><\/li><li><a 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><li><a 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><a 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><a 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><a 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><li><a href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-4-chunk-by-sql\/#4_%EC%82%AC%EC%9A%A9%EC%9E%90_%EC%A0%95%EC%9D%98_SQL_%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\">4. User Defined SQL Partitioning Parallel Processing Case<\/a><ul><li><a href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-4-chunk-by-sql\/#41_%EC%82%AC%EC%9A%A9%EC%9E%90_%EC%A0%95%EC%9D%98_SQL_%EB%B6%84%ED%95%A0_%EB%B0%A9%EC%8B%9D_%EA%B0%9C%EC%9A%94\">4.1. Overview of custom SQL partitioning methods<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-4-chunk-by-sql\/#42_%EC%82%AC%EC%9A%A9%EC%9E%90_%EC%A0%95%EC%9D%98_SQL_%EC%9E%91%EC%84%B1\">4.2. Writing custom SQL<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-4-chunk-by-sql\/#43_%ED%85%8C%EC%8A%A4%ED%8A%B8_%ED%99%98%EA%B2%BD_%EB%B0%8F_%ED%85%8C%EC%8A%A4%ED%8A%B8_%ED%85%8C%EC%9D%B4%EB%B8%94_%EC%83%9D%EC%84%B1\">4.3. Create test environment and test table<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-4-chunk-by-sql\/#44_%EC%9E%91%EC%97%85_%EC%83%9D%EC%84%B1\">4.4. create job<\/a><ul><li><a href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-4-chunk-by-sql\/#441_%EC%9E%91%EC%97%85%EC%83%9D%EC%84%B1\">4.4.1. create job<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-4-chunk-by-sql\/#442_%EC%9E%91%EC%97%85_%EB%8B%A8%EC%9C%84_%EB%B6%84%ED%95%A0\">4.4.2. Split work unit<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-4-chunk-by-sql\/#45_%EC%9E%91%EC%97%85_%EC%8B%A4%ED%96%89\">4.5. job run<\/a><\/li><li><a href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-4-chunk-by-sql\/#46_%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\">4.6. Confirm task completion and delete<\/a><\/li><\/ul><\/li><li><a href=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-4-chunk-by-sql\/#5_%EA%B3%A0%EB%A0%A4%EC%82%AC%ED%95%AD\">5. Considerations<\/a><\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<p>This is information that can be helpful to those who have worked as DBAs or data migrations, and those who plan to do so in the future. In particular, it is a method worth considering when parallel hints cannot be applied when processing large amounts of data. In addition, I think that the user-defined SQL partitioning method can be applied in various ways.<\/p>","protected":false},"excerpt":{"rendered":"<p>The table of contents of the DBMS_PARALLEL_EXECUTE description that can be used from Oracle 11g R2 is compiled and uploaded. Clicking on each table of contents will take you to that article. 1. Overview of Parallel Processing of DML Tasks 1.1. DML Parallel Processing Method 1.2. DBMS_PARALLEL_EXECUTE concept 1.3. Create table and data for DBMS_PARALLEL_EXECUTE test 2. ROWID Partitioning Method Parallel Processing Example 2.1. ROWID Partitioning Parallel Processing...<\/p>","protected":false},"author":1,"featured_media":11897,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[242,243,244,245,246],"class_list":["post-11896","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>DBMS_PARALLEL_EXECUTE \uc124\uba85\uae00 \ubaa9\ucc28 - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"Oracle 11g R2\ubd80\ud130 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 DBMS_PARALLEL_EXECUTE \uc124\uba85\uae00 \ubaa9\ucc28 \uc774\ub2e4. \uac01 \ubaa9\ucc28\ub97c \ud074\ub9ad\ud558\uba74 \ud574\ub2f9 \uae00\ub85c \uc774\ub3d9\ud55c\ub2e4. ROWID, NUMBER Column, \uc0ac\uc6a9\uc790 \uc815\uc758 SQL \uac01 \ubd84\ud560 \ubc29\uc2dd\uc5d0 \ub300\ud55c \uc0ac\ub840\ub97c \ud655\uc778\ud560 \uc218 \uc788\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-5-toc\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DBMS_PARALLEL_EXECUTE \uc124\uba85\uae00 \ubaa9\ucc28 - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"Oracle 11g R2\ubd80\ud130 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 DBMS_PARALLEL_EXECUTE \uc124\uba85\uae00 \ubaa9\ucc28 \uc774\ub2e4. \uac01 \ubaa9\ucc28\ub97c \ud074\ub9ad\ud558\uba74 \ud574\ub2f9 \uae00\ub85c \uc774\ub3d9\ud55c\ub2e4. ROWID, NUMBER Column, \uc0ac\uc6a9\uc790 \uc815\uc758 SQL \uac01 \ubd84\ud560 \ubc29\uc2dd\uc5d0 \ub300\ud55c \uc0ac\ub840\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-5-toc\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-02T12:19:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-04T14:57:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"960\" \/>\n\t<meta property=\"og:image:height\" content=\"640\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\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=\"2 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-5-toc\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-5-toc\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"DBMS_PARALLEL_EXECUTE \uc124\uba85\uae00 \ubaa9\ucc28\",\"datePublished\":\"2022-10-02T12:19:54+00:00\",\"dateModified\":\"2022-10-04T14:57:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-5-toc\\\/\"},\"wordCount\":114,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-5-toc\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-1.jpeg\",\"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-5-toc\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-5-toc\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-5-toc\\\/\",\"name\":\"DBMS_PARALLEL_EXECUTE \uc124\uba85\uae00 \ubaa9\ucc28 - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-5-toc\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-5-toc\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-1.jpeg\",\"datePublished\":\"2022-10-02T12:19:54+00:00\",\"dateModified\":\"2022-10-04T14:57:42+00:00\",\"description\":\"Oracle 11g R2\ubd80\ud130 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 DBMS_PARALLEL_EXECUTE \uc124\uba85\uae00 \ubaa9\ucc28 \uc774\ub2e4. \uac01 \ubaa9\ucc28\ub97c \ud074\ub9ad\ud558\uba74 \ud574\ub2f9 \uae00\ub85c \uc774\ub3d9\ud55c\ub2e4. ROWID, NUMBER Column, \uc0ac\uc6a9\uc790 \uc815\uc758 SQL \uac01 \ubd84\ud560 \ubc29\uc2dd\uc5d0 \ub300\ud55c \uc0ac\ub840\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-5-toc\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-5-toc\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-5-toc\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-1.jpeg\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-1.jpeg\",\"width\":960,\"height\":640},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-5-toc\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DBMS_PARALLEL_EXECUTE \uc124\uba85\uae00 \ubaa9\ucc28\"}]},{\"@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":"DBMS_PARALLEL_EXECUTE Description Table of Contents - Productivity Skill","description":"This is a table of contents for DBMS_PARALLEL_EXECUTE, available starting with Oracle 11g R2. Clicking on each item will take you to the corresponding article. Examples of each partitioning method are provided: ROWID, NUMBER Column, and user-defined SQL.","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-5-toc\/","og_locale":"en_US","og_type":"article","og_title":"DBMS_PARALLEL_EXECUTE \uc124\uba85\uae00 \ubaa9\ucc28 - \uc0dd\uc0b0\uc131 Skill","og_description":"Oracle 11g R2\ubd80\ud130 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 DBMS_PARALLEL_EXECUTE \uc124\uba85\uae00 \ubaa9\ucc28 \uc774\ub2e4. \uac01 \ubaa9\ucc28\ub97c \ud074\ub9ad\ud558\uba74 \ud574\ub2f9 \uae00\ub85c \uc774\ub3d9\ud55c\ub2e4. ROWID, NUMBER Column, \uc0ac\uc6a9\uc790 \uc815\uc758 SQL \uac01 \ubd84\ud560 \ubc29\uc2dd\uc5d0 \ub300\ud55c \uc0ac\ub840\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-5-toc\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-10-02T12:19:54+00:00","article_modified_time":"2022-10-04T14:57:42+00:00","og_image":[{"width":960,"height":640,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1.jpeg","type":"image\/jpeg"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Zerom","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-5-toc\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-5-toc\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"DBMS_PARALLEL_EXECUTE \uc124\uba85\uae00 \ubaa9\ucc28","datePublished":"2022-10-02T12:19:54+00:00","dateModified":"2022-10-04T14:57:42+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-5-toc\/"},"wordCount":114,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-5-toc\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1.jpeg","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-5-toc\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-5-toc\/","url":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-5-toc\/","name":"DBMS_PARALLEL_EXECUTE Description Table of Contents - Productivity Skill","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-5-toc\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-5-toc\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1.jpeg","datePublished":"2022-10-02T12:19:54+00:00","dateModified":"2022-10-04T14:57:42+00:00","description":"This is a table of contents for DBMS_PARALLEL_EXECUTE, available starting with Oracle 11g R2. Clicking on each item will take you to the corresponding article. Examples of each partitioning method are provided: ROWID, NUMBER Column, and user-defined SQL.","breadcrumb":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-5-toc\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/oracle-dbms-parallel-execute-5-toc\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-5-toc\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1.jpeg","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-1.jpeg","width":960,"height":640},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-5-toc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"DBMS_PARALLEL_EXECUTE \uc124\uba85\uae00 \ubaa9\ucc28"}]},{"@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\/11896","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=11896"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11896\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11897"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11896"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11896"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11896"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}