1、查看执行计划：
sql> set autotrace traceonly explain;
sql> select * from v$tablesapce;
执行计划
执行计划
----------------------------------------------------------
-----------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)|
-----------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 56 | 0 (0)|
| 1 | FIXED TABLE FULL| X$KCCTS | 1 | 56 | 0 (0)|
-----------------------------------------------------------------
Note
-----
- 'PLAN_TABLE' is old version
2、
阅读(1075) | 评论(0) | 转发(0) |
