入门问题 explain plan ....

显示全部楼层 · 2006-12-13 17:04:38

explain plan for select * from dual;
之后仅显示 explained
也就是往plan_table 插入了记录
怎么才能象在
set autotrace on 状态下
显示出 plan 与statistics

千问 · 2006-12-13 17:04:38

You can then select the execution plan from PLAN_TABLE

千问 · 2006-12-13 17:04:38

sys@PENG>explain plan for select count(*) from test;
已解释。
sys@PENG>SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY());
PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------
--------------------
Plan hash value: 496446242
--------------------------------------------------------------------
| Id| Operation| Name| Rows| Cost (%CPU)| Time |
--------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 1 (0)| 00:00:01 |
| 1 |SORT AGGREGATE| | 1 |
|
|
| 2 | INDEX FULL SCAN| PK_TEST | 100 | 1 (0)| 00:00:01 |
--------------------------------------------------------------------
已选择9行。

千问 · 2006-12-13 17:04:38

SQL> explain plan for select count(*) from sbdb_rtarch;
Explained
SQL> SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY());
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
---------------------------------------------
----------
10 rows selected

为什么查不出东西

千问 · 2006-12-13 17:04:38

哪位解答一下,3q

千问 · 2006-12-13 17:04:38

最初由 siice 发布
[B]SQL> explain plan for select count(*) from sbdb_rtarch;
Explained
SQL> SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY());
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
---------------------------------------------
----------
10 rows selected

为什么查不出东西 [/B]
不是不设置了AUTOTRACE TRACEONLY?