Error: cannot fetch last explain plan from PLAN_TABLE 错误心得
操作步骤如下
通过pl/sql developer ,开了一个SQL window 执行explain plan set statement_id='st2' for select * from ZONE_LOCATION t where t.zonecode = '50010110';接着又开了一个SQL window查看执行计划,select * from table(dbms_xplan.display());
没有看到执行计划,看到返回“Error: cannot fetch last explain plan from PLAN_TABLE”,比较奇怪。
我又开了一个command window ,在同一个command window 里执行explain plan set statement_id='st2' for select * from ZONE_LOCATION t where t.zonecode = '50010110';,然后执行SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY());能得到执行计划。
结论:必须在同一个sql window 里执行explain plan和select * from table(dbms_xplan.display());才能查到执行计划,否则会提示“Error: cannot fetch last explain plan from PLAN_TABLE”
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25027760/viewspace-721184/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25027760/viewspace-721184/