Autotrace And Explain Plan Not Functional When Using The "Other XML Column" Option
(Doc ID 2349053.1)
Last updated on MAY 30, 2023
Applies to:
Oracle SQL Developer - Version 17.4 to 17.4Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
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.
Other XML Column works in older release of SQL Developer(likely 17.3.1 or older).
Changes
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"
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |