{"id":73293,"date":"2012-08-02T16:33:26","date_gmt":"2012-08-02T16:33:26","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/uncategorized\/oracle-cost-based-optimizer-advanced\/"},"modified":"2021-07-14T13:07:52","modified_gmt":"2021-07-14T13:07:52","slug":"oracle-cost-based-optimizer-advanced","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/databases\/oracle-databases\/oracle-cost-based-optimizer-advanced\/","title":{"rendered":"Oracle Cost-Based Optimizer Advanced"},"content":{"rendered":"<p>This video and set of resources is a follow up to the <a href=\"http:\/\/www.red-gate.com\/products\/oracle-development\/deployment-suite-for-oracle\/education\/webinars\/webinar-randolf-geist-oracle-cost-based-optimizer-advanced\" target=\"blank\">webinar<\/a> broadcast by <a href=\"http:\/\/www.red-gate.com\/products\/oracle-development\/\">Red Gate<\/a> on 01 August 2012.<\/p>\n<p>You may want to watch <a href=\"oracle-cost-based-optimizer-basics-webinar\">Oracle Cost-Based Optimizer Basics<\/a> before you view this video<\/p>\n<p><a href=\"http:\/\/www.red-gate.com\/products\/oracle-development\/deployment-suite-for-oracle\/education\/webinars\/webinar-randolf-geist-oracle-cost-based-optimizer-advanced\" target=\"blank\"><button class=\"btn\"><span>Watch video<\/span><\/button><\/a><\/p>\n<p>The video above is accompanied by the following downloadable resources:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/08\/README.TXT\" target=\"blank\">Read me<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/08\/Oracle-Cost-Based-Optimizer-Advanced-Randolf-Geist.pdf\" target=\"blank\">Presentation slides &#8211; PDF version<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/08\/Oracle-Cost-Based-Optimizer-Advanced-Randolf-Geist.pptx\" target=\"blank\">Presentation slides &#8211; PowerPoint version<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/08\/concurrent_execution_inserts_check_results.sql\" target=\"blank\">concurrent_execution_inserts_check_results.sql<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/08\/concurrent_execution_inserts_testcase.sql\" target=\"blank\">concurrent_execution_inserts_testcase.sql<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/08\/concurrent_execution_launch_slaves.sql\" target=\"blank\">concurrent_execution_launch_slaves.sql<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/08\/daft_data_type_example.sql\" target=\"blank\">daft_data_type_example.sql<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/08\/frequency_histogram_egde_case.sql\" target=\"blank\">frequency_histogram_egde_case.sql<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/08\/histogram_limitations_testcase.sql\" target=\"blank\">histogram_limitations_testcase.sql<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/08\/implicit_datatype_conversion_nvarchar_scratchpad.sql\" target=\"blank\">implicit_datatype_conversion_nvarchar_scratchpad.sql<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/08\/insert_no_wait.sql\" target=\"blank\">insert_no_wait.sql<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/08\/xplan_extended_display_cursor.sql\" target=\"blank\">xplan_extended_display_cursor.sql<\/a><\/li>\n<li><a href=\"https:\/\/www.red-gate.com\/simple-talk\/wp-content\/uploads\/oracle\/2012\/08\/Oracle-Cost-Based-Optimizer-Advanced-Webinar-Resources.zip\" target=\"blank\">Download all resources (.zip)<\/a><\/li>\n<\/ul>\n<p>Building on the previous\u00a0<a href=\"http:\/\/www.red-gate.com\/products\/oracle-development\/deployment-suite-for-oracle\/education\/webinars\/webinar-randolf-geist-oracle-cost-based-optimizer\">Cost-Based Optimizer Basics<\/a>\u00a0webinar, in this almost &#8220;zero-slide&#8221; session we&#8217;ll explore different aspects of the Cost-Based Optimizer that haven&#8217;t been covered or only mentioned briefly in the &#8216;basics&#8217; session.<\/p>\n<p>This is a continuous live demonstration including topics like: Clustering Factor, Histograms, Dynamic Sampling, Virtual Columns, Daft Data Types and more. If you&#8217;ve ever asked yourself why a histogram can be a threat to database performance and why storing data using the correct data type matters regarding Execution Plans then this session is for you. It is recommended, although not required, to\u00a0<a href=\"http:\/\/www.red-gate.com\/products\/oracle-development\/deployment-suite-for-oracle\/education\/webinars\/webinar-randolf-geist-oracle-cost-based-optimizer\">watch the recording<\/a>\u00a0of the &#8216;basics&#8217; webinar first.<\/p>\n<p>A live Q+A session with Randolf Geist follows the presentation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This video and set of resources is a follow up to the webinar broadcast by Red Gate on 01 August 2012. You may want to watch Oracle Cost-Based Optimizer Basics before you view this video Watch video The video above is accompanied by the following downloadable resources: Read me Presentation slides &#8211; PDF version Presentation slides &#8211; PowerPoint version concurrent_execution_inserts_check_results.sq&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-73293","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\/73293","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=73293"}],"version-history":[{"count":1,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73293\/revisions"}],"predecessor-version":[{"id":91747,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/73293\/revisions\/91747"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=73293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=73293"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=73293"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=73293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}