Oracle 11.2.0.2 – Small but important changes

From this version onward the default storage model for XMLType is not CLOB but Binary XML. This has the advantage that due to its Binary XML nature Oracle can optimize XML handling because the format of the XML document or instance is known. Also Oracle can, if possible, transport XML binary format, so smaller in size, data in and out the database if used with the binary XML API’s. Another advantage handling content driven queries, is the possibility of query rewrites or optimizing memory objects, so called XOB objects which are more efficient or smaller in size.

See the Oracle XMLDB Developers Guide 11.2.0.x for more info.

…and this concludes my first post via an Android phone…

;)

m4s0n501
Written by:

6 Comments

  1. Statistique
    9/10/2010

    A small but important change should’t be a small change, right ?!! ;p

  2. mark russel
    4/13/2012

    Unfortunately seems that new XML binary data cannot be replicated through Materialized views nor through Streams.

  3. 4/13/2012

    Depends a bit if you are using Binary XML with or without and XML Schema and/or database version.

  4. mark russel
    4/13/2012

    We’re on 11.2.0.3.
    The database was upgraded from 10.2.0.4.
    The application comprises over 8000 tables each with XMLTYPE column – total size 1TB. No XML schema unfortunatley – it’s vendor application.

    We would like to migrate XMLTYPE storage from CLOB to XML BINARY but we have issue in that many of these tables are replicated to datawarehouse type of database.

    Actually, we’re trying to convince vendor that they MUST migrate CLOB to BINARY XML for other reasons. E.g. less disk resources needed, can take advantage of more efficient LOB architecture – securefiles.

  5. 4/13/2012

    - Binary XML CLOB will be depricated
    – Binary XML CLOB is slower then Securefile on all fronts
    – Binary XML CLOB is less efficient in storage
    – Binary XML Securefile is Oracle’s default from 11.2.0.2 and onwards
    – Binary XML Securefile is way faster regarding content driven XML selects / xpath / xquery than Binary XML CLOB/Basicfile storage by default.

Comments are closed.