{"id":11844,"date":"2022-10-02T10:20:50","date_gmt":"2022-10-02T01:20:50","guid":{"rendered":"https:\/\/prodskill.com\/?p=11844"},"modified":"2022-10-04T23:51:45","modified_gmt":"2022-10-04T14:51:45","slug":"oracle-dbms-parallel-execute-1-overview","status":"publish","type":"post","link":"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-1-overview\/","title":{"rendered":"1. Overview of parallel processing of DML jobs (DBMS_PARALLEL_EXECUTE)"},"content":{"rendered":"

Introduces DBMS_PARALLEL_EXECUTE, which can be used from Oracle 11g R2, and examines use cases.<\/p>\n\n\n

\n
\"DBMS_PARALLEL_EXECUTE<\/a>
DBMS_PARALLEL_EXECUTE Execution Conceptual Diagram<\/figcaption><\/figure>\n<\/div>\n\n\n

Image source: https:\/\/blogs.oracle.com\/warehousebuilder\/parallel-processing-with-dbmsparallelexecute<\/a><\/p><\/blockquote>\n\n\n\n

\n
\n

<<Table of Contents>><\/p>\nToggle<\/span><\/path><\/svg><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n

  • 1. Overview of Parallel Processing of DML Jobs<\/a>
    • 1.1. DML Parallel Processing Method<\/a><\/li>
    • 1.2. DBMS_PARALLEL_EXECUTE concept<\/a><\/li>
    • 1.3. Create tables and data for DBMS_PARALLEL_EXECUTE test<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n

      <\/span>1. Overview of Parallel Processing of DML Jobs<\/span><\/h2>\n\n\n\n

      <\/span>1.1. DML Parallel Processing Method<\/span><\/h3>\n\n\n\n

      Parallel processing is used when you want to quickly process one DML (INSERT, UPDATE, DELETE) operation in the database using as many resources as possible. There are two main methods of parallel processing.<\/p>\n\n\n\n

      The first method is to specify the parallel degree as a hint while executing one SQL (Parallel DML, single transaction), and the second method is to execute multiple SQLs by specifying the data range (Program Parallel DML, multi transaction). ) to be.<\/p>\n\n\n\n

      In most cases, the parallel DML method, which is the first method, is advantageous in terms of data consistency because it is processed as a single transaction. However, it is better to apply the second method in situations where the first method cannot be applied or when you want to define the size or range of the work unit yourself. (So the second method is also called DIY (Do It Yourself) Parallel DML)<\/p>\n\n\n\n

      The situation in which Parallel DML cannot be applied is, for example, as follows.<\/p>\n\n\n\n

      • DML to SELECT a table with LOB columns<\/li>
      • DML on DB Link<\/li>
      • Parallel processing DML in PL\/SQL units rather than SQL units or procedures implemented as complex procedures<\/li>
      • DML that is not implemented in PL\/SQL but runs in languages such as Java<\/li><\/ul>\n\n\n\n

        The steps for executing Program Parallel DML may vary slightly depending on the situation, but in general, they are as follows.<\/p>\n\n\n\n

        1. Selection of work targets<\/li>
        2. Selection of parallelism and division of work units (Partition, date, number, ROWID, etc.) -> Creation of .sql files by work units<\/li>
        3. Task Execution and Monitoring -> Execute each .sql file in individual session (SQL*Plus, etc.)<\/li>
        4. Confirm task completion -> Verification of row count comparison, sum comparison, etc.<\/li><\/ol>\n\n\n\n

          When the degree of parallelism (DOP) is changed or rework is required due to a change in requirements or circumstances, steps 2 and 3 are repeatedly performed and management and verification are not simple. It's inconvenient to have to manually repeat similar tasks over and over again whenever changes are needed.<\/p>\n\n\n\n

          <\/span>1.2. DBMS_PARALLEL_EXECUTE concept<\/span><\/h3>\n\n\n\n

          When using the Program Parallel method, using DBMS_PARALLEL_EXECUTE can execute and manage this task more conveniently.<\/p>\n\n\n\n

          * See Oracle Document: http:\/\/docs.oracle.com\/cd\/E11882_01\/appdev.112\/e40758\/d_parallel_ex.htm#ARPLS233<\/a><\/p>\n\n\n\n

          (For reference, DBMS_PARALLEL_EXECUTE uses JOB internally, so CREATE JOB authority must be granted to the executing user.)<\/p>\n\n\n\n

          DBMS_PARALLEL_EXECUTE is a Package introduced as a new feature in Oracle 11g R2. The list of major sub programs is shown in the following table, and the full list and explanation can be found in the Oracle document.<\/p>\n\n\n\n

          Sub program<\/td>Explanation<\/td><\/tr>
          CREATE_TASK Procedure<\/td>Create a task<\/td><\/tr>
          CREATE_CHUNKS_BY_NUMBER_COL Procedure<\/td>Create chunk by NUMBER column<\/td><\/tr>
          CREATE_CHUNKS_BY_ROWID Procedure<\/td>Creating chunks with ROWID<\/td><\/tr>
          CREATE_CHUNKS_BY_SQL Procedure<\/td>Creating chunks with custom SQL<\/td><\/tr>
          DROP_TASK Procedure<\/td>Remove Task<\/td><\/tr>
          DROP_CHUNKS Procedure<\/td>Eliminate chunks<\/td><\/tr>
          RESUME_TASK Procedures<\/td>Rerun a stopped task<\/td><\/tr>
          RUN_TASK Procedure<\/td>Execute the task<\/td><\/tr>
          STOP_TASK Procedure<\/td>Stop the task<\/td><\/tr>
          TASK_STATUS Procedure<\/td>Return task current status<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

          The steps for applying DBMS_PARALLEL_EXECUTE are almost similar to the steps for executing Program Parallel DML as follows.<\/p>\n\n\n\n

          1. Create Task (CREATE_TASK)<\/li>
          2. Splitting the work unit (Chunk)
            • CREATE_CHUNKS_BY_ROWID<\/li>
            • CREATE_CHUNKS_BY_NUMBER_COL<\/li>
            • CREATE_CHUNKS_BY_SQL<\/li><\/ul><\/li>
            • Execute task (RUN_TASK)<\/li>
            • Delete after task complete (DROP_TASK)<\/li><\/ol>\n\n\n\n

              <\/span>1.3. Create tables and data for DBMS_PARALLEL_EXECUTE test<\/span><\/h3>\n\n\n\n

              Create tables and data to be tested with the following script.<\/p>\n\n\n\n

              -- \ud14c\uc2a4\ud2b8 \ud14c\uc774\ube14\uacfc \ub370\uc774\ud130 \uc0dd\uc131\nDROP TABLE Z_DPE_TEST_TAB PURGE;\n\nCREATE TABLE Z_DPE_TEST_TAB (\n    ID      NUMBER(10)\n   ,MSG     VARCHAR2(100)\n   ,VAL     NUMBER\n   ,AUDSID  NUMBER\n) NOLOGGING;\n\n-- 100\ub9cc\uac74 \ud14c\uc2a4\ud2b8 \ub370\uc774\ud130 \uc0dd\uc131\nINSERT \/*+ APPEND *\/ INTO Z_DPE_TEST_TAB (ID, MSG)\nSELECT  LEVEL AS ID\n       ,'Test Data ID: ' || TO_CHAR(LEVEL)\n  FROM  DUAL\nCONNECT BY LEVEL <= 1000000;\n\nCOMMIT;<\/pre>\n\n\n\n
              There are 4 columns to be used in the test, and each purpose is as follows.<\/p>\n\n\n\n
              column name<\/td>purpose<\/td><\/tr>
              ID<\/td>A value to identify each row in the table<\/td><\/tr>
              MSG<\/td>A value that provides a description<\/td><\/tr>
              VAL<\/td>Random value updated in test execution<\/td><\/tr>
              AUDSID<\/td>A value to check how many sessions the test runs in.
              It is updated with SYS_CONTEXT('USERENV','SESSIONID').<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
              For reference, the environment in which this test was conducted is as follows.<\/p>\n\n\n\n
              • DBMS: Oracle 11g R2 Enterprise 11.2.0.1.0 32 bit (On Windows 7 x64)<\/li>
              • H\/W: CPU i5-5200U 2.20GHz, Memory 8GB, SSD 250GB<\/li><\/ul>\n\n\n\n
                Next, let's look at a case by way of dividing each work unit (chunk).<\/p>\n\n\n\n
                <\/p>","protected":false},"excerpt":{"rendered":"
                Introduces DBMS_PARALLEL_EXECUTE, which can be used from Oracle 11g R2, and examines use cases. Image source: https:\/\/blogs.oracle.com\/warehousebuilder\/parallel-processing-with-dbmsparallelexecute 1. Overview of Parallel Processing of DML Tasks 1.1. DML Parallel Processing Method Parallel Processing is used when you want to quickly process one DML (INSERT, UPDATE, DELETE) job in the database by using as many resources as possible. There are two main methods of parallel processing. first...<\/p>","protected":false},"author":1,"featured_media":11845,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[242,243,244,245,246],"class_list":["post-11844","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":"\n1. DML \uc791\uc5c5\uc758 \ubcd1\ub82c \ucc98\ub9ac \uac1c\uc694 (DBMS_PARALLEL_EXECUTE) - \uc0dd\uc0b0\uc131 Skill<\/title>\n<meta name=\"description\" content=\"Oracle 11g R2\ubd80\ud130 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 DBMS_PARALLEL_EXECUTE \uc5d0 \ub300\ud574 \uc18c\uac1c\ud558\uace0 \ud65c\uc6a9\uc0ac\ub840\ub97c \uc0b4\ud3b4\ubcf8\ub2e4. DML \uc791\uc5c5\uc758 \ubcd1\ub82c \ucc98\ub9ac \uac1c\uc694, DBMS_PARALLEL_EXECUTE \uac1c\ub150\uc5d0 \ub300\ud574 \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-1-overview\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"1. DML \uc791\uc5c5\uc758 \ubcd1\ub82c \ucc98\ub9ac \uac1c\uc694 (DBMS_PARALLEL_EXECUTE) - \uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"og:description\" content=\"Oracle 11g R2\ubd80\ud130 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 DBMS_PARALLEL_EXECUTE \uc5d0 \ub300\ud574 \uc18c\uac1c\ud558\uace0 \ud65c\uc6a9\uc0ac\ub840\ub97c \uc0b4\ud3b4\ubcf8\ub2e4. DML \uc791\uc5c5\uc758 \ubcd1\ub82c \ucc98\ub9ac \uac1c\uc694, DBMS_PARALLEL_EXECUTE \uac1c\ub150\uc5d0 \ub300\ud574 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-1-overview\/\" \/>\n<meta property=\"og:site_name\" content=\"\uc0dd\uc0b0\uc131 Skill\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-02T01:20:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-04T14:51:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-42.png\" \/>\n\t<meta property=\"og:image:width\" content=\"563\" \/>\n\t<meta property=\"og:image:height\" content=\"476\" \/>\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=\"4 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-1-overview\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-1-overview\\\/\"},\"author\":{\"name\":\"Zerom\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"headline\":\"1. DML \uc791\uc5c5\uc758 \ubcd1\ub82c \ucc98\ub9ac \uac1c\uc694 (DBMS_PARALLEL_EXECUTE)\",\"datePublished\":\"2022-10-02T01:20:50+00:00\",\"dateModified\":\"2022-10-04T14:51:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-1-overview\\\/\"},\"wordCount\":309,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#\\\/schema\\\/person\\\/bbad0870c78008c82edbe0960fe768bd\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-1-overview\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-42.png\",\"keywords\":[\"ORACLE\",\"DBMS_PARALLEL_EXECUTE\",\"\ubcd1\ub82c\ucc98\ub9ac\",\"DML Parallel Processing\",\"DML \ubcd1\ub82c\ucc98\ub9ac\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-1-overview\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-1-overview\\\/\",\"url\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-1-overview\\\/\",\"name\":\"1. DML \uc791\uc5c5\uc758 \ubcd1\ub82c \ucc98\ub9ac \uac1c\uc694 (DBMS_PARALLEL_EXECUTE) - \uc0dd\uc0b0\uc131 Skill\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-1-overview\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-1-overview\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-42.png\",\"datePublished\":\"2022-10-02T01:20:50+00:00\",\"dateModified\":\"2022-10-04T14:51:45+00:00\",\"description\":\"Oracle 11g R2\ubd80\ud130 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 DBMS_PARALLEL_EXECUTE \uc5d0 \ub300\ud574 \uc18c\uac1c\ud558\uace0 \ud65c\uc6a9\uc0ac\ub840\ub97c \uc0b4\ud3b4\ubcf8\ub2e4. DML \uc791\uc5c5\uc758 \ubcd1\ub82c \ucc98\ub9ac \uac1c\uc694, DBMS_PARALLEL_EXECUTE \uac1c\ub150\uc5d0 \ub300\ud574 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-1-overview\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-1-overview\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-1-overview\\\/#primaryimage\",\"url\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-42.png\",\"contentUrl\":\"https:\\\/\\\/prodskill.com\\\/wp-content\\\/uploads\\\/2022\\\/10\\\/image-42.png\",\"width\":563,\"height\":476},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/prodskill.com\\\/oracle-dbms-parallel-execute-1-overview\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/prodskill.com\\\/ko\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"1. DML \uc791\uc5c5\uc758 \ubcd1\ub82c \ucc98\ub9ac \uac1c\uc694 (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":"1. Overview of Parallel Processing of DML Operations (DBMS_PARALLEL_EXECUTE) - Productivity Skill","description":"This article introduces DBMS_PARALLEL_EXECUTE, available starting with Oracle 11g R2, and explores its use cases. You can learn about parallel processing of DML operations and the concept of DBMS_PARALLEL_EXECUTE.","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-1-overview\/","og_locale":"en_US","og_type":"article","og_title":"1. DML \uc791\uc5c5\uc758 \ubcd1\ub82c \ucc98\ub9ac \uac1c\uc694 (DBMS_PARALLEL_EXECUTE) - \uc0dd\uc0b0\uc131 Skill","og_description":"Oracle 11g R2\ubd80\ud130 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 DBMS_PARALLEL_EXECUTE \uc5d0 \ub300\ud574 \uc18c\uac1c\ud558\uace0 \ud65c\uc6a9\uc0ac\ub840\ub97c \uc0b4\ud3b4\ubcf8\ub2e4. DML \uc791\uc5c5\uc758 \ubcd1\ub82c \ucc98\ub9ac \uac1c\uc694, DBMS_PARALLEL_EXECUTE \uac1c\ub150\uc5d0 \ub300\ud574 \ud655\uc778\ud560 \uc218 \uc788\ub2e4.","og_url":"https:\/\/prodskill.com\/en\/oracle-dbms-parallel-execute-1-overview\/","og_site_name":"\uc0dd\uc0b0\uc131 Skill","article_published_time":"2022-10-02T01:20:50+00:00","article_modified_time":"2022-10-04T14:51:45+00:00","og_image":[{"width":563,"height":476,"url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-42.png","type":"image\/png"}],"author":"Zerom","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Zerom","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-1-overview\/#article","isPartOf":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-1-overview\/"},"author":{"name":"Zerom","@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"headline":"1. DML \uc791\uc5c5\uc758 \ubcd1\ub82c \ucc98\ub9ac \uac1c\uc694 (DBMS_PARALLEL_EXECUTE)","datePublished":"2022-10-02T01:20:50+00:00","dateModified":"2022-10-04T14:51:45+00:00","mainEntityOfPage":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-1-overview\/"},"wordCount":309,"commentCount":0,"publisher":{"@id":"https:\/\/prodskill.com\/ko\/#\/schema\/person\/bbad0870c78008c82edbe0960fe768bd"},"image":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-1-overview\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-42.png","keywords":["ORACLE","DBMS_PARALLEL_EXECUTE","\ubcd1\ub82c\ucc98\ub9ac","DML Parallel Processing","DML \ubcd1\ub82c\ucc98\ub9ac"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/prodskill.com\/oracle-dbms-parallel-execute-1-overview\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-1-overview\/","url":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-1-overview\/","name":"1. Overview of Parallel Processing of DML Operations (DBMS_PARALLEL_EXECUTE) - Productivity Skill","isPartOf":{"@id":"https:\/\/prodskill.com\/ko\/#website"},"primaryImageOfPage":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-1-overview\/#primaryimage"},"image":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-1-overview\/#primaryimage"},"thumbnailUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-42.png","datePublished":"2022-10-02T01:20:50+00:00","dateModified":"2022-10-04T14:51:45+00:00","description":"This article introduces DBMS_PARALLEL_EXECUTE, available starting with Oracle 11g R2, and explores its use cases. You can learn about parallel processing of DML operations and the concept of DBMS_PARALLEL_EXECUTE.","breadcrumb":{"@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-1-overview\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/prodskill.com\/oracle-dbms-parallel-execute-1-overview\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-1-overview\/#primaryimage","url":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-42.png","contentUrl":"https:\/\/prodskill.com\/wp-content\/uploads\/2022\/10\/image-42.png","width":563,"height":476},{"@type":"BreadcrumbList","@id":"https:\/\/prodskill.com\/oracle-dbms-parallel-execute-1-overview\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/prodskill.com\/ko\/"},{"@type":"ListItem","position":2,"name":"1. DML \uc791\uc5c5\uc758 \ubcd1\ub82c \ucc98\ub9ac \uac1c\uc694 (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\/11844","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=11844"}],"version-history":[{"count":0,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/posts\/11844\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media\/11845"}],"wp:attachment":[{"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/media?parent=11844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/categories?post=11844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prodskill.com\/en\/wp-json\/wp\/v2\/tags?post=11844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}