今天换了个新环境。用的sqlplus,可是输出的执行计划为什么是下面这样的??
输出的信息太少了。执行计划
---------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=
1 0 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1)
这是之前的执行计划 输出的样式执行计划
--------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 142 | 10366 | 170 (3)| 00:00:03 |
| 1 | SORT ORDER BY | | 142 | 10366 | 170 (3)| 00:00:03 |
| 2 | HASH GROUP BY | | 142 | 10366 | 170 (3)| 00:00:03 |
|* 3 | HASH JOIN RIGHT OUTER| | 672 | 49056 | 168 (2)| 00:00:03 |
|* 4 | TABLE ACCESS FULL | T_D_USER | 690 | 5520 | 5 (0)| 00:00:01 |
| 5 | NESTED LOOPS OUTER | | 672 | 43680 | 162 (1)| 00:00:02 |
|* 6 | HASH JOIN OUTER | | 672 | 37632 | 14 (8)| 00:00:01 |
|* 7 | TABLE ACCESS FULL | T_B_UNIVERSITY | 50 | 2050 | 8 (0)| 00:00:01 |
| 8 | TABLE ACCESS FULL | T_D_EDUCATION | 672 | 10080 | 5 (0)| 00:00:01 |
| 9 | VIEW | | 1 | 9 | 0 (0)| 00:00:01 |
|* 10 | FILTER | | | | | |
|* 11 | TABLE ACCESS FULL| T_D_VIDEO_PLAYER | 1 | 15 | 3 (0)| 00:00:01 |
-------------------------------------------------------------------------------------------- 对tuning不是很擅长,求高手指点下,如何得到之前比较详细的执行计划,需要做什么配置吗? tuning
输出的信息太少了。执行计划
---------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=
1 0 TABLE ACCESS (FULL) OF 'DUAL' (Cost=2 Card=1)
这是之前的执行计划 输出的样式执行计划
--------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 142 | 10366 | 170 (3)| 00:00:03 |
| 1 | SORT ORDER BY | | 142 | 10366 | 170 (3)| 00:00:03 |
| 2 | HASH GROUP BY | | 142 | 10366 | 170 (3)| 00:00:03 |
|* 3 | HASH JOIN RIGHT OUTER| | 672 | 49056 | 168 (2)| 00:00:03 |
|* 4 | TABLE ACCESS FULL | T_D_USER | 690 | 5520 | 5 (0)| 00:00:01 |
| 5 | NESTED LOOPS OUTER | | 672 | 43680 | 162 (1)| 00:00:02 |
|* 6 | HASH JOIN OUTER | | 672 | 37632 | 14 (8)| 00:00:01 |
|* 7 | TABLE ACCESS FULL | T_B_UNIVERSITY | 50 | 2050 | 8 (0)| 00:00:01 |
| 8 | TABLE ACCESS FULL | T_D_EDUCATION | 672 | 10080 | 5 (0)| 00:00:01 |
| 9 | VIEW | | 1 | 9 | 0 (0)| 00:00:01 |
|* 10 | FILTER | | | | | |
|* 11 | TABLE ACCESS FULL| T_D_VIDEO_PLAYER | 1 | 15 | 3 (0)| 00:00:01 |
-------------------------------------------------------------------------------------------- 对tuning不是很擅长,求高手指点下,如何得到之前比较详细的执行计划,需要做什么配置吗? tuning
两次的sql是不一样,我随便举个例子。问题是,现在的执行计划的样式和之前的不一样。
我想要这种样式的。
--------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------------------------
两次的sql是不一样,我随便举个例子。问题是,现在的执行计划的样式和之前的不一样。
我想要这种样式的。
--------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------------------------
然后select * from dual;
??????
SQL> set autotrace traceonly
SQL> set timing on
SQL> select *
2 FROM gl_je_headers a
3 ,gl_je_lines b
4 WHERE a.je_header_id = b.je_header_id;已选择283905行已用时间: 00: 01: 49.04执行计划
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=1930 Card=253350 Byt
es=96273000) 1 0 HASH JOIN (Cost=1930 Card=253350 Bytes=96273000)
2 1 TABLE ACCESS (FULL) OF 'GL_JE_HEADERS' (Cost=309 Card=58
250 Bytes=13921750) 3 1 TABLE ACCESS (FULL) OF 'GL_JE_LINES' (Cost=809 Card=2533
50 Bytes=35722350)没有之前那么详细的信息。
--------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-------------------------------------------------------------------------------------------- 不知道为什么
2 select *
3 FROM gl_je_headers a
4 ,gl_je_lines b
5 WHERE a.je_header_id = b.je_header_id;已解释已用时间: 00: 00: 00.02
SQL> select * from table(dbms_xplan.display);已选择16行已用时间: 00: 00: 00.37执行计划
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE
1 0 COLLECTION ITERATOR (PICKLER FETCH) OF 'DISPLAY'