开发者

SQL Developer explain plan broken

开发者 https://www.devze.com 2023-01-11 00:43 出处:网络
Trying to generate an explain plan in SQL Developer, the program puts up a message box 开发者_StackOverflow社区with title \"failed to query plan_table\" complaining \"invalid column name\". The plan i

Trying to generate an explain plan in SQL Developer, the program puts up a message box 开发者_StackOverflow社区with title "failed to query plan_table" complaining "invalid column name". The plan is not generated or displayed. How to fix?


Execute this sql statement:

drop table plan_table

SQL Developer automatically regenerated the proper table & displayed the correct plan after pressing F6 again.


Normally PLAN_TABLE is a public synonym pointing to a table owned by SYS (e.g. SYS.PLAN_TABLE$ in 11g.)

If you have recently upgraded the database, the plan_table is likely still "old" and needs to be upgraded (by the dba)

Each user should not have to worry about creating their own plan_table.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号