SQL语句执行计划
来源:互联网 发布:阿里云字体图标 编辑:程序博客网 时间:2024/03/29 17:19
- SQL> set linesize 200 pagesize 200
- SQL> explain plan for select bytes from dba_free_space;
- Explained.
- SQL> select * from table(dbms_xplan.display());
- PLAN_TABLE_OUTPUT
- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- Plan hash value: 2345329605
- -----------------------------------------------------------------------------------------------------
- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
- -----------------------------------------------------------------------------------------------------
- | 0 | SELECT STATEMENT | | 10559 | 134K| 20 (10)| 00:00:01 |
- | 1 | VIEW | DBA_FREE_SPACE | 10559 | 134K| 20 (10)| 00:00:01 |
- | 2 | UNION-ALL | | | | | |
- | 3 | NESTED LOOPS | | 1 | 56 | 1 (0)| 00:00:01 |
- | 4 | NESTED LOOPS | | 1 | 45 | 1 (0)| 00:00:01 |
- | 5 | INDEX FULL SCAN | I_FILE2 | 9 | 54 | 1 (0)| 00:00:01 |
- |* 6 | TABLE ACCESS CLUSTER | FET$ | 1 | 39 | 0 (0)| 00:00:01 |
- |* 7 | INDEX UNIQUE SCAN | I_TS# | 1 | | 0 (0)| 00:00:01 |
- |* 8 | TABLE ACCESS CLUSTER | TS$ | 1 | 11 | 0 (0)| 00:00:01 |
- |* 9 | INDEX UNIQUE SCAN | I_TS# | 1 | | 0 (0)| 00:00:01 |
- | 10 | NESTED LOOPS | | 65 | 4030 | 6 (0)| 00:00:01 |
- | 11 | NESTED LOOPS | | 65 | 3640 | 6 (0)| 00:00:01 |
- |* 12 | TABLE ACCESS FULL | TS$ | 8 | 136 | 6 (0)| 00:00:01 |
- |* 13 | FIXED TABLE FIXED INDEX | X$KTFBFE (ind:1) | 8 | 312 | 0 (0)| 00:00:01 |
- |* 14 | INDEX UNIQUE SCAN | I_FILE2 | 1 | 6 | 0 (0)| 00:00:01 |
- | 15 | NESTED LOOPS | | 10492 | 1014K| 9 (23)| 00:00:01 |
- | 16 | NESTED LOOPS | | 5 | 170 | 7 (0)| 00:00:01 |
- | 17 | NESTED LOOPS | | 5 | 85 | 2 (0)| 00:00:01 |
- | 18 | INDEX FULL SCAN | I_FILE2 | 9 | 54 | 1 (0)| 00:00:01 |
- | 19 | TABLE ACCESS BY INDEX ROWID| RECYCLEBIN$ | 1 | 11 | 1 (0)| 00:00:01 |
- |* 20 | INDEX RANGE SCAN | RECYCLEBIN$_TS | 5 | | 0 (0)| 00:00:01 |
- |* 21 | TABLE ACCESS CLUSTER | TS$ | 1 | 17 | 1 (0)| 00:00:01 |
- |* 22 | INDEX UNIQUE SCAN | I_TS# | 1 | | 0 (0)| 00:00:01 |
- |* 23 | FIXED TABLE FIXED INDEX | X$KTFBUE (ind:1) | 2222 | 141K| 0 (0)| 00:00:01 |
- | 24 | NESTED LOOPS | | 1 | 80 | 4 (0)| 00:00:01 |
- | 25 | NESTED LOOPS | | 1 | 74 | 4 (0)| 00:00:01 |
- | 26 | NESTED LOOPS | | 1 | 63 | 4 (0)| 00:00:01 |
- | 27 | TABLE ACCESS FULL | RECYCLEBIN$ | 5 | 55 | 4 (0)| 00:00:01 |
- | 28 | TABLE ACCESS CLUSTER | UET$ | 1 | 52 | 0 (0)| 00:00:01 |
- |* 29 | INDEX UNIQUE SCAN | I_FILE#_BLOCK# | 1 | | 0 (0)| 00:00:01 |
- |* 30 | TABLE ACCESS CLUSTER | TS$ | 1 | 11 | 0 (0)| 00:00:01 |
- |* 31 | INDEX UNIQUE SCAN | I_TS# | 1 | | 0 (0)| 00:00:01 |
- |* 32 | INDEX UNIQUE SCAN | I_FILE2 | 1 | 6 | 0 (0)| 00:00:01 |
- -----------------------------------------------------------------------------------------------------
- Predicate Information (identified by operation id):
- ---------------------------------------------------
- 6 - filter("F"."FILE#"="FI"."RELFILE#")
- 7 - access("F"."TS#"="FI"."TS#")
- 8 - filter("TS"."BITMAPPED"=0)
- 9 - access("TS"."TS#"="F"."TS#")
- 12 - filter("TS"."BITMAPPED"<>0 AND ("TS"."ONLINE$"=1 OR "TS"."ONLINE$"=4) AND
- "TS"."CONTENTS$"=0)
- 13 - filter("TS"."TS#"="F"."KTFBFETSN")
- 14 - access("F"."KTFBFETSN"="FI"."TS#" AND "F"."KTFBFEFNO"="FI"."RELFILE#")
- 20 - access("RB"."TS#"="FI"."TS#")
- 21 - filter("TS"."BITMAPPED"<>0 AND ("TS"."ONLINE$"=1 OR "TS"."ONLINE$"=4) AND
- "TS"."CONTENTS$"=0)
- 22 - access("TS"."TS#"="RB"."TS#")
- 23 - filter("U"."KTFBUEFNO"="FI"."RELFILE#" AND "U"."KTFBUESEGTSN"="RB"."TS#" AND
- "U"."KTFBUESEGFNO"="RB"."FILE#" AND "U"."KTFBUESEGBNO"="RB"."BLOCK#")
- 29 - access("U"."TS#"="RB"."TS#" AND "U"."SEGFILE#"="RB"."FILE#" AND
- "U"."SEGBLOCK#"="RB"."BLOCK#")
- 30 - filter("TS"."BITMAPPED"=0)
- 31 - access("TS"."TS#"="U"."TS#")
- 32 - access("U"."TS#"="FI"."TS#" AND "U"."SEGFILE#"="FI"."RELFILE#")
- 62 rows selected.
0 0
- SQL语句执行计划
- sql语句执行计划
- SQL语句执行计划查询
- SQL语句的执行计划和暗示
- SQL语句的执行计划和暗示
- 一个sql语句执行计划的分析
- Oracle10g里sql语句的执行计划
- 追踪SQL语句,查看执行计划系列
- Oracle 查看sql语句执行计划方法
- Oracle查看SQL语句的执行计划
- 查看sql语句的执行计划
- 使用trace跟踪sql语句执行计划
- 查看sql语句的执行计划
- Oracle查看SQL语句的执行计划
- Oracle中SQL语句执行计划,调优
- 命令获取sql语句的执行计划
- 通过分析SQL语句的执行计划优化SQL
- 通过分析SQL语句的执行计划优化SQL
- hdu 2046递推
- Android 仿IOS的UIPickerView的效果
- Ubuntu下安装Anaconda
- DWZ使用自定义图标的方法
- myeclipse的svn: E175002: java.lang.RuntimeException: Could not generate DH keypair
- SQL语句执行计划
- 一句话概括下spring框架及spring cloud框架主要组件
- JSP页面tdl自定义标签的做法
- IEEE 802.15.4协议完整中文版 - 5.1.2.4 - 5.1.2.5
- ubantu16.04在Firefox上安装Adobe Flash Player
- android 动态权限添加 ,你不得不学
- redis集群安装配置数据迁移和客户端(java方向)第三节,客户端
- 《Android音频焦点机制深入理解》
- OpenWrt基于HAProxy的透明代理负载均衡和高可用部署