[Oracle]查看SQL的执行计划

数据库|mysql教程

Oracle,查看,SQL,执行,计划,SQL,SET,AU

数据库-mysql教程

免费二级域名分发源码,ubuntu底下删除文件,java 常用爬虫框架,php map key,龙岩seo定制lzw

SQL SET AUTOTRACE ON SQL SELECT SYSDATE FROM DUAL; SYSDATE ————– 26-9月-12 执行计划 ———————————————————- ERROR:anuncaughterror in function displayhashappened;pleasecontactOracle support Please

html5 demo源码下载,vscode缩小字体快捷键,ubuntu上网本,tomcat服务器破解,爬虫搜商品,php 自然语言处理,seo关键词快速排哪家好lzw

良精 源码,ubuntu登录界面切换,tomcat8中文,爬虫高老师,php 网站会员关注功能,seo68686688lzw

SQL> SET AUTOTRACE ON

SQL> SELECT SYSDATE FROM DUAL;

SYSDATE

————–

26-9月 -12

执行计划

———————————————————-

ERROR: an uncaught error in function display has happened; please contact Oracle

support

Please provide also a DMP file of the used plan table PLAN_TABLE

ORA-00904: “OTHER_TAG”: 标识符无效

统计信息

———————————————————-

0 recursive calls

0 db block gets

0 consistent gets

0 physical reads

0 redo size

347 bytes sent via SQL*Net to client

338 bytes received via SQL*Net from client

2 SQL*Net roundtrips to/from client

0 sorts (memory)

0 sorts (disk)

1 rows processed

解决方法：

Need to recreate or upgrade the plan table, it is still the 8i one.

Please drop the table and run

SQL> drop table PLAN_TABLE ;

表已删除。

SQL> @C:\oracle\product\10.2.0\client_2\RDBMS\ADMIN\utlxplan.sql

表已创建。

SQL> SET AUTOTRACE ON

SQL> SELECT SYSDATE FROM DUAL;

SYSDATE

————–

26-9月 -12

执行计划

———————————————————-

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 |

—————————————————————–

统计信息

———————————————————-

0 recursive calls

0 db block gets

0 consistent gets

0 physical reads

0 redo size

347 bytes sent via SQL*Net to client

338 bytes received via SQL*Net from client

2 SQL*Net roundtrips to/from client

0 sorts (memory)

0 sorts (disk)

1 rows processed

SQL>

ps：查看执行计划，也可以是使用 [Oracle]如何查看SQL的执行计划

– DBMS_XPLAN Package

如果觉得《[Oracle]查看SQL的执行计划》对你有帮助，请点赞、收藏，并留下你的观点哦！