通过dbms_xplan.display_cursor来获取执行计划

最新推荐文章于 2021-04-04 13:37:50 发布

wahaishun

最新推荐文章于 2021-04-04 13:37:50 发布

阅读量250

点赞数

分类专栏： oracle 文章标签： SQL Access

本文链接：https://blog.csdn.net/wahaishun/article/details/83679573

版权

oracle 专栏收录该内容

20 篇文章

订阅专栏

用于查看已执行的sql的执行计划：

SQL> select count(*) from abc;

COUNT(*)
----------
10

SQL> select sql_id from v$sql where sql_text='select count(*) from abc';

SQL_ID
-------------
crrfjnb0y4mq1

SQL> select * from table(dbms_xplan.display_cursor('crrfjnb0y4mq1'));

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
SQL_ID crrfjnb0y4mq1, child number 0
-------------------------------------
select count(*) from abc

Plan hash value: 1045519631

-------------------------------------------------------------------
| Id | Operation          | Name | Rows | Cost (%CPU)| Time     |
-------------------------------------------------------------------
|   0 | SELECT STATEMENT   |      |       |     2 (100)|          |
|   1 | SORT AGGREGATE    |      |     1 |            |          |

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
| 2 | TABLE ACCESS FULL| ABC | 10 | 2 (0)| 00:00:01 |
-------------------------------------------------------------------

Note
-----
- dynamic sampling used for this statement

18 rows selected.

另外种灵活设置

select /*+gather_plan_statistics */ count(0) from abc

select * from table(dbms_xplan.display_cursor('crrfjnb0y4mq1',null,'all iostats last'));

....