{"id":25029,"date":"2024-03-16T04:14:35","date_gmt":"2024-03-16T04:14:35","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/"},"modified":"2024-03-22T05:11:07","modified_gmt":"2024-03-22T05:11:07","slug":"how-to-view-the-execution-plan-in-oracle-2","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/","title":{"rendered":"How to view the execution plan in Oracle?"},"content":{"rendered":"

In Oracle, you can view the execution plan using the following methods: 1. Use the EXPLAIN PLAN statement: Add EXPLAIN PLAN FOR before the SQL statement, then use SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY) to display the execution plan. For example:<\/p>\n

EXPLAIN PLAN FOR SELECT * FROM employees;
<\/p>
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);<\/p><\/pre>\n
2. Enable AUTOTRACE feature: You can enable the AUTOTRACE feature in tools like SQL Developer to display the execution plan. Just select the “Enable Autotrace” option when executing SQL statements in the tool.<\/p>\n
3. Use SQL Trace: You can enable SQL Trace to collect the execution information of SQL statements, including the execution plan. Use the following statement to enable SQL Trace:<\/p>\n
ALTER SESSION SET SQL_TRACE = TRUE;<\/pre>\n
Following that, utilize tools like tkprof to analyze the trace file, which contains information about the execution plan. Regardless of the method used, the execution plan will be displayed in the query results, showing the sequence of operations, types of operations, and the indexes used.<\/p>\n","protected":false},"excerpt":{"rendered":"
In Oracle, you can view the execution plan using the following methods: 1. Use the EXPLAIN PLAN statement: Add EXPLAIN PLAN FOR before the SQL statement, then use SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY) to display the execution plan. For example: EXPLAIN PLAN FOR SELECT * FROM employees;SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY); 2. Enable AUTOTRACE feature: You can enable the AUTOTRACE feature in tools like SQL Developer […]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-25029","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nHow to view the execution plan in Oracle? - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to view the execution plan in Oracle?\" \/>\n<meta property=\"og:description\" content=\"In Oracle, you can view the execution plan using the following methods: 1. Use the EXPLAIN PLAN statement: Add EXPLAIN PLAN FOR before the SQL statement, then use SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY) to display the execution plan. For example: EXPLAIN PLAN FOR SELECT * FROM employees;SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY); 2. Enable AUTOTRACE feature: You can enable the AUTOTRACE feature in tools like SQL Developer […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-16T04:14:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T05:11:07+00:00\" \/>\n<meta name=\"author\" content=\"Olivia Parker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Olivia Parker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/\"},\"author\":{\"name\":\"Olivia Parker\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\"},\"headline\":\"How to view the execution plan in Oracle?\",\"datePublished\":\"2024-03-16T04:14:35+00:00\",\"dateModified\":\"2024-03-22T05:11:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/\"},\"wordCount\":153,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/\",\"name\":\"How to view the execution plan in Oracle? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T04:14:35+00:00\",\"dateModified\":\"2024-03-22T05:11:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to view the execution plan in Oracle?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\",\"name\":\"Olivia Parker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"caption\":\"Olivia Parker\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to view the execution plan in Oracle? - Blog - Silicon Cloud","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:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/","og_locale":"en_US","og_type":"article","og_title":"How to view the execution plan in Oracle?","og_description":"In Oracle, you can view the execution plan using the following methods: 1. Use the EXPLAIN PLAN statement: Add EXPLAIN PLAN FOR before the SQL statement, then use SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY) to display the execution plan. For example: EXPLAIN PLAN FOR SELECT * FROM employees;SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY); 2. Enable AUTOTRACE feature: You can enable the AUTOTRACE feature in tools like SQL Developer […]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T04:14:35+00:00","article_modified_time":"2024-03-22T05:11:07+00:00","author":"Olivia Parker","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Olivia Parker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/"},"author":{"name":"Olivia Parker","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9"},"headline":"How to view the execution plan in Oracle?","datePublished":"2024-03-16T04:14:35+00:00","dateModified":"2024-03-22T05:11:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/"},"wordCount":153,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/","name":"How to view the execution plan in Oracle? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T04:14:35+00:00","dateModified":"2024-03-22T05:11:07+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-in-oracle-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to view the execution plan in Oracle?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9","name":"Olivia Parker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","caption":"Olivia Parker"},"url":"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/25029","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=25029"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/25029\/revisions"}],"predecessor-version":[{"id":59102,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/25029\/revisions\/59102"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=25029"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=25029"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=25029"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}