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; |
72735