ORACLE执行计划标示符无效

1、drop table PLAN_TABLE ;

2、拷贝D:appclientStevenproduct12.1.0client_1RDBMSADMINutlxplan.sql里的SQL语句，去掉sharing=none

3、SETAUTOTRACEON

SQL> SET AUTOTRACE ON
SQL> SELECT SYSDATE FROM DUAL;

SYSDATE
--------------
15-10月-16


执行计划
----------------------------------------------------------
Plan hash value: 1388734953

-----------------------------------------------------------------
| Id  | Operation        | Name | Rows  | Cost (%CPU)| Time     |
-----------------------------------------------------------------
|   0 | SELECT STATEMENT |      |     1 |     2   (0)| 00:00:01 |
|   1 |  FAST DUAL       |      |     1 |     2   (0)| 00:00:01 |
-----------------------------------------------------------------


统计信息
----------------------------------------------------------
          1  recursive calls
          0  db block gets
          0  consistent gets
          0  physical reads
          0  redo size
        531  bytes sent via SQL*Net to client
        520  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          1  rows processed

2、Toad查看计划

接着输入SQL语句按CTRL+E即可

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!