{"id":14328,"date":"2024-03-15T08:54:56","date_gmt":"2024-03-15T08:54:56","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-of-pl-sql\/"},"modified":"2025-08-06T07:18:04","modified_gmt":"2025-08-06T07:18:04","slug":"how-to-view-the-execution-plan-of-pl-sql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-of-pl-sql\/","title":{"rendered":"View PL\/SQL Execution Plan Guide"},"content":{"rendered":"

In PL\/SQL, you can use the following methods to view the execution plan:<\/p>\n

    \n
  1. Using the DBMS_XPLAN package: this is a package provided by Oracle that can be used to display the execution plan of SQL statements. Firstly, enable the automatic tracing feature by setting SET AUTOTRACE ON, then execute the SQL statements in a PL\/SQL program, and finally use SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY()) to display the execution plan.<\/li>\n
  2. When using SQL Developer: If you are using Oracle SQL Developer as your development tool, you can select the “Execute Plan” button on the toolbar, or use the Ctrl+E shortcut to display the execution plan of your SQL statement.<\/li>\n
  3. When using SQLPlus, you can use the EXPLAIN PLAN statement to generate an execution plan and view the plan by using SELECT * FROM PLAN_TABLE.<\/li>\n<\/ol>\n

    Regardless of the method you use, make sure to set SET AUTOTRACE ON before running a query or use the EXPLAIN PLAN FOR statement to enable tracking of the execution plan.<\/p>\n","protected":false},"excerpt":{"rendered":"

    In PL\/SQL, you can use the following methods to view the execution plan: Using the DBMS_XPLAN package: this is a package provided by Oracle that can be used to display the execution plan of SQL statements. Firstly, enable the automatic tracing feature by setting SET AUTOTRACE ON, then execute the SQL statements in a PL\/SQL […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[19291,9115,19290,18099,11966],"class_list":["post-14328","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-oracle-dbms_xplan","tag-oracle-sql-developer","tag-pl-sql-execution-plan","tag-pl-sql-optimization","tag-sql-performance-tuning"],"yoast_head":"\nView PL\/SQL Execution Plan Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to view PL\/SQL execution plans. Step-by-step guide using DBMS_XPLAN package and SQL Developer for optimal SQL performance tuning.\" \/>\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-of-pl-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"View PL\/SQL Execution Plan Guide\" \/>\n<meta property=\"og:description\" content=\"Learn how to view PL\/SQL execution plans. Step-by-step guide using DBMS_XPLAN package and SQL Developer for optimal SQL performance tuning.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-of-pl-sql\/\" \/>\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-15T08:54:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-06T07:18:04+00:00\" \/>\n<meta name=\"author\" content=\"Emily Johnson\" \/>\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=\"Emily Johnson\" \/>\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-of-pl-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-of-pl-sql\/\"},\"author\":{\"name\":\"Emily Johnson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378\"},\"headline\":\"View PL\/SQL Execution Plan Guide\",\"datePublished\":\"2024-03-15T08:54:56+00:00\",\"dateModified\":\"2025-08-06T07:18:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-of-pl-sql\/\"},\"wordCount\":175,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Oracle DBMS_XPLAN\",\"Oracle SQL Developer\",\"PL\/SQL execution plan\",\"pl\/sql optimization\",\"SQL performance tuning\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-of-pl-sql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-of-pl-sql\/\",\"name\":\"View PL\/SQL Execution Plan Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T08:54:56+00:00\",\"dateModified\":\"2025-08-06T07:18:04+00:00\",\"description\":\"Learn how to view PL\/SQL execution plans. Step-by-step guide using DBMS_XPLAN package and SQL Developer for optimal SQL performance tuning.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-of-pl-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-of-pl-sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-of-pl-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"View PL\/SQL Execution Plan Guide\"}]},{\"@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\/3b041b19cffc258705478ecfab895378\",\"name\":\"Emily Johnson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"caption\":\"Emily Johnson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"View PL\/SQL Execution Plan Guide - Blog - Silicon Cloud","description":"Learn how to view PL\/SQL execution plans. Step-by-step guide using DBMS_XPLAN package and SQL Developer for optimal SQL performance tuning.","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-of-pl-sql\/","og_locale":"en_US","og_type":"article","og_title":"View PL\/SQL Execution Plan Guide","og_description":"Learn how to view PL\/SQL execution plans. Step-by-step guide using DBMS_XPLAN package and SQL Developer for optimal SQL performance tuning.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-of-pl-sql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T08:54:56+00:00","article_modified_time":"2025-08-06T07:18:04+00:00","author":"Emily Johnson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Emily Johnson","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-of-pl-sql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-of-pl-sql\/"},"author":{"name":"Emily Johnson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378"},"headline":"View PL\/SQL Execution Plan Guide","datePublished":"2024-03-15T08:54:56+00:00","dateModified":"2025-08-06T07:18:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-of-pl-sql\/"},"wordCount":175,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Oracle DBMS_XPLAN","Oracle SQL Developer","PL\/SQL execution plan","pl\/sql optimization","SQL performance tuning"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-of-pl-sql\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-of-pl-sql\/","name":"View PL\/SQL Execution Plan Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T08:54:56+00:00","dateModified":"2025-08-06T07:18:04+00:00","description":"Learn how to view PL\/SQL execution plans. Step-by-step guide using DBMS_XPLAN package and SQL Developer for optimal SQL performance tuning.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-of-pl-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-of-pl-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-view-the-execution-plan-of-pl-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"View PL\/SQL Execution Plan Guide"}]},{"@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\/3b041b19cffc258705478ecfab895378","name":"Emily Johnson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","caption":"Emily Johnson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/14328","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\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=14328"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/14328\/revisions"}],"predecessor-version":[{"id":158365,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/14328\/revisions\/158365"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=14328"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=14328"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=14328"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}