Showing Cached Plans in XML

The show_cached_plan_in_xml function returns a showplan output in XML for a statement in cache.

You must enable the statement cache before using show_cached_plan_in_xml.

See "Displaying Query Optimization Strategies and Estimates" in the Performance and Tuning Series: Query Processing and Abstract Plans