ORACLE学习笔记系列(2)处理 SQLPLUS剖析SQL句子呈现 'PLANITeye - 娱乐之横扫全球

ORACLE学习笔记系列(2)处理 SQLPLUS剖析SQL句子呈现 'PLANITeye

2019-01-11 15:33:50 | 作者: 昆颉 | 标签: | 浏览: 164

PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------ Plan hash value: 4102440123 ---------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | ---------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 2443 | 5604K| 730 (7)| 00:00:09 | |* 1 | HASH JOIN | | 2443 | 5604K| 730 (7)| 00:00:09 | | 2 | FIXED TABLE FULL | X$KSPPCV | 100 | 196K| 0 (0)| 00:00:01 | | 3 | MERGE JOIN CARTESIAN | | 2443 | 796K| 729 (7)| 00:00:09 | |* 4 | HASH JOIN RIGHT OUTER | | 2443 | 665K| 686 (2)| 00:00:09 | | 5 | TABLE ACCESS FULL | SEG$ | 6400 | 281K| 52 (0)| 00:00:01 | PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------ |* 6 | HASH JOIN RIGHT OUTER | | 2392 | 546K| 633 (1)| 00:00:08 | | 7 | TABLE ACCESS FULL | USER$ | 95 | 1615 | 3 (0)| 00:00:01 | |* 8 | HASH JOIN RIGHT OUTER | | 2392 | 506K| 630 (1)| 00:00:08 | | 9 | TABLE ACCESS FULL | DEFERRED_STG$ | 2781 | 69525 | 7 (0)| 00:00:01 | |* 10 | HASH JOIN OUTER | | 2392 | 448K| 622 (1)| 00:00:08 | | 11 | NESTED LOOPS OUTER | | 2392 | 429K| 563 (1)| 00:00:07 | |* 12 | HASH JOIN | | 2392 | 359K| 361 (2)| 00:00:05 | | 13 | TABLE ACCESS FULL | TS$ | 8 | 160 | 5 (0)| 00:00:01 | | 14 | NESTED LOOPS | | 2392 | 313K| 356 (2)| 00:00:05 | |* 15 | TABLE ACCESS FULL | OBJ$ | 2392 | 86112 | 253 (2)| 00:00:04 | |* 16 | TABLE ACCESS CLUSTER | TAB$ | 1 | 98 | 1 (0)| 00:00:01 | PLAN_TABLE_OUTPUT ------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------ |* 17 | INDEX UNIQUE SCAN | I_OBJ# | 1 | | 0 (0)| 00:00:01 | | 18 | TABLE ACCESS BY INDEX ROWID| OBJ$ | 1 | 30 | 2 (0)| 00:00:01 | |* 19 | INDEX RANGE SCAN | I_OBJ1 | 1 | | 1 (0)| 00:00:01 | | 20 | INDEX FAST FULL SCAN | I_OBJ1 | 74188 | 579K| 58 (0)| 00:00:01 | | 21 | BUFFER SORT | | 1 | 55 | 677 (8)| 00:00:09 | |* 22 | FIXED TABLE FULL | X$KSPPI | 1 | 55 | 0 (0)| 00:00:01 | ---------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): ---------------------------------------------------
版权声明
本文来源于网络,版权归原作者所有,其内容与观点不代表娱乐之横扫全球立场。转载文章仅为传播更有价值的信息,如采编人员采编有误或者版权原因,请与我们联系,我们核实后立即修改或删除。

猜您喜欢的文章