Skip to Main Content

SQL Developer

Announcement

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!

[21.4.3] Error obtaining explain plan - Failed to query plan_table: node has no children

Filipe MestreMay 24 2022 — edited May 24 2022

Hello,

Every query i try to get the explain plan using the SQL Developer button always throws the error displayed in the following image:
image.pngAfter clicking OK it displays the plan but without the costs and cardinality:
image.png
Tried the same on a new clean copy of SQL Developer but the same error appears.
Obtaining the explain plan by querying the PLAN_TABLE works as expected:
image.png
I'm using the latest SQL Developer version - v21.4.3.063
Would appreciate some help.
Regards,
Filipe

This post has been answered by Vadim Tropashko-Oracle on May 24 2022
Jump to Answer

Comments

Post Details

Added on May 24 2022
2 comments
1,170 views