Autotrace And Explain Plan Not Functional When Using The "Other XML Column" Option
Last updated on JANUARY 22, 2018
Applies to:Oracle SQL Developer - Version 17.4 and later
Information in this document applies to any platform.
In SQL Developer Autotrace/Explain plan becomes unfunctional when tracing is run with "Other XML Column", but works with the preferences set to "Other XML Branch".
There is no error message, except a warning message.
1. Choose option Tools -> Preferences -> Database -> Autotrace/Explain plan-->"Other XML Column"
2. Uncheck option under Tools -> Preferences -> Database ->Autotrace/Explain plan-->"Other XML Branch"
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms