ORACLE执行计划标示符无效

来源：互联网发布：java 双向链表编辑：程序博客网时间：2024/06/06 22:58

1、drop table PLAN_TABLE ;

2、拷贝D:\app\client\Steven\product\12.1.0\client_1\RDBMS\ADMIN\utlxplan.sql里的SQL语句，去掉sharing=none

3、SET AUTOTRACE ON

SQL> SET AUTOTRACE ONSQL> 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即可

0 0