Oracle SYS_XMLGEN
The example shows the use of SYS_XMLAGG and SYS_XMLGEN function to output the rowcache parameters (from the query) in an XML format. The output can be spooled to create an xml file. Without the SYS_XMLAGG function, each parameter will be output as a seperate xml entity (can be output to a seperate xml file).

SELECT SYS_XMLAGG(SYS_XMLGEN(q_tab.parameter))
FROM
(SELECT parameter FROM V$ROWCACHE
WHERE gets > 0
GROUP BY parameter) q_tab;


Back


Oracle registered trademark of Oracle Corporation.
Last Revised On: November 01, 2013

  1082