Oracle 解决'PLAN_TABLE' is old version问题
来源:互联网 发布:网易邮箱端口号 编辑:程序博客网 时间:2024/06/05 08:12
使用数据库查看执行计划报’PLAN_TABLE’ is old version错误。
查找资料发现,曾经使用toad的执行计划分析,所以执行了它自带的脚本生成的plan_table
解决方式:重新创建plan_table表.
...上面省略...Note----- - 'PLAN_TABLE' is old versionStatistics---------------------------------------------------------- 41 recursive calls 0 db block gets 186 consistent gets 0 physical reads 0 redo size 1050 bytes sent via SQL*Net to client 487 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 2 sorts (memory) 0 sorts (disk) 11 rows processedSQL> drop table PLAN_TABLE;Table dropped.Elapsed: 00:00:02.22SQL> @?/rdbms/admin/utlxplanTable created.
再次查看执行计划,发现问题得以解决。
0 0
- Oracle 解决'PLAN_TABLE' is old version问题
- 解决 'PLAN_TABLE' is old version
- 'PLAN_TABLE' is old version
- Oracle 执行计划 提示 'PLAN_TABLE' is old version 解决方法
- Oracle之SQL优化: plan_table is old version
- -'PLAN_TABLE' is old version
- 'PLAN_TABLE' is old version处理方法-删除当前用户下的PLAN_TABLE
- 解决Plugin is too old,please update to a more recent version,or set ANDROID_DAILY_OVERRIDE..
- 解决Plugin is too old,please update to a more recent version,or set ANDROID_DAILY_OVERRIDE..
- 解决Plugin is too old, please update to a more recent version, or set ANDROID_DAILY_OVERRIDE
- 解决“Plugin is too old, please update to a more recent version, or set ANDROID_DAILY_OVERRIDE environ”
- 解决Plugin is too old,please update to a more recent version, or set ANDROID_DAILY_OVERRIDE environm
- 解决Plugin is too old, please update to a more recent version
- 已解决 The SDK platform-tools version(20) is too old to check APIs compiled with ...
- Your flex version is too old.
- sdk platform-tools version is too old
- 18. 优雅解决The android gradle plugin version 3.0.0-alpha1 is too old, update to the latest version
- 优雅解决The android gradle plugin version 3.0.0-alpha1 is too old, update to the latest version
- Mongodb安装 for windows7 64位
- 基于TCP协议的网络编程学习笔记(1)
- 使用mysql 统计函数 结果为null时返回值改为0
- Eclipse调试:F5、F6、F7、F8
- 个人开源项目(学习与研究)
- Oracle 解决'PLAN_TABLE' is old version问题
- java中 stack与和heap的区别
- Android中Canvas绘图基础详解(附源码下载)
- 线程同步 总结 内核对象
- Android 增强版百分比布局库
- JAVA--静态修饰符(static)理解
- 宠物、计划生育、宜特居
- mongoDB入门必读(概念与实战并重)
- C#学前热身