Just to start of the 11gR2 series, he the first small “howto” post regarding the new features in Oracle 11gR2. The 11gR2 database supports now 3 binary XML partitioning options. Partitioning has great advantages if you are dealing with huge volumes of XML data. Those advantages are mainly regarding maintenance, for instance updating/refreshing data, or the local partitioning index that belongs to the specific partition you want to alter.
Binary XML XMLType should be used, most of the time, if you are dealing with content/data driven environments (XML Schema based) or document driven (if XML Schema less). The following 3 options are now available:
XML Partitioning is based on a column or a virtual column and is defined via the XMLTABLE function / syntax. You are allowed to pass on a XML resultset / fragment into the next nested XMLTABLE syntax, but only once. See the Oracle XMLDB Developers Guides for more information.