{"id":73243,"date":"2013-04-17T16:41:30","date_gmt":"2013-04-17T16:41:30","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/uncategorized\/analyzing-and-troubleshooting-oracle-parallel-execution\/"},"modified":"2021-07-14T13:07:42","modified_gmt":"2021-07-14T13:07:42","slug":"analyzing-and-troubleshooting-oracle-parallel-execution","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/databases\/oracle-databases\/analyzing-and-troubleshooting-oracle-parallel-execution\/","title":{"rendered":"Analyzing and Troubleshooting Oracle Parallel Execution"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/www.red-gate.com\/products\/oracle-development\/deployment-suite-for-oracle\/education\/webinars\/webinar-oracle-parallel-execution-randolf-geist?utm_source=allthingsoracle&amp;utm_medium=publink&amp;utm_content=webinar&amp;utm_campaign=deploymentsuitefororacle\" target=\"blank\"><button class=\"btn\"><span>Watch video<\/span><\/button><\/a><\/p>\n<p>The video above is accompanied by the following resources:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2013\/04\/Analysing-and-Troubleshooting-Parallel-Execution-short.pdf\">Analysing and Troubleshooting Parallel Execution presentation slides (.pdf)<\/a><\/l1>\n<\/ul>\n<p>Further reading:<\/p>\n<ul>\n<li><a href=\"https:\/\/blogs.oracle.com\/datawarehousing\/entry\/calculating_parameter_values_f\" target=\"blank\">Calculating Parameter Values for Parallelism<\/a><\/li>\n<li><a href=\"https:\/\/blogs.oracle.com\/datawarehousing\/entry\/auto_dop_and_concurrency\" target=\"blank\">Auto DOP and Concurrency<\/a><\/li>\n<li><a href=\"https:\/\/blogs.oracle.com\/datawarehousing\/entry\/auto_dop_and_queuing_parameter\" target=\"blank\">Auto DOP and Queuing Parameter Settings<\/a><\/li>\n<li><a href=\"https:\/\/blogs.oracle.com\/datawarehousing\/entry\/auto_dop_and_parallel_statemen\" target=\"blank\">Auto DOP and Parallel Statement Queuing<\/a><\/li>\n<li><a href=\"https:\/\/blogs.oracle.com\/datawarehousing\/entry\/workload_management_statement\" target=\"blank\">Workload Management \u2013 Statement Queuing<\/a><\/li>\n<li><a href=\"https:\/\/blogs.oracle.com\/datawarehousing\/entry\/workload_management_a_simple_b\" target=\"blank\">Workload Management \u2013 A Simple (but real) Example<\/a><\/li>\n<li><a href=\"https:\/\/blogs.oracle.com\/datawarehousing\/entry\/parallel_degree_limit_hierarch\" target=\"blank\">Parallel_degree_limit hierarchy \u2013 CPU, IO, Auto or Integer<\/a><\/li>\n<li><a href=\"https:\/\/blogs.oracle.com\/datawarehousing\/entry\/explaining_explain_plan_notes\" target=\"blank\">Explaining Explain Plan Notes for Auto DOP<\/a><\/li>\n<li><a href=\"https:\/\/blogs.oracle.com\/datawarehousing\/entry\/serial_plans_threshold_paralle\" target=\"blank\">Serial plans: Threshold \/ Parallel_degree_limit = 1<\/a><\/li>\n<\/ul>\n<p>Oracle parallel execution, a feature of the Enterprise Edition, allows you to automatically distribute the processing of a SQL statement execution among multiple worker processes. This requires additional effort when\u00a0analyzing\u00a0and troubleshooting such parallel executions, since it adds complexity that is simply not there with normal serial execution where only a single process is involved.<\/p>\n<p>This webinar will explain what these additional challenges are and how these can be approached.<\/p>\n<p>A live Q&amp;A session with Randolf Geist follows the presentation, if you would like to ask a question that wasn&#8217;t covered in this please add a comment below.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Watch video The video above is accompanied by the following resources: Analysing and Troubleshooting Parallel Execution presentation slides (.pdf) Further reading: Calculating Parameter Values for Parallelism Auto DOP and Concurrency Auto DOP and Queuing Parameter Settings Auto DOP and Parallel Statement Queuing Workload Management \u2013 Statement Queuing Workload Management \u2013 A Simple (but real) Example Parallel_degree_limit hierarchy \u2013 CPU,&hellip;<\/p>\n","protected":false},"author":316197,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[143533],"tags":[],"coauthors":[],"class_list":["post-73243","post","type-post","status-publish","format-standard","hentry","category-oracle-databases"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73243","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/316197"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=73243"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73243\/revisions"}],"predecessor-version":[{"id":91721,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73243\/revisions\/91721"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=73243"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=73243"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=73243"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=73243"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}