使用数据库查看执行计划报’PLAN_TABLE’ is old version错误。
查找资料发现,曾经使用toad的执行计划分析,所以执行了它自带的脚本生成的plan_table
解决方式:重新创建plan_table表.
...上面省略...
Note
-----
- 'PLAN_TABLE' is old version
Statistics
----------------------------------------------------------
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