利用DBMS_XPLAN包获取SQL执行计划

最新推荐文章于 2024-05-20 20:26:39 发布

congqingm32098

最新推荐文章于 2024-05-20 20:26:39 发布

阅读量148

点赞数

文章标签：数据库

Oracle默认安装没有创建DBMS_XPLAN包，我们必须手工安装

aplm@ORCLDEV> conn /as sysdba

aplm@ORCLDEV> @$ORACLE_HOME/rdbms/admin/utlsampl.sql

sys@ORCLDEV> @$ORACLE_HOME/rdbms/admin/utlxplan.sql

sys@ORCLDEV> CREATE PUBLIC SYNONYM plan_table FOR sys.plan_table;

sys@ORCLDEV> GRANT ALL ON sys.plan_table TO public;

sys@ORCLDEV> conn aplm/aplm
Connected.
aplm@ORCLDEV> explain plan for select * from t_dh_order_parts_analysis t where customer_ID = '001108';

Explained.

aplm@ORCLDEV> set linesize 130
aplm@ORCLDEV> set pagesize 0
aplm@ORCLDEV> select * from table(dbms_xplan.display);
Plan hash value: 4035939135

-----------------------------------------------------------------------------------------------
| Id | Operation   | Name        | Rows | Bytes | Cost (%CPU)| Time     |
-----------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT |         | 3007 |   663K|   874 (1)| 00:00:11 |
|* 1 | TABLE ACCESS FULL| T_DH_ORDER_PARTS_ANALYSIS | 3007 |   663K|   874 (1)| 00:00:11 |
-----------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

1 - filter("CUSTOMER_ID"='001108')

13 rows selected.

很清晰的看到SQL的执行计划

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7551038/viewspace-622156/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7551038/viewspace-622156/