查看sql的执行计划

查看SQL的执行计划是掌握和判断数据库性能的基本技巧。有多种方式可以用来查看SQL的执行计划。

一种方式是使用方法dbms_xplan.display_cursor，前提条件是该SQL还在共享池中。如果执行计划的前提条件是该SQL已经被刷出共享池，那么只要该SQL的执行计划被Oracle采集到AWR Repository中，就可以用该方法来查看。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* [Oracle查看SQL执行计划的方式](https://blog.csdn.net/weixin_34130269/article/details/92543181)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *3* [查看sql执行计划方法汇总](https://blog.csdn.net/ckhwddy577380/article/details/100443226)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]