DBMS_XPLAN.PREPARE_PLAN_XML_QUERY

Published 21 November 08 12:11 | Striving for Optimal Performance

As of 11.1.0.7 in the package dbms_xplan there is a new function: FUNCTION prepare_plan_xml_query(plan_query IN VARCHAR2) RETURN VARCHAR2; Simply put, the function takes as input a query that extract information from a plan table (e.g. plan_table or v$sql_plan) and builds a query based on SQLX functions that returns the output of the input query in XML. Let’s have [...]