For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
good morning
I've just installed SQldeveloper 17.4, but doesn't work "Explain Plan"
AND If I try again "Explain Plan" it asks me to commit and it still doesn't work, Is this correct?
Hi
tested with 17.3.x and works with F10 and the Icon for explainplan.
Found new
Bug 27362078 : AUTOTRACE/EXPLAIN PLAN NOT WORKING WHEN OTHER XML COLUMN ENABLED
regards
yes, if you config the plan preferences to avoid this bug, F10 works with no problems
There was a thread about it couple weeks ago or so. Here is the summary:
1. To reproduce create plan_table like this:
https://www.cs.put.poznan.pl/rwrembel/utlxplan9i.sql
2. The java log window would exhibit messages like this:
CPU_COST=Invalid column name
DEPTH=Invalid column name
IO_COST=Invalid column name
OBJECT_ALIAS=Invalid column name
QBLOCK_NAME=Invalid column name
TEMP_SPACE=Invalid column name
TIME=Invalid column name
together with the symptoms reported by OP
To fix this please drop plan table in your local schema, while we (oracle) will take care of better error message or fix in the next release.
ok thanks, how i've to confing my preferences
Unfortunately I am still getting this. I have removed the the reference to XML columns in config, and restarted.
executing explain plan still fails with any graphical output
executing the following still works however
set autotrace on
select * from user_users;
Please create your own thread for your own issue and provide all of your particulars there.
I've downgrade to 17.3
beaten
I get this error without having any local plan table.
I retested
I have sqldeveloper 17.4.0.355.
I have an select... -> If I press F10 -> expain plan opened?
Are you sure not running into: Bug 27362078 : AUTOTRACE/EXPLAIN PLAN NOT WORKING WHEN OTHER XML COLUMN ENABLED
